Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 12,345 k | 976 k | 96.50 |
| show tables | 89,252 | 7,056.7 | 0.70 |
| show fields | 86,803 | 6,863.1 | 0.68 |
| change db | 64,189 | 5,075.1 | 0.50 |
| set option | 53,140 | 4,201.5 | 0.42 |
| stmt execute | 27,052 | 2,138.9 | 0.21 |
| stmt prepare | 27,047 | 2,138.5 | 0.21 |
| stmt close | 27,042 | 2,138.1 | 0.21 |
| show keys | 22,257 | 1,759.8 | 0.17 |
| replace | 12,160 | 961.4 | 0.10 |
| show variables | 10,456 | 826.7 | 0.08 |
| show create table | 9,018 | 713 | 0.07 |
| create table | 8,325 | 658.2 | 0.07 |
| show warnings | 3,514 | 277.8 | 0.03 |
| show storage engines | 3,421 | 270.5 | 0.03 |
| update | 698 | 55.2 | 0.01 |
| insert | 630 | 49.8 | <0.01 |
| delete | 555 | 43.9 | <0.01 |
| show table status | 424 | 33.5 | <0.01 |
| show grants | 357 | 28.2 | <0.01 |
| show slave status | 331 | 26.2 | <0.01 |
| show master status | 324 | 25.6 | <0.01 |
| show status | 149 | 11.8 | <0.01 |
| show binlogs | 138 | 10.9 | <0.01 |
| begin | 124 | 9.8 | <0.01 |
| commit | 124 | 9.8 | <0.01 |
| show collations | 92 | 7.3 | <0.01 |
| lock tables | 19 | 1.5 | <0.01 |
| unlock tables | 19 | 1.5 | <0.01 |
| alter table | 18 | 1.4 | <0.01 |
| revoke | 10 | 0.8 | <0.01 |
| grant | 9 | 0.7 | <0.01 |
| show charsets | 8 | 0.6 | <0.01 |
| show function status | 8 | 0.6 | <0.01 |
| show procedure status | 8 | 0.6 | <0.01 |
| show create db | 7 | 0.6 | <0.01 |
| show events | 6 | 0.5 | <0.01 |
| show package status | 6 | 0.5 | <0.01 |
| show package body status | 6 | 0.5 | <0.01 |
| flush | 4 | 0.3 | <0.01 |
| show processlist | 4 | 0.3 | <0.01 |
| show databases | 3 | 0.2 | <0.01 |
| show engine status | 3 | 0.2 | <0.01 |
| create user | 2 | 0.2 | <0.01 |
| alter user | 1 | 0.1 | <0.01 |
| delete multi | 1 | 0.1 | <0.01 |
| drop user | 1 | 0.1 | <0.01 |
| empty query | 1 | 0.1 | <0.01 |
| show plugins | 1 | 0.1 | <0.01 |