Statements | # | ø per hour | % |
---|---|---|---|
select | 501 M | 673.3 k | 95.16 |
set option | 7,020 k | 9,440.6 | 1.33 |
update | 6,341 k | 8,527 | 1.21 |
show fields | 3,671 k | 4,936.3 | 0.70 |
insert | 2,753 k | 3,702.7 | 0.52 |
show tables | 2,714 k | 3,649.2 | 0.52 |
change db | 2,091 k | 2,812.1 | 0.40 |
delete | 418 k | 562.2 | 0.08 |
show keys | 326 k | 437.7 | 0.06 |
show function status | 70,806 | 95.2 | 0.01 |
show variables | 19,161 | 25.8 | <0.01 |
show grants | 9,389 | 12.6 | <0.01 |
show create table | 8,174 | 11 | <0.01 |
insert select | 8,055 | 10.8 | <0.01 |
begin | 5,203 | 7 | <0.01 |
commit | 5,200 | 7 | <0.01 |
delete multi | 4,623 | 6.2 | <0.01 |
show storage engines | 2,529 | 3.4 | <0.01 |
show warnings | 1,542 | 2.1 | <0.01 |
rollback to savepoint | 1,498 | 2 | <0.01 |
alter table | 468 | 0.6 | <0.01 |
show table status | 463 | 0.6 | <0.01 |
show binlogs | 304 | 0.4 | <0.01 |
truncate | 281 | 0.4 | <0.01 |
create table | 255 | 0.3 | <0.01 |
drop table | 231 | 0.3 | <0.01 |
unlock tables | 162 | 0.2 | <0.01 |
lock tables | 159 | 0.2 | <0.01 |
show collations | 123 | 0.2 | <0.01 |
show binlog status | 100 | 0.1 | <0.01 |
show slave status | 100 | 0.1 | <0.01 |
show databases | 81 | 0.1 | <0.01 |
show status | 40 | 0.1 | <0.01 |
drop user | 26 | <0.1 | <0.01 |
revoke | 22 | <0.1 | <0.01 |
grant | 22 | <0.1 | <0.01 |
create user | 13 | <0.1 | <0.01 |
create db | 11 | <0.1 | <0.01 |
drop db | 11 | <0.1 | <0.01 |
show charsets | 10 | <0.1 | <0.01 |
create index | 9 | <0.1 | <0.01 |
show processlist | 5 | <0.1 | <0.01 |
show create func | 5 | <0.1 | <0.01 |
update multi | 5 | <0.1 | <0.01 |
flush | 4 | <0.1 | <0.01 |
show engine status | 4 | <0.1 | <0.01 |
show procedure status | 3 | <0.1 | <0.01 |
show package body status | 3 | <0.1 | <0.01 |
show package status | 3 | <0.1 | <0.01 |
savepoint | 3 | <0.1 | <0.01 |
release savepoint | 3 | <0.1 | <0.01 |
show events | 3 | <0.1 | <0.01 |
kill | 2 | <0.1 | <0.01 |
load | 2 | <0.1 | <0.01 |
drop index | 1 | <0.1 | <0.01 |