rendered paste bodytop - 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