| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 658 M | 11.1 M | 91.83 |
| set option | 8,677 k | 146.5 k | 1.21 |
| replace | 8,427 k | 142.3 k | 1.18 |
| stmt execute | 7,898 k | 133.3 k | 1.10 |
| stmt prepare | 7,860 k | 132.7 k | 1.10 |
| stmt close | 7,860 k | 132.7 k | 1.10 |
| update | 6,784 k | 114.5 k | 0.95 |
| change db | 2,509 k | 42.4 k | 0.35 |
| show fields | 2,463 k | 41.6 k | 0.34 |
| insert | 2,151 k | 36.3 k | 0.30 |
| show tables | 909 k | 15.3 k | 0.13 |
| delete | 787 k | 13.3 k | 0.11 |
| show status | 365 k | 6,163.4 | 0.05 |
| show variables | 351 k | 5,932.3 | 0.05 |
| show keys | 342 k | 5,771.5 | 0.05 |
| show engine status | 213 k | 3,600 | 0.03 |
| show generic | 213 k | 3,599.8 | 0.03 |
| insert select | 211 k | 3,562.2 | 0.03 |
| show databases | 113 k | 1,915.9 | 0.02 |
| show create table | 77,939 | 1,315.8 | 0.01 |
| show warnings | 65,475 | 1,105.4 | 0.01 |
| show processlist | 57,578 | 972.1 | 0.01 |
| update multi | 49,560 | 836.7 | 0.01 |
| call procedure | 36,298 | 612.8 | 0.01 |
| drop table | 27,198 | 459.2 | <0.01 |
| create temporary table | 26,591 | 448.9 | <0.01 |
| delete multi | 25,622 | 432.6 | <0.01 |
| alter table | 20,529 | 346.6 | <0.01 |
| create table | 19,752 | 333.5 | <0.01 |
| rollback to savepoint | 14,574 | 246 | <0.01 |
| begin | 14,294 | 241.3 | <0.01 |
| show profile | 9,531 | 160.9 | <0.01 |
| commit | 7,391 | 124.8 | <0.01 |
| rollback | 6,576 | 111 | <0.01 |
| show grants | 4,168 | 70.4 | <0.01 |
| enable governor lve | 3,553 | 60 | <0.01 |
| show table status | 1,211 | 20.4 | <0.01 |
| stmt send long data | 1,112 | 18.8 | <0.01 |
| show storage engines | 905 | 15.3 | <0.01 |
| unlock tables | 839 | 14.2 | <0.01 |
| show profiles | 642 | 10.8 | <0.01 |
| check | 519 | 8.8 | <0.01 |
| lock tables | 509 | 8.6 | <0.01 |
| grant | 467 | 7.9 | <0.01 |
| release savepoint | 330 | 5.6 | <0.01 |
| savepoint | 330 | 5.6 | <0.01 |
| truncate | 219 | 3.7 | <0.01 |
| show binlogs | 212 | 3.6 | <0.01 |
| show function status | 195 | 3.3 | <0.01 |
| show procedure status | 195 | 3.3 | <0.01 |
| show events | 179 | 3 | <0.01 |
| show create db | 165 | 2.8 | <0.01 |
| show package status | 165 | 2.8 | <0.01 |
| show package body status | 165 | 2.8 | <0.01 |
| show slave status | 109 | 1.8 | <0.01 |
| show binlog status | 108 | 1.8 | <0.01 |
| empty query | 75 | 1.3 | <0.01 |
| alter user | 59 | 1 | <0.01 |
| create user | 48 | 0.8 | <0.01 |
| show create trigger | 39 | 0.7 | <0.01 |
| create view | 35 | 0.6 | <0.01 |
| drop user | 30 | 0.5 | <0.01 |
| show triggers | 24 | 0.4 | <0.01 |
| do | 21 | 0.4 | <0.01 |
| flush | 15 | 0.3 | <0.01 |
| drop db | 13 | 0.2 | <0.01 |
| create db | 11 | 0.2 | <0.01 |
| show charsets | 10 | 0.2 | <0.01 |
| revoke | 6 | 0.1 | <0.01 |
| show create proc | 5 | 0.1 | <0.01 |
| rename table | 4 | 0.1 | <0.01 |
| enable governor reconn lve | 3 | 0.1 | <0.01 |
| create procedure | 2 | <0.1 | <0.01 |
| create trigger | 2 | <0.1 | <0.01 |
| drop procedure | 2 | <0.1 | <0.01 |
| drop trigger | 2 | <0.1 | <0.01 |