Statements | # | ø per hour | % |
---|---|---|---|
select | 7,596 k | 33.1 k | 80.85 |
show tables | 353 k | 1,539.8 | 3.76 |
set option | 285 k | 1,244 | 3.04 |
show fields | 274 k | 1,195.2 | 2.92 |
insert | 186 k | 810 | 1.98 |
show keys | 152 k | 664.3 | 1.62 |
stmt execute | 150 k | 651.8 | 1.59 |
change db | 111 k | 484.2 | 1.18 |
show variables | 84,512 | 368.3 | 0.90 |
show create table | 59,912 | 261.1 | 0.64 |
delete multi | 39,829 | 173.6 | 0.42 |
show warnings | 35,241 | 153.6 | 0.38 |
update | 25,847 | 112.6 | 0.28 |
show grants | 25,442 | 110.9 | 0.27 |
show storage engines | 6,476 | 28.2 | 0.07 |
stmt close | 4,150 | 18.1 | 0.04 |
stmt prepare | 4,150 | 18.1 | 0.04 |
show binlogs | 625 | 2.7 | 0.01 |
show table status | 491 | 2.1 | 0.01 |
show slave status | 374 | 1.6 | <0.01 |
show master status | 365 | 1.6 | <0.01 |
show status | 54 | 0.2 | <0.01 |
delete | 16 | 0.1 | <0.01 |
show processlist | 9 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |