Mysql 磁盘IO过高

今天在spotlight上看到磁盘IO过高的报警，登录服务器查看具体磁盘IO情况：

[root@hbwb-008 ~]# iostat -dxk 1

磁盘util%使用率100%。首先怀疑是慢查询语句导致，查看MYSQL慢查询情况：

mysql> show processlist;
+-------+-------------+---------------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+
| Id    | User        | Host                | db   | Command | Time   | State                                                                       | Info             |
+-------+-------------+---------------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+
|     1 | system user |                     | NULL | Connect | 674754 | Waiting for master to send event                                            | NULL             |
|     2 | system user |                     | NULL | Connect |      0 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL             |
|  5504 | root        | 192.168.5.161:38765 | wbdb | Sleep   |      1 |                                                                             | NULL             |
|  5746 | root        | 192.168.5.161:40800 | wbdb | Sleep