56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> EXPLAIN SELECT * FROM player WHERE id =124;
+----+-------------+--------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+-------+---------------+---------+---------+-------+------+-------+
| 1 | SIMPLE | player | const | PRIMARY | PRIMARY | 4 | const | 1 | |
+----+-------------+--------+-------+---------------+---------+---------+-------+------+-------+
1 row in set (0.00 sec)
[root@LMQGameDB01 ~]# iostat -x 2
Linux 2.6.32-431.29.2.el6.x86_64 (LMQGameDB01) 06/26/2015 _x86_64_ (8 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
0.04 0.00 0.06 2.90 0.00 97.01
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sdb 0.00 0.57 0.00 0.03 0.00 4.75 183.71 0.00 12.70 0.24 0.00
sdc 0.05 25.22 0.40 17.20 50.61 339.02 22.15 0.45 25.71 11.75 20.67
sda 0.00 0.21 0.01 0.14 0.42 2.80 20.98 0.01 51.96 28.48 0.44
sdd 0.00 3.14 0.01 0.68 0.11 29.84 43.09 0.07 97.54 14.47 1.01
sde 0.00 3.09 0.01 0.63 0.11 29.03 45.46 0.05 79.66 13.31 0.85
sdf 0.00 2.88 0.01 0.63 0.11 27.30 42.73 0.06 99.25 12.75 0.82
md127 0.00 0.00 0.04 10.77 0.31 86.17 8.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
0.06 0.00 0.13 2.02 0.00 97.79
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sdb 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sdc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda 0.00 229.50 0.00 87.00 0.00 2536.00 29.15 16.21 186.31 2.63 22.85
sdd 0.00 0.50 0.00 2.00 0.00 12.00 6.00 0.02 12.25 12.25 2.45
sde 0.00 2.00 0.00 3.00 0.00 32.00 10.67 0.03 10.50 10.50 3.15
sdf 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.50 0.50 0.05
md127 0.00 0.00 0.00 5.50 0.00 44.00 8.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
0.19 0.00 0.00 1.83 0.00 97.98
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sdb 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sdc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sdd 0.00 17.50 0.00 4.00 0.00 164.00 41.00 0.15 37.88 35.88 14.35
sde 0.00 3.50 0.00 3.00 0.00 44.00 14.67 0.03 8.83 8.83 2.65
sdf 0.00 3.50 0.00 1.50 0.00 32.00 21.33 0.01 7.67 7.67 1.15
md127 0.00 0.00 0.00 30.00 0.00 240.00 8.00 0.00 0.00 0.00 0.00
求求大哥帮忙看一下,谢谢啦!