Hi All,
I have noticed huge spikes in server load recently. Load
average sometimes hits 50.0 ; however after removing unwanted mail
alerts from cron load has dropped to 2.0 to 5.0; I guess even 2.0 is
a high load for the kind of usage I have. Mysqld seems to top in CPU
usage.
mysqladmin processlist always reports a dead thread. How do I flush
these dead threads ?
[root@hashcube ~]# mysqladmin processlist
+--------+-----------+-----------+---------------+---------+--------+--------------+-------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time |
State |
Info
|
+--------+-----------+-----------+---------------+---------+--------+--------------+-------------------------------------------------------------------------------+
| 71635 | ugenius | localhost | sometable | Query | 213525 | *** DEAD
*** | SELECT * FROM sometable where level='med' ORDER BY t |
| 645308 | root | localhost | | Query | 0
| | show
processlist |
+--------+-----------+-----------+---------------+---------+--------+--------------+-------------------------------------------------------------------------------+
iostat reports the following
# iostat -x 4
Linux 2.6.22.16-RH2206 (sudoku-solver.net) 06/16/2008
avg-cpu: %user %nice %system %iowait %steal %idle
11.43 0.02 3.22 17.33 0.00 68.00
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s
avgrq-sz avgqu-sz await svctm %util
avg-cpu: %user %nice %system %iowait %steal %idle
7.88 0.00 2.56 1.13 0.00 88.43
Any suggestions on improving the server performance ? What else should
I monitor ? I guess mysql is the culprit... any suggestions on
optimizing ?
Thanks
Deepan