| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,855 k | 337.8 k | 85.44 |
| show tables | 77,281 | 14.1 k | 3.56 |
| show fields | 67,835 | 12.4 k | 3.13 |
| change db | 52,536 | 9,569.9 | 2.42 |
| set option | 40,013 | 7,288.7 | 1.84 |
| show keys | 27,791 | 5,062.4 | 1.28 |
| show variables | 9,036 | 1,646 | 0.42 |
| replace | 8,950 | 1,630.3 | 0.41 |
| show grants | 7,079 | 1,289.5 | 0.33 |
| show create table | 6,331 | 1,153.2 | 0.29 |
| show create proc | 4,009 | 730.3 | 0.18 |
| show create func | 3,404 | 620.1 | 0.16 |
| show warnings | 3,376 | 615 | 0.16 |
| update | 2,986 | 543.9 | 0.14 |
| show storage engines | 2,120 | 386.2 | 0.10 |
| insert | 913 | 166.3 | 0.04 |
| show binlogs | 558 | 101.6 | 0.03 |
| stmt close | 331 | 60.3 | 0.02 |
| stmt execute | 331 | 60.3 | 0.02 |
| stmt prepare | 331 | 60.3 | 0.02 |
| show table status | 269 | 49 | 0.01 |
| delete | 189 | 34.4 | 0.01 |
| show slave status | 87 | 15.8 | <0.01 |
| show binlog status | 81 | 14.8 | <0.01 |
| create table | 58 | 10.6 | <0.01 |
| show status | 18 | 3.3 | <0.01 |
| alter table | 17 | 3.1 | <0.01 |
| insert select | 8 | 1.5 | <0.01 |
| delete multi | 6 | 1.1 | <0.01 |
| update multi | 3 | 0.5 | <0.01 |
| create db | 2 | 0.4 | <0.01 |
| show engine status | 2 | 0.4 | <0.01 |
| show processlist | 2 | 0.4 | <0.01 |
| flush | 1 | 0.2 | <0.01 |