Hello,
My mysql server sometime just slows responding to database queries....It
is as slow as less than 1 per sec.
But it speeds up by itself after some time , I have noticed that when it
speeds up there are lot more MYsql thread than just one thread when it
is slow.
Here is the top output taken in both the above scenarios ...
###############
Slow MySQL top
##############
top - 10:29:36 up 12 days, 23:20, 10 users, load average: 1.53, 1.47, 1.51
Tasks: 157 total, 2 running, 155 sleeping, 0 stopped, 0 zombie
Cpu(s): 14.5% us, 5.0% sy, 0.2% ni, 48.3% id, 31.9% wa, 0.2% hi, 0.0% si
Mem: 2073540k total, 2056904k used, 16636k free, 3832k buffers
Swap: 2031608k total, 144k used, 2031464k free, 1453208k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7993 mysql 15 0 35184 21m 2116 D 34.5 1.0 240:45.58 mysqld
50 root 15 0 0 0 0 S 2.0 0.0 36:30.92 kswapd0
2544 root 16 0 181m 177m 2216 S 1.3 8.8 3962:35 Xvnc
8621 root 34 19 7960 4348 1172 R 0.7 0.2 9:25.47 apollonian
12834 root 16 0 7432 2460 1988 S 0.3 0.1 0:00.20 sshd
1 root 16 0 2772 552 476 S 0.0 0.0 0:01.74 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.27 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.02 ksoftirqd/0
###############
Fast MySQL top
##############
top - 16:14:02 up 10 days, 5:05, 12 users, load average: 2.98, 4.60, 5.44
Tasks: 163 total, 2 running, 161 sleeping, 0 stopped, 0 zombie
Cpu(s): 61.1% us, 18.9% sy, 0.0% ni, 19.9% id, 0.0% wa, 0.2% hi, 0.0% si
Mem: 2073540k total, 2017872k used, 55668k free, 8356k buffers
Swap: 2031608k total, 144k used, 2031464k free, 1433084k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2977 root 15 0 546m 187m 15m S 72.7 9.3 1659:08 java
5690 mysql 16 0 35076 21m 2116 S 15.9 1.1 262:54.15 mysqld
5667 mysql 15 0 35076 21m 2116 S 15.5 1.1 349:34.94 mysqld
5678 mysql 15 0 35076 21m 2116 S 15.5 1.1 274:47.37 mysqld
5694 mysql 15 0 35076 21m 2116 R 13.6 1.1 484:20.48 mysqld
5650 mysql 15 0 35076 21m 2116 S 12.6 1.1 264:19.89 mysqld
5658 mysql 15 0 35076 21m 2116 S 11.9 1.1 630:14.94 mysqld
9663 root 21 0 229m 20m 7944 S 1.0 1.0 29:53.39 rmiregistry
13349 root 17 0 3280 988 744 S 0.7 0.0 0:01.14 top
13366 root 16 0 2808 992 744 R 0.7 0.0 0:00.05 top
502 root 16 0 3204 992 748 S 0.3 0.0 24:36.05 top
11521 root 16 0 97156 31m 17m S 0.3 1.6 1:53.46 firefox-bin
1 root 16 0 2772 552 476 S 0.0 0.0 0:01.52 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.24 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.02 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.23 migration/1
Cheers,
Ritesh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
