Statements | # | ø per hour | % |
---|---|---|---|
select | 1,220 k | 139.4 k | 81.22 |
insert | 96,438 | 11 k | 6.42 |
stmt execute | 90,025 | 10.3 k | 5.99 |
show fields | 22,682 | 2,592.8 | 1.51 |
set option | 18,281 | 2,089.7 | 1.22 |
show tables | 16,388 | 1,873.3 | 1.09 |
show keys | 8,414 | 961.8 | 0.56 |
change db | 7,949 | 908.7 | 0.53 |
delete multi | 6,880 | 786.5 | 0.46 |
update | 4,377 | 500.3 | 0.29 |
show grants | 3,401 | 388.8 | 0.23 |
show create table | 2,497 | 285.4 | 0.17 |
show variables | 1,986 | 227 | 0.13 |
show storage engines | 742 | 84.8 | 0.05 |
stmt close | 712 | 81.4 | 0.05 |
stmt prepare | 712 | 81.4 | 0.05 |
show warnings | 296 | 33.8 | 0.02 |
show binlogs | 89 | 10.2 | 0.01 |
show slave status | 49 | 5.6 | <0.01 |
show table status | 49 | 5.6 | <0.01 |
show master status | 46 | 5.3 | <0.01 |
show status | 12 | 1.4 | <0.01 |
show engine status | 1 | 0.1 | <0.01 |
show processlist | 1 | 0.1 | <0.01 |