Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 138 M | 14.1 M | 87.74 |
| stmt prepare | 4,504 k | 459.1 k | 2.86 |
| stmt execute | 4,504 k | 459.1 k | 2.86 |
| stmt close | 4,504 k | 459 k | 2.86 |
| set option | 2,179 k | 222.1 k | 1.38 |
| update | 1,104 k | 112.6 k | 0.70 |
| change db | 765 k | 78 k | 0.49 |
| insert | 609 k | 62.1 k | 0.39 |
| show fields | 498 k | 50.7 k | 0.32 |
| delete | 140 k | 14.3 k | 0.09 |
| replace | 136 k | 13.9 k | 0.09 |
| show status | 105 k | 10.7 k | 0.07 |
| show tables | 94,016 | 9,582.6 | 0.06 |
| show variables | 36,937 | 3,764.8 | 0.02 |
| show engine status | 35,297 | 3,597.7 | 0.02 |
| show generic | 35,295 | 3,597.5 | 0.02 |
| insert select | 30,043 | 3,062.1 | 0.02 |
| update multi | 11,547 | 1,176.9 | 0.01 |
| show processlist | 9,541 | 972.5 | 0.01 |
| show keys | 4,770 | 486.2 | <0.01 |
| show create table | 2,476 | 252.4 | <0.01 |
| create table | 2,475 | 252.3 | <0.01 |
| delete multi | 1,571 | 160.1 | <0.01 |
| begin | 1,474 | 150.2 | <0.01 |
| commit | 1,474 | 150.2 | <0.01 |
| show profile | 1,438 | 146.6 | <0.01 |
| alter table | 1,337 | 136.3 | <0.01 |
| savepoint | 914 | 93.2 | <0.01 |
| show databases | 877 | 89.4 | <0.01 |
| truncate | 648 | 66 | <0.01 |
| enable governor lve | 588 | 59.9 | <0.01 |
| show warnings | 331 | 33.7 | <0.01 |
| show grants | 279 | 28.4 | <0.01 |
| show table status | 219 | 22.3 | <0.01 |
| show storage engines | 193 | 19.7 | <0.01 |
| stmt send long data | 120 | 12.2 | <0.01 |
| show binlogs | 102 | 10.4 | <0.01 |
| show profiles | 88 | 9 | <0.01 |
| show slave status | 39 | 4 | <0.01 |
| show binlog status | 38 | 3.9 | <0.01 |
| show create trigger | 32 | 3.3 | <0.01 |
| lock tables | 10 | 1 | <0.01 |
| unlock tables | 10 | 1 | <0.01 |
| show function status | 8 | 0.8 | <0.01 |
| show procedure status | 8 | 0.8 | <0.01 |
| show triggers | 4 | 0.4 | <0.01 |
| drop table | 3 | 0.3 | <0.01 |
| show events | 2 | 0.2 | <0.01 |
| drop user | 1 | 0.1 | <0.01 |