| Statements | # | ø per hour | % |
|---|---|---|---|
| stmt execute | 1,273 k | 865.7 | 28.65 |
| update | 1,218 k | 828.1 | 27.41 |
| select | 1,175 k | 799 | 26.44 |
| show keys | 150 k | 101.8 | 3.37 |
| set option | 136 k | 92.3 | 3.06 |
| show tables | 125 k | 85.2 | 2.82 |
| show fields | 110 k | 75.1 | 2.48 |
| change db | 62,376 | 42.4 | 1.40 |
| stmt prepare | 52,080 | 35.4 | 1.17 |
| show variables | 43,168 | 29.4 | 0.97 |
| show create table | 27,693 | 18.8 | 0.62 |
| show warnings | 18,296 | 12.4 | 0.41 |
| show grants | 15,092 | 10.3 | 0.34 |
| show create proc | 11,663 | 7.9 | 0.26 |
| show create func | 8,853 | 6 | 0.20 |
| create table | 6,215 | 4.2 | 0.14 |
| show storage engines | 4,697 | 3.2 | 0.11 |
| stmt close | 1,743 | 1.2 | 0.04 |
| show binlogs | 949 | 0.6 | 0.02 |
| insert | 895 | 0.6 | 0.02 |
| show slave status | 569 | 0.4 | 0.01 |
| show binlog status | 550 | 0.4 | 0.01 |
| show collations | 528 | 0.4 | 0.01 |
| show table status | 436 | 0.3 | 0.01 |
| show status | 197 | 0.1 | <0.01 |
| show function status | 55 | <0.1 | <0.01 |
| show procedure status | 55 | <0.1 | <0.01 |
| show triggers | 55 | <0.1 | <0.01 |
| show databases | 54 | <0.1 | <0.01 |
| alter table | 34 | <0.1 | <0.01 |
| show create user | 28 | <0.1 | <0.01 |
| show processlist | 17 | <0.1 | <0.01 |
| flush | 15 | <0.1 | <0.01 |
| show open tables | 15 | <0.1 | <0.01 |
| show engine status | 11 | <0.1 | <0.01 |
| alter user | 7 | <0.1 | <0.01 |
| delete | 7 | <0.1 | <0.01 |
| drop table | 4 | <0.1 | <0.01 |
| empty query | 4 | <0.1 | <0.01 |
| lock tables | 4 | <0.1 | <0.01 |
| unlock tables | 4 | <0.1 | <0.01 |
| create user | 3 | <0.1 | <0.01 |
| grant | 3 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| create index | 1 | <0.1 | <0.01 |
| drop user | 1 | <0.1 | <0.01 |
| revoke | 1 | <0.1 | <0.01 |
| stmt reprepare | 1 | <0.1 | <0.01 |