| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 13,586 k | 751.4 k | 96.34 |
| set option | 166 k | 9,185.9 | 1.18 |
| update | 103 k | 5,698.1 | 0.73 |
| show fields | 77,476 | 4,284.8 | 0.55 |
| change db | 46,510 | 2,572.3 | 0.33 |
| show tables | 41,183 | 2,277.6 | 0.29 |
| insert | 40,616 | 2,246.3 | 0.29 |
| delete | 18,398 | 1,017.5 | 0.13 |
| show processlist | 13,230 | 731.7 | 0.09 |
| insert select | 1,156 | 63.9 | 0.01 |
| update multi | 1,104 | 61.1 | 0.01 |
| show variables | 1,005 | 55.6 | 0.01 |
| show status | 883 | 48.8 | 0.01 |
| create table | 671 | 37.1 | <0.01 |
| stmt execute | 651 | 36 | <0.01 |
| stmt close | 651 | 36 | <0.01 |
| stmt prepare | 651 | 36 | <0.01 |
| stmt send long data | 651 | 36 | <0.01 |
| show table status | 334 | 18.5 | <0.01 |
| show create table | 324 | 17.9 | <0.01 |
| show keys | 299 | 16.5 | <0.01 |
| replace | 154 | 8.5 | <0.01 |
| delete multi | 137 | 7.6 | <0.01 |
| check | 114 | 6.3 | <0.01 |
| show grants | 96 | 5.3 | <0.01 |
| show binlogs | 65 | 3.6 | <0.01 |
| show triggers | 30 | 1.7 | <0.01 |
| truncate | 29 | 1.6 | <0.01 |
| lock tables | 28 | 1.5 | <0.01 |
| unlock tables | 28 | 1.5 | <0.01 |
| show storage engines | 26 | 1.4 | <0.01 |
| show master status | 21 | 1.2 | <0.01 |
| show replica status | 21 | 1.2 | <0.01 |
| show slave status | 21 | 1.2 | <0.01 |
| drop table | 10 | 0.6 | <0.01 |
| show databases | 4 | 0.2 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| show engine status | 2 | 0.1 | <0.01 |
| show function status | 2 | 0.1 | <0.01 |
| show procedure status | 2 | 0.1 | <0.01 |
| alter table | 1 | 0.1 | <0.01 |
| create db | 1 | 0.1 | <0.01 |
| drop db | 1 | 0.1 | <0.01 |
| optimize | 1 | 0.1 | <0.01 |