Statements | # | ø per hour | % |
---|---|---|---|
select | 23,776 k | 79.4 k | 81.57 |
show fields | 1,333 k | 4,452.7 | 4.57 |
show tables | 1,126 k | 3,760.7 | 3.86 |
change db | 894 k | 2,984.8 | 3.07 |
set option | 670 k | 2,237 | 2.30 |
show variables | 434 k | 1,450.4 | 1.49 |
show keys | 250 k | 834.4 | 0.86 |
show create table | 219 k | 731.9 | 0.75 |
show warnings | 216 k | 721.9 | 0.74 |
show grants | 213 k | 710.1 | 0.73 |
replace | 15,664 | 52.3 | 0.05 |
show storage engines | 1,527 | 5.1 | 0.01 |
stmt prepare | 453 | 1.5 | <0.01 |
show binlogs | 310 | 1 | <0.01 |
stmt close | 303 | 1 | <0.01 |
stmt execute | 303 | 1 | <0.01 |
show slave status | 179 | 0.6 | <0.01 |
show master status | 170 | 0.6 | <0.01 |
show table status | 158 | 0.5 | <0.01 |
show status | 71 | 0.2 | <0.01 |
show processlist | 9 | <0.1 | <0.01 |
show engine status | 7 | <0.1 | <0.01 |
flush | 3 | <0.1 | <0.01 |