top - 02:27:18 up 2 days, 21:39, 2 users, load average: 3.25, 2.98, 3.10 Tasks: 243 total, 3 running, 239 sleeping, 1 stopped, 0 zombie Cpu(s): 23.8% us, 25.2% sy, 0.0% ni, 47.3% id, 3.7% wa, 0.0% hi, 0.0% si Mem: 8310548k total, 6214724k used, 2095824k free, 300964k buffers Swap: 2040212k total, 144k used, 2040068k free, 4267756k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 4969 mysql 15 0 253m 236m 2920 S 72 2.9 3415:27 mysqld 19998 nobody 15 0 26760 13m 3500 S 9 0.2 0:10.15 httpd 29670 nobody 15 0 26908 13m 3360 S 7 0.2 0:09.85 httpd 25119 nobody 15 0 26912 13m 3724 S 1 0.2 0:09.85 httpd 19505 nobody 15 0 26692 13m 3800 S 1 0.2 0:12.34 httpd 25838 nobody 16 0 26732 13m 3460 S 1 0.2 0:09.45 httpd 20069 nobody 15 0 26628 13m 3828 S 0 0.2 0:12.60 httpd 19588 root 16 0 2956 1064 760 R 0 0.0 0:00.03 top 1 root 16 0 2332 552 472 S 0 0.0 0:01.12 init 2 root RT 0 0 0 0 S 0 0.0 0:01.29 migration/0 3 root 34 19 0 0 0 S 0 0.0 0:00.02 ksoftirqd/0 4 root RT 0 0 0 0 S 0 0.0 0:00.62 migration/1 5 root 34 19 0 0 0 S 0 0.0 0:00.03 ksoftirqd/1 6 root 5 -10 0 0 0 S 0 0.0 0:00.16 events/0 avg-cpu: %user %nice %sys %iowait %idle 33.90 0.44 27.53 3.23 34.90 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda 82.58 132.13 1317.93 33138701 330543378 sda1 0.01 0.01 0.00 1705 44 sda2 10.09 7.21 78.59 1807219 19710054 sda3 121.41 23.05 966.47 5782003 242394618 sda4 0.00 0.00 0.00 2 0 sda5 3.79 0.45 30.08 112066 7545264 sda6 28.40 101.36 209.52 25421851 52549670 sda7 4.17 0.05 33.26 11638 8342840 sda8 0.00 0.00 0.00 1073 288 sdb 0.97 38.05 177.70 9542596 44568128 sdb1 22.75 38.04 177.70 9541156 44567648 vmstat 3 procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 1 0 144 2099704 300980 4268000 0 0 43 374 8 3 34 28 35 3 2 0 144 2099576 300984 4267996 0 0 0 393 1163 4066 45 27 28 0 1 0 144 2099768 300984 4267996 0 0 4 69 1107 1274 33 30 36 0 2 0 144 2099640 300984 4267996 0 0 1 569 1183 899 29 32 33 6 0 0 144 2100480 300984 4267996 0 0 0 252 1204 2614 31 28 37 4 1 0 144 2099008 300984 4267996 0 0 0 215 1102 972 29 30 40 1 my.cnf [mysqld] socket = /var/lib/mysql/mysql.sock safe-show-database back_log = 50 skip-innodb key_buffer = 16M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M max_connections = 64 max_connect_errors = 10 max_allowed_packet = 6M myisam_sort_buffer_size = 64M interactive_timeout = 20 wait_timeout = 20 connect_timeout = 6 record_buffer = 1M read_rnd_buffer_size = 2M thread_cache = 6 thread_cache_size = 32 query_cache_type = 1 query_cache_limit = 5M query_cache_size = 200M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2