| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 75,398 | 16.3 k | 41.49 |
| insert | 31,680 | 6,841.9 | 17.43 |
| set option | 14,793 | 3,194.8 | 8.14 |
| show tables | 14,314 | 3,091.4 | 7.88 |
| show fields | 10,191 | 2,200.9 | 5.61 |
| show keys | 9,445 | 2,039.8 | 5.20 |
| update | 8,964 | 1,936 | 4.93 |
| change db | 7,305 | 1,577.7 | 4.02 |
| show variables | 3,085 | 666.3 | 1.70 |
| show create table | 2,470 | 533.4 | 1.36 |
| show grants | 1,522 | 328.7 | 0.84 |
| show storage engines | 773 | 166.9 | 0.43 |
| show warnings | 483 | 104.3 | 0.27 |
| delete | 230 | 49.7 | 0.13 |
| show slave status | 125 | 27 | 0.07 |
| show master status | 120 | 25.9 | 0.07 |
| show binlogs | 110 | 23.8 | 0.06 |
| show table status | 108 | 23.3 | 0.06 |
| begin | 92 | 19.9 | 0.05 |
| commit | 92 | 19.9 | 0.05 |
| stmt close | 88 | 19 | 0.05 |
| stmt execute | 88 | 19 | 0.05 |
| stmt prepare | 88 | 19 | 0.05 |
| create table | 59 | 12.7 | 0.03 |
| show create proc | 35 | 7.6 | 0.02 |
| show status | 26 | 5.6 | 0.01 |
| alter table | 13 | 2.8 | 0.01 |
| show processlist | 3 | 0.6 | <0.01 |
| show engine status | 2 | 0.4 | <0.01 |
| create db | 1 | 0.2 | <0.01 |
| flush | 1 | 0.2 | <0.01 |