Statements | # | ø per hour | % |
---|---|---|---|
select | 32,223 k | 296.3 k | 79.88 |
show fields | 2,008 k | 18.5 k | 4.98 |
show tables | 1,681 k | 15.5 k | 4.17 |
change db | 1,342 k | 12.3 k | 3.33 |
set option | 1,007 k | 9,260.9 | 2.50 |
show variables | 663 k | 6,095.8 | 1.64 |
show keys | 384 k | 3,530.7 | 0.95 |
show grants | 335 k | 3,079.5 | 0.83 |
show create table | 333 k | 3,064.2 | 0.83 |
show warnings | 331 k | 3,042.8 | 0.82 |
replace | 28,621 | 263.2 | 0.07 |
show storage engines | 1,210 | 11.1 | <0.01 |
update | 1,188 | 10.9 | <0.01 |
stmt prepare | 261 | 2.4 | <0.01 |
insert | 234 | 2.2 | <0.01 |
show binlogs | 208 | 1.9 | <0.01 |
stmt close | 186 | 1.7 | <0.01 |
stmt execute | 186 | 1.7 | <0.01 |
delete | 129 | 1.2 | <0.01 |
show table status | 106 | 1 | <0.01 |
show slave status | 104 | 1 | <0.01 |
show master status | 101 | 0.9 | <0.01 |
show status | 19 | 0.2 | <0.01 |
delete multi | 8 | 0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |
insert select | 1 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |