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 ?


[EMAIL PROTECTED] ~]# 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






_______________________________________________
To unsubscribe, email [EMAIL PROTECTED] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Reply via email to