Statements | # | ø per hour | % |
---|---|---|---|
select | 54,258 k | 157.1 k | 79.05 |
show tables | 3,249 k | 9,405.6 | 4.73 |
show fields | 3,095 k | 8,958.6 | 4.51 |
change db | 2,334 k | 6,757.1 | 3.40 |
set option | 1,966 k | 5,690.6 | 2.86 |
show keys | 999 k | 2,893 | 1.46 |
replace | 483 k | 1,398.4 | 0.70 |
show variables | 459 k | 1,329.9 | 0.67 |
show create table | 337 k | 974.4 | 0.49 |
show grants | 328 k | 949.1 | 0.48 |
stmt prepare | 205 k | 592.6 | 0.30 |
stmt execute | 205 k | 592.4 | 0.30 |
stmt close | 199 k | 575.5 | 0.29 |
show warnings | 185 k | 536.6 | 0.27 |
update | 112 k | 324.3 | 0.16 |
insert | 88,988 | 257.6 | 0.13 |
show storage engines | 75,311 | 218 | 0.11 |
show binlogs | 27,630 | 80 | 0.04 |
show table status | 13,164 | 38.1 | 0.02 |
show slave status | 6,492 | 18.8 | 0.01 |
show master status | 6,452 | 18.7 | 0.01 |
delete | 4,860 | 14.1 | 0.01 |
show status | 272 | 0.8 | <0.01 |
create view | 70 | 0.2 | <0.01 |
show profile | 34 | 0.1 | <0.01 |
show processlist | 33 | 0.1 | <0.01 |
show engine status | 31 | 0.1 | <0.01 |
alter table | 18 | 0.1 | <0.01 |
flush | 14 | <0.1 | <0.01 |
show function status | 10 | <0.1 | <0.01 |
show procedure status | 10 | <0.1 | <0.01 |
kill | 6 | <0.1 | <0.01 |
delete multi | 4 | <0.1 | <0.01 |
create table | 2 | <0.1 | <0.01 |