Statements | # | ø per hour | % |
---|---|---|---|
select | 34,520 k | 61.4 k | 68.66 |
change db | 10,339 k | 18.4 k | 20.56 |
show fields | 1,172 k | 2,084.5 | 2.33 |
set option | 1,010 k | 1,796.8 | 2.01 |
insert | 833 k | 1,480.7 | 1.66 |
show variables | 568 k | 1,009.6 | 1.13 |
show create table | 314 k | 557.7 | 0.62 |
show keys | 294 k | 522.8 | 0.58 |
show tables | 288 k | 511.4 | 0.57 |
show grants | 285 k | 506.7 | 0.57 |
show warnings | 284 k | 504.5 | 0.56 |
replace | 174 k | 310.1 | 0.35 |
delete | 147 k | 261.5 | 0.29 |
update | 38,665 | 68.8 | 0.08 |
commit | 8,507 | 15.1 | 0.02 |
show table status | 1,210 | 2.2 | <0.01 |
show binlogs | 378 | 0.7 | <0.01 |
show slave status | 74 | 0.1 | <0.01 |
show master status | 67 | 0.1 | <0.01 |
rollback | 34 | 0.1 | <0.01 |
show storage engines | 30 | 0.1 | <0.01 |
unlock tables | 25 | <0.1 | <0.01 |
alter table | 25 | <0.1 | <0.01 |
lock tables | 25 | <0.1 | <0.01 |
create table | 19 | <0.1 | <0.01 |
show create proc | 16 | <0.1 | <0.01 |
show status | 11 | <0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show charsets | 1 | <0.1 | <0.01 |
show function status | 1 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |
begin | 1 | <0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |
show collations | 1 | <0.1 | <0.01 |
show procedure status | 1 | <0.1 | <0.01 |