Bảng điều khiển
Các câu lệnh |
# |
ø per hour |
% |
|---|---|---|---|
| show grants | 18.316 | 461,2 | <0.01 |
| show create table | 18.095 | 455,6 | <0.01 |
| show warnings | 17.941 | 451,8 | <0.01 |
| update | 2.686 | 67,6 | <0.01 |
| show binlogs | 2.425 | 61,1 | <0.01 |
| replace | 2.050 | 51,6 | <0.01 |
| insert | 947 | 23,8 | <0.01 |
| delete | 682 | 17,2 | <0.01 |
| stmt close | 99 | 2,5 | <0.01 |
| stmt execute | 99 | 2,5 | <0.01 |
| stmt prepare | 99 | 2,5 | <0.01 |
| show storage engines | 62 | 1,6 | <0.01 |
| show table status | 44 | 1,1 | <0.01 |
| insert select | 36 | 0,9 | <0.01 |
| show slave status | 22 | 0,6 | <0.01 |
| show master status | 20 | 0,5 | <0.01 |
| show status | 19 | 0,5 | <0.01 |
| delete multi | 2 | 0,1 | <0.01 |
| show engine status | 2 | 0,1 | <0.01 |
| show processlist | 2 | 0,1 | <0.01 |
| flush | 1 | <0,1 | <0.01 |
| select | 2.119 k | 53,4 k | 77,73 |
| show fields | 128 k | 3.211,6 | 4,68 |
| show tables | 119 k | 2.996,5 | 4,37 |
| change db | 91.719 | 2.309,6 | 3,36 |
| show keys | 91.070 | 2.293,2 | 3,34 |
| set option | 77.995 | 1.964 | 2,86 |
| show variables | 36.130 | 909,8 | 1,33 |
| select | show fields | ||
| show tables | change db | ||
| show keys | set option | ||
| show variables | Khác |