Mysql process goes over 100% of CPU usage
- by Temnovit
Hello!
I'm experiencing some problems with my LAMP server. Recently, everything became very slow, even though visitor count on my websites didn't change to much. When I run top command, it sais that mysql process has taken over 150-200% of CPU. How's that possible, I always thought that 100% is a maximum? 
I'm running Ubuntu 9.04 server edition with 1,5 GB RAM
my.cnf settings:
key_buffer      = 64M
max_allowed_packet  = 16M
thread_stack        = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
max_connections        = 200
table_cache            = 512
table_definition_cache = 512
thread_concurrency     = 2
read_buffer_size = 1M
sort_buffer_size = 4M
join_buffer_size = 1M
query_cache_limit   = 1M  # the maximum size of individual query results
query_cache_size    = 128M
Here is the output of MySQLTuner:
The top command:
What could be the cause of this problem? Can I make changes to my my.cnf to prevent server from hanging?