| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 7,109 k | 609.3 k | 88.01 |
| show fields | 206 k | 17.7 k | 2.56 |
| show tables | 198 k | 17 k | 2.45 |
| change db | 147 k | 12.6 k | 1.83 |
| show keys | 137 k | 11.8 k | 1.70 |
| set option | 111 k | 9,486.7 | 1.37 |
| show variables | 52,482 | 4,497.9 | 0.65 |
| show create table | 28,337 | 2,428.6 | 0.35 |
| show grants | 28,218 | 2,418.4 | 0.35 |
| show warnings | 24,650 | 2,112.6 | 0.31 |
| replace | 18,181 | 1,558.2 | 0.23 |
| show create proc | 4,009 | 343.6 | 0.05 |
| show create func | 3,404 | 291.7 | 0.04 |
| update | 3,006 | 257.6 | 0.04 |
| show storage engines | 2,467 | 211.4 | 0.03 |
| insert | 929 | 79.6 | 0.01 |
| show binlogs | 867 | 74.3 | 0.01 |
| stmt close | 386 | 33.1 | <0.01 |
| stmt execute | 386 | 33.1 | <0.01 |
| stmt prepare | 386 | 33.1 | <0.01 |
| show table status | 353 | 30.3 | <0.01 |
| delete | 192 | 16.5 | <0.01 |
| show slave status | 113 | 9.7 | <0.01 |
| show binlog status | 105 | 9 | <0.01 |
| create table | 58 | 5 | <0.01 |
| show status | 30 | 2.6 | <0.01 |
| alter table | 17 | 1.5 | <0.01 |
| insert select | 8 | 0.7 | <0.01 |
| delete multi | 6 | 0.5 | <0.01 |
| show processlist | 3 | 0.3 | <0.01 |
| update multi | 3 | 0.3 | <0.01 |
| create db | 2 | 0.2 | <0.01 |
| flush | 2 | 0.2 | <0.01 |
| show engine status | 2 | 0.2 | <0.01 |