1

heavy load on mysql

view story
linux-howto

http://serverfault.com – i have dedicated server with very good configuation like 16 gb ram etc but i am facing heavy load from mysql i am running a music wesbite however only one database is running and 5-10 pages are only running.when i click on whm show processlist it shows only 2-3 processes However whm load is always less than one but when i click on whm load it shows 20% of cpu usage by mysql and after some time it starts saying can not connect to mysql . mysql server has gone away 1691 (Trace) (Kill) mysql 0 19.2 2.7 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log- (HowTos)

xskl's picture
Submitted by xskl on 10/20/2012

Stories similar to heavy load on mysql

very high load mysql load seen for 5-6 hours daily, when daily compressed backups run. load seems to be with mysql process. Typical ps snaphot is as;

mysql 6896 14.2 4.0 802300 373804 ?

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.example.com.err --open-files-limit=20000 --pid-file=/var/lib/mysql/server1.example.com.pid

Memory is at %10 always and Cpu at %1 Also /usr/local/apache/bin/httpd -k start -DSSL I have like 10 of them running

MySQL process explanation 24 weeks 6 days ago

I have one MySQL process on my server running linux and it's always running it takes at least 50% usage of 1 Core (I have 8 cores)... This is process command:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid

What this process is doing? This is not the issue just a question.

I have recently noticed that my MySQL server consumes abnormally large amount of CPU resources:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2427 mysql 20 0 2198m 161m 5568 S 1600.0 4.4 5121391h /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql

I am attaching two files - one with my MySQL configuration and another with the mysqlreport output.

server taking high cpu usage load average: 108.87, 105.92, 85.82

netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

Reselt showing too much connect from server IP

cpanel Process Manager showing

19.4 | 0.5 | /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/zebra546.serverstall.com.err --pid-file=/var/lib/mysql/zebra546.servers

I'm running a php website. I have two servers.

Please help me to check is this Mysql Database Server load too high? I found the mysql CPU usage is always higher than 100%.

My server hangs everyday

So i checked system health - process manager in whm

there was a command given below

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306

see this image

here this mysql command process is taking

I've been seeing this in Process Manager for some time, for months actually, but I don't know what it is and would like to know.

It has my hostname in it.

Quote:

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.xxxxx.xxx.err --pid-file=/var/lib/mysql/xxx.xxxxx.xxx.pid

I have the following problem: I cant get etherpad running, when my firewall rules are active.

My firewall: http://pastebin.com/82APzKhi

telnet localhost 3306 gives connection timeout

ps aux | grep mysql:

root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 15526 0.7 0.9 426056 75392 ?