Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

my first time here!

First of all I want to say that I'm not a DBA and I have a very little experience with MySQL but I like to study and understand what I'm doing.

I have a virtual machine (2gb RAM, 1.4 Dual Core CPU) with a mysql server for an online game. I did a very extreme query optimization and now I use index on all of them. I also updated several time my.cnf but the mysqld process is still using a lot of CPU. In normal days (10-15 concurrent users) it's around 70% and in big load days (40-50 users) it's over 150%. Is it a normal value?

I really can't understand why.

More informations: mysql 5.5.31 and MyISAM tables.

That's the my.cnf file

user        = mysql
pid-file    = /var/run/mysqld/
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql
bind-address        =
key_buffer      = 16M
max_allowed_packet  = 16M
thread_stack        = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
max_connections        = 250
max_connect_errors     = 250
event_scheduler = ON
max_heap_table_size = 256M
tmp_table_size = 256M
log_error = /var/log/mysql/error.log
slow_query_log = ON
long_query_time = 3
slow_query_log_file = /var/log/mysql/mysql-slow.log
expire_logs_days    = 10
max_binlog_size         = 100M

I read dozens of answers here and on the web (that's how I get this my.cnf) but I still can't figure out how to reduce the CPU load. Can you help me or suggest where to investigate?

Thanks for your great work here!

share|improve this question
I forgot to say that in "normal days" we run around 2000 queries per minute – lucas47 May 29 '14 at 15:33
High load is a sign that the server is blocked trying to do something. You need to find out what the block is. It might be MySQL (check your processlist for long-running queries), it could be IO, swapping, etc. – Alain Collins Jun 2 '14 at 16:16

Your Answer


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

Browse other questions tagged or ask your own question.