| 敘述句 | 查詢數量 | ø 每小時 | % |
|---|---|---|---|
| select | 994 k | 274.4 k | 78.40 |
| show tables | 70,913 | 19.6 k | 5.60 |
| show fields | 62,281 | 17.2 k | 4.91 |
| change db | 49,906 | 13.8 k | 3.94 |
| set option | 37,737 | 10.4 k | 2.98 |
| show keys | 21,395 | 5,908.4 | 1.69 |
| replace | 9,955 | 2,749.2 | 0.79 |
| show variables | 8,562 | 2,364.5 | 0.68 |
| show create table | 6,065 | 1,674.9 | 0.48 |
| show warnings | 3,085 | 851.9 | 0.24 |
| show storage engines | 2,028 | 560 | 0.16 |
| stmt close | 391 | 108 | 0.03 |
| stmt execute | 391 | 108 | 0.03 |
| stmt prepare | 391 | 108 | 0.03 |
| show table status | 231 | 63.8 | 0.02 |
| show slave status | 70 | 19.3 | 0.01 |
| show master status | 67 | 18.5 | 0.01 |
| insert | 65 | 18 | 0.01 |
| update | 49 | 13.5 | <0.01 |
| show grants | 47 | 13 | <0.01 |
| show binlogs | 35 | 9.7 | <0.01 |
| delete | 31 | 8.6 | <0.01 |
| show status | 12 | 3.3 | <0.01 |
| show engine status | 3 | 0.8 | <0.01 |
| flush | 1 | 0.3 | <0.01 |
| show processlist | 1 | 0.3 | <0.01 |