Statements | # | ø per hour | % |
---|---|---|---|
select | 95,235 | 1,077.6 | 43.81 |
show create table | 47,461 | 537 | 21.83 |
show fields | 25,081 | 283.8 | 11.54 |
show keys | 24,081 | 272.5 | 11.08 |
change db | 11,404 | 129 | 5.25 |
set option | 3,961 | 44.8 | 1.82 |
insert | 2,464 | 27.9 | 1.13 |
alter table | 2,068 | 23.4 | 0.95 |
create table | 1,004 | 11.4 | 0.46 |
unlock tables | 996 | 11.3 | 0.46 |
drop table | 996 | 11.3 | 0.46 |
lock tables | 996 | 11.3 | 0.46 |
show tables | 658 | 7.4 | 0.30 |
show grants | 268 | 3 | 0.12 |
delete | 212 | 2.4 | 0.10 |
update | 119 | 1.3 | 0.05 |
show binlogs | 102 | 1.2 | 0.05 |
show variables | 83 | 0.9 | 0.04 |
show slave status | 49 | 0.6 | 0.02 |
show master status | 46 | 0.5 | 0.02 |
show triggers | 37 | 0.4 | 0.02 |
show table status | 23 | 0.3 | 0.01 |
show storage engines | 20 | 0.2 | 0.01 |
show status | 16 | 0.2 | 0.01 |
commit | 12 | 0.1 | 0.01 |
show databases | 7 | 0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |
show collations | 1 | <0.1 | <0.01 |
show charsets | 1 | <0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |