I've a small reseller account with cPanel with 5 sites. After transfering to other host (full cPanel backup of old sites, restoring on new host) cPanel of 2 sites still displays the version number of the old host, the other 3 sites are correct.
CP1: correct - CP2: wrong
I have recently upgraded MySQL to 5.25
However, when I run phpinfo, I see the following:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
mysqli
MysqlI Support enabled
Client API library version 4.1.21
Client API header version 4.1.20
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
Are there particular version of mysql or apache that are best suited when you want to utilize a multi-core/multi-cpu system? For example, we are currently using apache 1.3 and am not sure if it has the inherent ability to use multiple cpus to its benefit.
Or would the fact that it spawns child processes take advantage as the processes will be spawned on the different CPUs?
to upgrade the PHP and MySql versions our shared hosting ocmpany is offering. We are now at PHP 4.3 and MySQL 4.014 I need to bring it up to PHP and MySQL 5.xx versions.
Has anyone done this and if so what gotchas should I look for? what is the suggestes upgrade path not to affect clients using the older versions?
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
I'm desperately trying to find a hosting service that offers Linux hosting with latest versions of php (5.2.x), mySQL (5.1) and maybe CVS or SVN?
Space or bandwidth are not an issue (500mb space will be more than I'll ever need)
This will mainly will be a development/testing place.
I really need a host that actually updates to latest versions of php/mysql/apache.
(not the next day the upgrade is out but some time soon at least >_<)
Things like CVS / SVN, SSH access and access to change your own php.ini settings are more than welcome but I could live without.
I just upgraded to the latest version of APF. I am running CentOS with the 2.6 kernel.
I added my ports to allow, started it up, and it does not seem to be blocking anything.
I get no errors on startup though. If i do an nmap, mysql shows up as open still. I can even telnet to it.
root@me [~]# /usr/local/sbin/apf -r
apf(6367): {glob} flushing
my server is jammed and takes minutes to load simple pages, can you please take a look ath the following image, its show under "CPU %" for mysql 177, does that mean mysql is using 177% of resources of cpu?
View 3 Replies View RelatedI have a mysql-only server and the server is constantly > 30 in server load. I'm ousted as to what is wrong with mysql and what can be done to optimize it. Using mysql report to generate the following:
Quote:
MySQL 4.1.22-standard uptime 0 0:22:30 Thu Feb 22 07:14:45 2007
__ Key _________________________________________________________________
Buffer used 30.93M of 256.00M %Used: 12.08
Current 60.41M %Usage: 23.60
Write ratio 0.891
Read ratio 0.001
__ Questions ___________________________________________________________
Total 416.13k 308.2/s
DMS 136.54k 101.1/s %Total: 32.81
Com_ 120.17k 89.0/s 28.88
COM_QUIT 117.10k 86.7/s 28.14
QC Hits 44.35k 32.9/s 10.66
-Unknown 2.04k 1.5/s 0.49
Slow 19 0.0/s 0.00 %DMS: 0.01
DMS 136.54k 101.1/s 32.81
SELECT 82.50k 61.1/s 19.82 60.42
UPDATE 27.28k 20.2/s 6.56 19.98
REPLACE 10.85k 8.0/s 2.61 7.95
INSERT 7.98k 5.9/s 1.92 5.84
DELETE 7.93k 5.9/s 1.91 5.81
Com_ 120.17k 89.0/s 28.88
change_db 119.37k 88.4/s 28.69
admin_comma 791 0.6/s 0.19
show_variab 3 0.0/s 0.00
__ SELECT and Sort _____________________________________________________
Scan 6.38k 4.7/s %SELECT: 7.73
Range 6.35k 4.7/s 7.70
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 3.99k 3.0/s
Sort range 9.92k 7.4/s
Sort mrg pass 1.27k 0.9/s
__ Query Cache _________________________________________________________
Memory usage 5.85M of 32.00M %Used: 18.28
Block Fragmnt 22.41%
Hits 44.35k 32.9/s
Inserts 75.31k 55.8/s
Insrtrune 75.31k:1 55.8/s
Hit:Insert 0.59:1
__ Table Locks _________________________________________________________
Waited 54.03k 40.0/s %Total: 31.44
Immediate 117.80k 87.3/s
__ Tables ______________________________________________________________
Open 763 of 1500 %Cache: 50.87
Opened 769 0.6/s
__ Connections _________________________________________________________
Max used 651 of 650 %Max: 100.15
Total 119.74k 88.7/s
__ Created Temp ________________________________________________________
Disk table 24 0.0/s
Table 3.75k 2.8/s
File 2.55k 1.9/s
__ Threads _____________________________________________________________
Running 106 of 132
Cached 36 of 128 %Hit: 96.43
Created 4.28k 3.2/s
Slow 4 0.0/s
__ Aborted _____________________________________________________________
Clients 5.28k 3.9/s
Connects 1.16k 0.9/s
__ Bytes _______________________________________________________________
Sent 2.03G 1.5M/s
Received 159.51M 118.2k/s
And my my.cnf
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 650
key_buffer = 256M
myisam_sort_buffer_size = 64M
skip-locking
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 10
connect_timeout = 5
tmp_table_size = 128M
max_allowed_packet = 36M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
max_user_connections =600
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
I am just trying out MySQL on the external Apache server. I must have written down the wrong password. My commands to enter mysql with a password results in denied access.
What file do I undo in order to create a new password? I don't know the exact steps I'm supposed to take. I don't think this is a MySQL issue, but a server issue, right?
I used to create databases and tables on my regular computer and left off the password altogether while I was practicing. Now I'm taking steps to do it on the actual server, and have run across this problem.
I am trying to fix website [URL] .... I open the site like 20 times a day and like 2 times a day it shows blank page. Which logs I need to check or which tools to use? I have cpanel hosting, apache.
View 1 Replies View RelatedI've got a VPS with XenSmart, and I'm running CentOS. Recently, I have been needing to redirect my users to 'www.', since if they don't put the 'www.' in front of the domain the vB forum doesn't run properly. Though, to do this, I edited the .htaccess file and was using the 'mod_rewrite' command, but this requires Apache.
So, on my VPS I've installed Apache, and set LXAdmin to use 'httpd' instead of 'lighttpd', though now my web pages wont show up and all I've got is the default Apache web page:
[url]
How am I able to use Apache (HTTPD) and have it load my current forum? My current forums hosted in:
/home/admin/public_html/vb
In my web site I have several index pages in different languages in the following format
[URL] ....
Two days ago I noticed increased, many times. Google bot activity on my site and when I checked my log file I found that all pages crawled were wrong web addresses: to the above index were added existing files from my site like
/folder1/folder2/file.html
So, the strings looked like
[URL] ....
And surprisingly all they returned code "200".
My question is: is there any way to rewrite such requests to the first ".html" found in the string.
I don't know why but a domain is showing the green default cpanel page instead of its own homepage. The domain has been hosted on this box for a long time.
DNS is fine, ran udpateuserdomains without error. No dns changes have been made. IP it is set to pings fine. Tested via 3rd party proxy, shows green cpanel page still.
Shows proper IP in httpd.conf
i have an e-mail account that in cpanel shows it has 60 of 90 mb of used space... it had some big emails in the trash folder but i deleted em... in fact i deleted everything from the account (sent, trash, drafts, etc) and it keeps showing 60 of 90 mb of used space ive checked if it was spambox... nothing, spamassasin... nothing i even loged on the server and checked the space of mailbox's folder... but it showed only 500 kb... so i assume its a cpanel issue... how can i fix it?
View 5 Replies View Related