| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 11,802 k | 759.9 k | 96.27 |
| set option | 150 k | 9,640.8 | 1.22 |
| update | 84,431 | 5,436.3 | 0.69 |
| show fields | 70,020 | 4,508.5 | 0.57 |
| change db | 42,312 | 2,724.4 | 0.35 |
| show tables | 37,301 | 2,401.7 | 0.30 |
| insert | 37,207 | 2,395.7 | 0.30 |
| delete | 17,205 | 1,107.8 | 0.14 |
| show processlist | 11,362 | 731.6 | 0.09 |
| insert select | 1,124 | 72.4 | 0.01 |
| update multi | 949 | 61.1 | 0.01 |
| show variables | 929 | 59.8 | 0.01 |
| show status | 750 | 48.3 | 0.01 |
| stmt execute | 632 | 40.7 | 0.01 |
| stmt close | 632 | 40.7 | 0.01 |
| stmt prepare | 632 | 40.7 | 0.01 |
| stmt send long data | 632 | 40.7 | 0.01 |
| create table | 609 | 39.2 | <0.01 |
| show create table | 181 | 11.7 | <0.01 |
| show table status | 175 | 11.3 | <0.01 |
| replace | 154 | 9.9 | <0.01 |
| show keys | 152 | 9.8 | <0.01 |
| delete multi | 129 | 8.3 | <0.01 |
| check | 114 | 7.3 | <0.01 |
| show grants | 80 | 5.2 | <0.01 |
| show binlogs | 54 | 3.5 | <0.01 |
| truncate | 28 | 1.8 | <0.01 |
| show storage engines | 18 | 1.2 | <0.01 |
| show triggers | 15 | 1 | <0.01 |
| lock tables | 14 | 0.9 | <0.01 |
| unlock tables | 14 | 0.9 | <0.01 |
| drop table | 10 | 0.6 | <0.01 |
| show master status | 10 | 0.6 | <0.01 |
| show replica status | 10 | 0.6 | <0.01 |
| show slave status | 10 | 0.6 | <0.01 |
| show databases | 4 | 0.3 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| show engine 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 |
| show function status | 1 | 0.1 | <0.01 |
| show procedure status | 1 | 0.1 | <0.01 |