| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 5,569 k | 1,116.9 k | 88.52 |
| show fields | 153 k | 30.7 k | 2.43 |
| show tables | 141 k | 28.2 k | 2.24 |
| show keys | 113 k | 22.7 k | 1.80 |
| change db | 107 k | 21.5 k | 1.70 |
| set option | 79,390 | 15.9 k | 1.26 |
| show variables | 43,754 | 8,774.2 | 0.70 |
| show grants | 24,651 | 4,943.4 | 0.39 |
| show create table | 22,375 | 4,487 | 0.36 |
| show warnings | 20,979 | 4,207 | 0.33 |
| replace | 10,012 | 2,007.8 | 0.16 |
| show create proc | 1,970 | 395.1 | 0.03 |
| show create func | 1,671 | 335.1 | 0.03 |
| show storage engines | 886 | 177.7 | 0.01 |
| show binlogs | 760 | 152.4 | 0.01 |
| create table | 549 | 110.1 | 0.01 |
| stmt close | 237 | 47.5 | <0.01 |
| stmt execute | 237 | 47.5 | <0.01 |
| stmt prepare | 237 | 47.5 | <0.01 |
| show table status | 108 | 21.7 | <0.01 |
| show slave status | 91 | 18.2 | <0.01 |
| show binlog status | 84 | 16.8 | <0.01 |
| insert | 52 | 10.4 | <0.01 |
| delete | 47 | 9.4 | <0.01 |
| show status | 43 | 8.6 | <0.01 |
| show engine status | 4 | 0.8 | <0.01 |
| show processlist | 4 | 0.8 | <0.01 |
| update | 4 | 0.8 | <0.01 |
| flush | 2 | 0.4 | <0.01 |