| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 656 M | 14.6 M | 92.94 |
| set option | 10,821 k | 240.1 k | 1.53 |
| stmt prepare | 7,145 k | 158.5 k | 1.01 |
| stmt execute | 7,144 k | 158.5 k | 1.01 |
| stmt close | 7,138 k | 158.4 k | 1.01 |
| update | 6,182 k | 137.2 k | 0.88 |
| change db | 3,438 k | 76.3 k | 0.49 |
| show fields | 2,528 k | 56.1 k | 0.36 |
| insert | 2,125 k | 47.2 k | 0.30 |
| show tables | 797 k | 17.7 k | 0.11 |
| delete | 733 k | 16.3 k | 0.10 |
| show status | 368 k | 8,154.9 | 0.05 |
| replace | 279 k | 6,180.9 | 0.04 |
| show variables | 169 k | 3,752.1 | 0.02 |
| show engine status | 162 k | 3,599.1 | 0.02 |
| show generic | 162 k | 3,599 | 0.02 |
| insert select | 148 k | 3,292.9 | 0.02 |
| show create table | 112 k | 2,479.5 | 0.02 |
| repair | 70,281 | 1,559.3 | 0.01 |
| rollback to savepoint | 57,882 | 1,284.2 | 0.01 |
| update multi | 56,565 | 1,255 | 0.01 |
| show databases | 54,148 | 1,201.4 | 0.01 |
| show processlist | 43,818 | 972.2 | 0.01 |
| alter table | 25,498 | 565.7 | <0.01 |
| create table | 17,271 | 383.2 | <0.01 |
| show keys | 15,234 | 338 | <0.01 |
| begin | 10,116 | 224.4 | <0.01 |
| show grants | 8,644 | 191.8 | <0.01 |
| delete multi | 8,381 | 185.9 | <0.01 |
| commit | 8,302 | 184.2 | <0.01 |
| show profile | 7,837 | 173.9 | <0.01 |
| savepoint | 7,489 | 166.2 | <0.01 |
| unlock tables | 5,491 | 121.8 | <0.01 |
| lock tables | 3,633 | 80.6 | <0.01 |
| truncate | 2,913 | 64.6 | <0.01 |
| enable governor lve | 2,697 | 59.8 | <0.01 |
| show table status | 2,488 | 55.2 | <0.01 |
| drop table | 2,338 | 51.9 | <0.01 |
| empty query | 2,006 | 44.5 | <0.01 |
| release savepoint | 1,806 | 40.1 | <0.01 |
| alter user | 1,265 | 28.1 | <0.01 |
| grant | 1,230 | 27.3 | <0.01 |
| show function status | 947 | 21 | <0.01 |
| show procedure status | 947 | 21 | <0.01 |
| show events | 927 | 20.6 | <0.01 |
| show package status | 905 | 20.1 | <0.01 |
| show package body status | 905 | 20.1 | <0.01 |
| show create db | 901 | 20 | <0.01 |
| show binlogs | 666 | 14.8 | <0.01 |
| stmt send long data | 602 | 13.4 | <0.01 |
| show profiles | 488 | 10.8 | <0.01 |
| show storage engines | 459 | 10.2 | <0.01 |
| show create trigger | 440 | 9.8 | <0.01 |
| check | 358 | 7.9 | <0.01 |
| show warnings | 277 | 6.1 | <0.01 |
| drop user | 265 | 5.9 | <0.01 |
| create user | 264 | 5.9 | <0.01 |
| flush | 236 | 5.2 | <0.01 |
| show slave status | 198 | 4.4 | <0.01 |
| show binlog status | 196 | 4.3 | <0.01 |
| create view | 116 | 2.6 | <0.01 |
| drop db | 98 | 2.2 | <0.01 |
| create db | 86 | 1.9 | <0.01 |
| show charsets | 86 | 1.9 | <0.01 |
| drop view | 76 | 1.7 | <0.01 |
| show triggers | 39 | 0.9 | <0.01 |
| show create proc | 38 | 0.8 | <0.01 |
| do | 36 | 0.8 | <0.01 |
| enable governor reconn lve | 17 | 0.4 | <0.01 |
| show create func | 15 | 0.3 | <0.01 |
| rollback | 7 | 0.2 | <0.01 |
| create temporary table | 4 | 0.1 | <0.01 |
| rename table | 4 | 0.1 | <0.01 |
| call procedure | 2 | <0.1 | <0.01 |