I have a cheap managed server and support is of little help BUT they will do what I tell them, where should I tell them to start to fix high mysql load?
The server currently has a large IPB forum, a large 4images gallery, and a couple popular Wordpress blogs, and this combo keeps taking mysql down.
What can I do server side to help this? And what shouldn't I do?
My server is a dual cpu quad core box. So I see 8 processors in WHM status page. Load is between 1-2 most of the time, sometimes a little bit above 2.
I've never used a dual cpu quad core machine before. When should I start worrying about the server load? When load is above 8 or what?
after installed php 5.2.10
nobody /usr/local/apache/bin/httpd -k start -DSSL
Code:
5896 nobody 0
81.5
1.3 /usr/local/apache/bin/httpd -k start -DSSL
mysql (5.0.81-community)
os : centos 5.3
Has been very fast server. Guide is accurate and if you leave.
tdot:/# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
.
.
.
.
...failed or took more than 6s.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
tdot:/#
getting the following when trying to start mysql:
Quote:
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
have googled this to death. solutions are not working.
so far have tried the whole linking mysql.sock to the file in /tmp, changing mysql root password, rebooting, adding socket parameters in my.cnf. nothing works!
I am getting this error. Cannot start mysql.
I cannot find any document to fix this issue.
Stopping web server: Apache2.
www:/# /var/wkscript/tools/panel_manager start
LayeredPanel related software starting.Starting system log daemon: syslogd.
Starting periodic command scheduler: cron.
Starting mail transport agent: Postfix.
Starting MySQL database server: mysqld.
.
.
.
.
.
.
.
.
.
.
.
.
.
...failed or took more than 6s.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Starting domain name service: named.
Starting ftp server: Running: /usr/sbin/pure-ftpd-mysql -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -E -O clf:/var/log/pure-ftpd/transfer.log -S 75.126.177.244,21 -u 1000 -B
Starting web server: Apache2.
Starting web server: Apache2.
If you visit the site, the main page gives this error:
Fatal error: Failed to connect to the DB server in /var/wkscript/db.php on line 28
What command could I use to see all the currently running services on my Windows (vista) computer?
I'm trying to start my MySQL server, but it won't start. I think I know what the problem is though I'm not sure. I think that the service name "MySQL" is already running...and I need to remove it or something.
Btw...my apache and php is fine. Though...I cannot use my MySQL from php obviously...since it's not running.
My MySQL server take too much time to start. I moved the data folder to its own hard disk, but still no improvement.
# uptime;date;service mysqld start;date;uptime;service httpd start
05:46:15 up 5 days, 1:24, 2 users, load average: 0.24, 1.07, 1.23
Wed May 7 05:46:15 CDT 2008
Starting MySQL: [ OK ]
Wed May 7 06:04:21 CDT 2008
06:04:21 up 5 days, 1:42, 1 user, load average: 1.77, 1.65, 1.50
Starting httpd: [ OK ]
#
You see MySQL take 18 minutes to start.
This happens whenever i restart the server or restart mysql.
Here is the process while MySQL starts
# ps aux|grep mysql
root 23549 0.0 0.0 4448 1168 pts/0 S+ 05:24 0:00 /bin/sh /sbin/service mysqld start
root 23556 0.0 0.0 4628 1272 pts/0 S+ 05:24 0:00 /bin/bash /etc/init.d/mysqld start
root 23613 1.5 7.5 157668 154580 pts/0 D+ 05:24 0:01 chown -R mysql:mysql /backup/mysql
root 23780 0.0 0.0 3896 664 pts/1 S+ 05:26 0:00 grep mysql
#
It is chown that make the MySQL startup slow.
MySQL data size is about 11 GB.
under the shell on a cpanel server I tried to restart mysql - and it won't restart
/etc/init.d/mysql start
Starting MySQL................................... ERROR!
Where do I even begin to try to fix this?
I can't start MYSQL. How can i fix this?
View 3 Replies View RelatedI just installed mySQL server on a brand new dedicated server and am getting Timeout error occurred trying to start MySQL Daemon. I have uninstalled and reinstalled it a few times and am still getting the same error.
View 11 Replies View RelatedCan anyone recommend a Apached and MYSQL optimization expert? I just some optimization done on mysql and apache upgraded... but pache wouldn't restart with the following entries:
MinSpareThreads 25
MaxSpareThreads 35
ThreadsPerChild 25
if i remove above then it starts... but my CPU spikes and I am getting a ton of errors emailed to me:
Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM vb_session WHERE vb_session.userid>0 AND vb_session.lastactivity>1245294346;
MySQL Error : Out of memory (Needed 8388580 bytes)
Error Number : 5
Request Date : Wednesday, June 17th 2009 @ 09:39:06 PM
Error Date : Wednesday, June 17th 2009 @ 09:39:06 PM
Its constantly complaining about this same query and i thought i removed all of the vbulletin options...
i am pulling my hair out... cuz my server isn't swapping, ther are 0ver 8GBs in cache.... but my CPU goes up
Here is original problem thread...
[url]
2nd post has recommended config... and my subsequent probs
I am getting the error (as listed in the title) on my server. This is a BRAND NEW FRESH install on a brand new server...
OS: Unix Fedora
Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686
Hardware Information: Brand new Dell SC1435 Server
Software Version: MySQl 5
Control Panel: Nothing yet
Apache starts ok but when I go to strart MySQL I get the following error...
[root@server112]# /etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon
Starting MySQL: [FAILED]
Does anyone have any ideas?
I did some pretty extensive searching...
Web Hosting Talk article that basically describes the same error. I followed everything as listed in his suggestion and it didn't change anything.
Also Checked here but this didn't work either.
I have one bare server and installed everything myself. however, I found apache, mysqld can not automatically start after reboot, may I know how to enable them to automatically start after reboot?
View 5 Replies View RelatedAfter an unexpected server shutdown. We cant start mysql anymore.
Error: Could not complete the operation: defpackagemng failed: The process terminated unexpectedly. (Error code 1067) at Start service MySQL
how to tune linux (currently running fedora4) server to improve download speeds for the client. I have observed that if i download from sun it is very fast compared my own server which is hosted on cogent backbone or any other.
Please take into account that both mine and other server both are at relatively same number of hops and ping time. and my server and the carrier has enough bandwidth to fill whole 100mbps, even the client is a server which is on a different backbone which can fill whole 100mbps, also guys i was able to fill whole 100mbps while downloading from sun. but when i download test file from my server it is lagging at 3mbps around. only single thread using wget command. Now what is it i need to do to get my server able to push full pipe even for single thread, ping time is 25ms. if not full at least half. let me know if you have some workaround, and server is apache no load.
Recently we ordered a few servers with soft raid1, but seems the soft raid doesn't perform well, copy a 1G file, it takes about 40 seconds.
also sometimes it takes very very long time, I haven't count it, at least a few minutes, just like the server is dead.
I have run this command.
dd if=/dev/zero of=test.bin bs=1000M count=1
1+0 records in
1+0 records out
1048576000 bytes (1.0 GB) copied, 1.14416 seconds, 916 MB/s
But obviously it takes more more than 1 second, why it shows only takes 1 second?
I'm using two ST31000528AS hard disks.
The newer Pentium 4 3.0 GHz processors had so called 'VT'-support. That's something every regular processor has nowadays.
I currently run a Pentium 4 3.0 GHz server without VT. Will there be a drastic performance boost if I use a Pentium 4 3.0 GHz with VT?
What is VT anyways? I only know that Xen requires it if you wish to host a Windows Virtual Machine on a Xen Linux Server.
I have been reading quite a bit lately about the Internap FCP. I am wondering how much it actually improves network performance and how it compares to BGP4. We currently use BGP4, but are considering using a data center with the Internap FCP for a project for a client.
I am looking for reviews from others who have experience with the Internap FCP and it's performance. How does it compare to a network using BGP4? I know that FCP uses more intelligent routing than BGP, but how big of an improvement does it make?
As per topic, what is the best method to do to the hardware to improve bandwidth / uplink speed of server?
I have a production server that is used for regular file serving.
P4 3.0Ghz
4GB RAM
500GB + 160GB + 160GB hard disk
2Mbps Dedicated + 10Mbps shared.
However, the most I can pulled through the whole server is always between 1.5Mbps - 3Mbps, anyway to pull the speed up to around 10Mbps should there be availability of bandwidth for me to burst?
For any informations, the hard disk is SATA 2.
What steps can we take to improve SpamAssassin performance? I know this was talked about in older Plesk versions, but we may be able to do more now. What configurations can I do to stop more spam?
View 1 Replies View RelatedWe are getting trouble with a site into a dedicadte server, more specific performance issue due to many visitors on same time 1000. Mysql is overload. We would like to use xcache to improve performance, using xcache with plesk 12 centos? its safe, works fine?
View 2 Replies View RelatedI am just a beginner and it is about a month that the mysql loads on my server is so high , I have checked the mysql processlist via cpanel and there is no account that takes high mysql and make it high , and even I have checked for any possible rotten databases. but still the server load is so high and I can not control it , even when I restart it just after a minute it goes up again.
just the spamd command takes a high CPU usage sometimes. what it should be from? the spamd for a special account!
I need to optimize mysql , and need help. please do not tell me to hire an expert , just help me thanks
and another question is that how can I check which account is sending spam and stop it?
I have a dual xeon server that host around 15 small website, but these days I see that the load generated from mysql is very high as you can see below is consumes 32.6 CPU
mysql 32.60 1.20 0.0
how I can know what is the cause of this load?
MySQL.
Quote:
top - 18:43:24 up 18 days, 18:05, 1 user, load average: 145.13, 92.77, 40.84
Tasks: 145 total, 10 running, 134 sleeping, 0 stopped, 1 zombie
Cpu(s): 28.7% us, 70.6% sy, 0.0% ni, 0.0% id, 0.7% wa, 0.1% hi, 0.0% si
Mem: 1034060k total, 605968k used, 428092k free, 21400k buffers
Swap: 1020088k total, 165076k used, 855012k free, 119448k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6102 mysql 16 0 343m 146m 2868 S 364 14.5 1441:52 mysqld
My server almost went dead... until I rebooted MySQL.
MySql die with high load problem?
My server running: Server Load124.40 (2 cpus)[url] Memory Used70 %[url]
Server info:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
Processor #1 speed: 2394.840 MHz
Processor #1 cache size: 4096 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
Processor #2 speed: 2394.840 MHz
Processor #2 cache size: 4096 KB
Memory Information Memory: 4148800k/4718592k available (1883k kernel code, 43336k reserved, 761k data, 188k init, 3275648k highmem)
i'm using Vista RTM, and so then
my PHP module can load mysql 5.0.27.
Apache version: 2.0.55 ( ok )
PHP version: 5.2.0 ( unzip package - ok)
MySQL version: 5.0.27 ( connection is ok only with cmd line )
so, what's the problem.
i tried with this solution:
[url]
but it's take no effect.
what's the step i have been lost?
when mysql has heavy load average what else can be done rather than restarting mysql service.
View 6 Replies View RelatedThere is a problem with mysql and server load. Some how mysql usage is going to over 100, but server load is not increasing, but it is crashing more often.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5931 mysql 16 0 111m 20m 3888 S 71 2.1 10488:45 /usr/sbin/mysqld --basedir=/ --datadir=/var
What could cause the problem? I did mysqladmin pr and only 2 database connections are existing.