Statements | # | ø per hour | % |
---|---|---|---|
select | 394 k | 1,418.1 | 79.06 |
show tables | 26,904 | 96.9 | 5.40 |
show fields | 22,182 | 79.9 | 4.45 |
change db | 18,765 | 67.6 | 3.77 |
set option | 14,582 | 52.5 | 2.93 |
show keys | 8,220 | 29.6 | 1.65 |
show grants | 3,310 | 11.9 | 0.66 |
replace | 2,297 | 8.3 | 0.46 |
show create table | 2,107 | 7.6 | 0.42 |
show variables | 1,936 | 7 | 0.39 |
show storage engines | 588 | 2.1 | 0.12 |
show warnings | 551 | 2 | 0.11 |
stmt close | 491 | 1.8 | 0.10 |
stmt execute | 491 | 1.8 | 0.10 |
stmt prepare | 491 | 1.8 | 0.10 |
show binlogs | 484 | 1.7 | 0.10 |
show slave status | 221 | 0.8 | 0.04 |
update | 213 | 0.8 | 0.04 |
show master status | 211 | 0.8 | 0.04 |
show table status | 163 | 0.6 | 0.03 |
show status | 39 | 0.1 | 0.01 |
insert | 22 | 0.1 | <0.01 |
delete | 6 | <0.1 | <0.01 |
show processlist | 5 | <0.1 | <0.01 |
show engine status | 3 | <0.1 | <0.01 |
begin | 2 | <0.1 | <0.01 |
commit | 2 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |