Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a serious problem on my server with MySQL server, it overload itself without any error in


What steps should I do to find out the problem ?

my.cnf is


set-variable = innodb_buffer_pool_size=256M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_log_file_size=128M
set-variable = innodb_log_buffer_size=8M
innodb_data_file_path = ibdata1:1000M:autoextend

Please help, thx

share|improve this question
what do you mean by overload? – pQd Jan 4 '10 at 9:57
top shows 200% of CPU usage – beny Jan 4 '10 at 10:20

A good place to start in a situation like this would simply be to open up the mysql program, connect, then run this:

$ show processlist;

That will give you a list of processes running. From there you should be able to see what process is sucking up all the cpu. You can also run "show full processlist" to see the whole command if it is cut off. Phpmyadmin makes this a little easier by clicking on "processes" on the main page. You can even kill processes by specifying the pid.

If you can't figure out why it is overloading from this information, you should turn on the query log and slow query log and examine what the mysql server is being asked to do:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.