| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 359 k | 17.6 k | 77.39 |
| set option | 20,980 | 1,031 | 4.53 |
| show fields | 20,118 | 988.7 | 4.34 |
| change db | 17,736 | 871.6 | 3.83 |
| show tables | 15,820 | 777.4 | 3.41 |
| show keys | 7,753 | 381 | 1.67 |
| insert | 5,100 | 250.6 | 1.10 |
| show create table | 4,640 | 228 | 1.00 |
| show table status | 2,504 | 123.1 | 0.54 |
| show triggers | 2,384 | 117.2 | 0.51 |
| show variables | 2,053 | 100.9 | 0.44 |
| replace | 1,922 | 94.5 | 0.41 |
| update | 904 | 44.4 | 0.19 |
| show grants | 734 | 36.1 | 0.16 |
| show binlogs | 565 | 27.8 | 0.12 |
| delete | 540 | 26.5 | 0.12 |
| show storage engines | 354 | 17.4 | 0.08 |
| show warnings | 321 | 15.8 | 0.07 |
| commit | 270 | 13.3 | 0.06 |
| show slave status | 40 | 2 | 0.01 |
| show master status | 36 | 1.8 | 0.01 |
| show status | 17 | 0.8 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| rollback | 2 | 0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| show collations | 1 | <0.1 | <0.01 |
| show create db | 1 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |
| stmt close | 1 | <0.1 | <0.01 |
| stmt execute | 1 | <0.1 | <0.01 |
| stmt prepare | 1 | <0.1 | <0.01 |