Statements | # | ø per hour | % |
---|---|---|---|
select | 103 k | 241.4 | 73.98 |
show tables | 6,742 | 15.8 | 4.84 |
show fields | 5,882 | 13.8 | 4.22 |
change db | 5,707 | 13.4 | 4.10 |
set option | 4,258 | 10 | 3.06 |
show keys | 3,062 | 7.2 | 2.20 |
stmt prepare | 2,240 | 5.2 | 1.61 |
stmt close | 2,180 | 5.1 | 1.57 |
stmt execute | 2,180 | 5.1 | 1.57 |
show grants | 906 | 2.1 | 0.65 |
show variables | 735 | 1.7 | 0.53 |
insert | 689 | 1.6 | 0.49 |
show create table | 518 | 1.2 | 0.37 |
replace | 295 | 0.7 | 0.21 |
show warnings | 223 | 0.5 | 0.16 |
show binlogs | 190 | 0.4 | 0.14 |
show storage engines | 175 | 0.4 | 0.13 |
show slave status | 94 | 0.2 | 0.07 |
show master status | 87 | 0.2 | 0.06 |
show table status | 23 | 0.1 | 0.02 |
show status | 19 | <0.1 | 0.01 |
update | 14 | <0.1 | 0.01 |
delete | 12 | <0.1 | 0.01 |
show engine status | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |