Statements | # | ø per hour | % |
---|---|---|---|
select | 56,205 | 654.1 | 39.32 |
show create table | 41,246 | 480 | 28.85 |
show fields | 11,323 | 131.8 | 7.92 |
change db | 11,060 | 128.7 | 7.74 |
show keys | 10,181 | 118.5 | 7.12 |
set option | 3,469 | 40.4 | 2.43 |
insert | 2,464 | 28.7 | 1.72 |
alter table | 2,068 | 24.1 | 1.45 |
create table | 1,004 | 11.7 | 0.70 |
unlock tables | 996 | 11.6 | 0.70 |
drop table | 996 | 11.6 | 0.70 |
lock tables | 996 | 11.6 | 0.70 |
show tables | 225 | 2.6 | 0.16 |
delete | 212 | 2.5 | 0.15 |
update | 118 | 1.4 | 0.08 |
show grants | 104 | 1.2 | 0.07 |
show binlogs | 67 | 0.8 | 0.05 |
show slave status | 42 | 0.5 | 0.03 |
show master status | 39 | 0.5 | 0.03 |
show triggers | 37 | 0.4 | 0.03 |
show variables | 37 | 0.4 | 0.03 |
show table status | 13 | 0.2 | 0.01 |
commit | 12 | 0.1 | 0.01 |
show storage engines | 11 | 0.1 | 0.01 |
show status | 9 | 0.1 | 0.01 |
show databases | 7 | 0.1 | <0.01 |
show collations | 1 | <0.1 | <0.01 |
show charsets | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |