Statements | # | ø per hour | % |
---|---|---|---|
select | 25,534 k | 78.8 k | 81.41 |
show fields | 1,446 k | 4,465.5 | 4.61 |
show tables | 1,221 k | 3,769.5 | 3.89 |
change db | 969 k | 2,993 | 3.09 |
set option | 727 k | 2,243.2 | 2.32 |
show variables | 472 k | 1,456 | 1.50 |
show keys | 270 k | 833.5 | 0.86 |
show create table | 238 k | 734.4 | 0.76 |
show warnings | 235 k | 724.8 | 0.75 |
show grants | 232 k | 714.9 | 0.74 |
replace | 16,457 | 50.8 | 0.05 |
show storage engines | 1,604 | 5 | 0.01 |
stmt prepare | 488 | 1.5 | <0.01 |
show binlogs | 332 | 1 | <0.01 |
stmt close | 328 | 1 | <0.01 |
stmt execute | 328 | 1 | <0.01 |
show slave status | 183 | 0.6 | <0.01 |
show master status | 174 | 0.5 | <0.01 |
show table status | 164 | 0.5 | <0.01 |
show status | 76 | 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 |