I have a similar problem. Load averages are high and go up to 12 and even more.
Code:
[root@server /]# top
top - 12:27:08 up 19 days, 16:46, 1 user, load average: 8.92, 10.71, 10.21
Tasks: 153 total, 9 running, 141 sleeping, 0 stopped, 3 zombie
Cpu(s): 85.4% us, 14.5% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.2% hi, 0.0% si
Mem: 6231956k total, 5745236k used, 486720k free, 175492k buffers
Swap: 2040212k total, 5388k used, 2034824k free, 2688300k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29025 root 15 0 1388m 226m 3616 S 120.0 3.7 129:10.71 mysqld
(mysql is causing it)
This are the red marked variables from phpMyAdmin runtime information
Code:
Slow_queries 14 k
Innodb_buffer_pool_reads 33
Handler_read_rnd 24 M
Handler_read_rnd_next 3,316.21 M
Slow_launch_threads 2
Created_tmp_disk_tables 3,624
Select_full_join 621
Select_range_check 1
Opened_tables 12 k
Table_locks_waited 17 k
Handler_read_rnd_next seems to be very high. phpmyadmin suggests that there is something wrong with indexing of tables (not using them or badly made). the table is indexed properly i believe.
If someone had a similar issue, it would help.
Any help is aprecciated!