My mysql load is take huge cpu 700% !!!
Hi
i have big problem in my server
mysql is high load its arrive to up to 700% cpu
[COLOR="#FF0000">top - 01:00:06 up 4 days, 16:21, 1 user, load average: 1.12, 1.64, 1.94
Tasks: 367 total, 1 running, 365 sleeping, 0 stopped, 1 zombie
Cpu(s): 13.0%us, 3.7%sy, 0.0%ni, 83.1%id, 0.2%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 16226852k total, 10987852k used, 5239000k free, 1415308k buffers
Swap: 2097144k total, 14028k used, 2083116k free, 8007220k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3419 mysql 20 0 4404m 263m 5872 S 117.8 1.7 26576:26 mysqld
2942 zonanetw 20 0 15296 1508 952 R 0.7 0.0 0:01.51 top
12202 nobody 20 0 67016 3540 1936 S 0.3 0.0 0:00.13 httpd
18774 zonanetw 20 0 166m 7776 4804 S 0.3 0.0 0:00.08 php
my current visitors is 200:250 in moment
when my website is working the visitors may be 1000:3000 in moment
can anyone help me ?
-
Login to WHM>>>>>"Show mysql processes" and see what's causing the heavy load. Also check WHM>>>>Apache status to see if there is a spike in connections, are most coming from just one IP perhaps? Run ( or install) "Mytop" a script like "top" for Mysql. 0 -
[quote="kernow, post: 1675841">Login to WHM>>>>>"Show mysql processes" and see what's causing the heavy load. Also check WHM>>>>Apache status to see if there is a spike in connections, are most coming from just one IP perhaps? Run ( or install) "Mytop" a script like "top" for Mysql.
thx i have checked "Show mysql processes" all requests time is between 0:1 sleep is between 25:500 my.cnf file [COLOR="#FF0000">[mysqld] innodb_file_per_table=1 max_allowed_packet=268435456 i think the "Apache status" is normal0 -
Hello :) The following command should help you determine which databases/tables are the most active: mysqladmin processlist
You may also find this thread helpful: Troubleshooting High Load On Linux Servers Thank you.0
Please sign in to leave a comment.
Comments
3 comments