Statements | # | ø per hour | % |
---|---|---|---|
select | 18,536 k | 86.1 k | 73.81 |
show fields | 1,497 k | 6,950.5 | 5.96 |
set option | 1,148 k | 5,332.2 | 4.57 |
change db | 755 k | 3,506 | 3.01 |
show variables | 748 k | 3,474.5 | 2.98 |
show tables | 383 k | 1,778.5 | 1.53 |
show grants | 374 k | 1,737.9 | 1.49 |
show keys | 374 k | 1,737.7 | 1.49 |
show create table | 374 k | 1,737.3 | 1.49 |
show warnings | 374 k | 1,737.1 | 1.49 |
stmt prepare | 182 k | 847.3 | 0.73 |
stmt execute | 182 k | 847.3 | 0.73 |
stmt close | 182 k | 847.3 | 0.73 |
update | 632 | 2.9 | <0.01 |
insert | 586 | 2.7 | <0.01 |
replace | 127 | 0.6 | <0.01 |
show binlogs | 94 | 0.4 | <0.01 |
delete | 36 | 0.2 | <0.01 |
show slave status | 33 | 0.2 | <0.01 |
show master status | 31 | 0.1 | <0.01 |
show storage engines | 23 | 0.1 | <0.01 |
show status | 9 | <0.1 | <0.01 |
show table status | 3 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |