Statements | # | ø per hour | % |
---|---|---|---|
select | 4,177 k | 99.1 k | 63.45 |
show tables | 1,174 k | 27.9 k | 17.83 |
change db | 1,067 k | 25.3 k | 16.21 |
insert | 80,129 | 1,901.9 | 1.22 |
show fields | 20,104 | 477.2 | 0.31 |
set option | 18,489 | 438.9 | 0.28 |
show keys | 16,408 | 389.5 | 0.25 |
show create table | 8,204 | 194.7 | 0.12 |
update | 6,827 | 162 | 0.10 |
delete | 6,522 | 154.8 | 0.10 |
commit | 2,647 | 62.8 | 0.04 |
show table status | 2,060 | 48.9 | 0.03 |
show triggers | 2,048 | 48.6 | 0.03 |
show grants | 562 | 13.3 | 0.01 |
replace | 364 | 8.6 | 0.01 |
show variables | 218 | 5.2 | <0.01 |
show storage engines | 125 | 3 | <0.01 |
rollback | 101 | 2.4 | <0.01 |
show binlogs | 97 | 2.3 | <0.01 |
stmt close | 55 | 1.3 | <0.01 |
stmt execute | 55 | 1.3 | <0.01 |
stmt prepare | 55 | 1.3 | <0.01 |
show slave status | 41 | 1 | <0.01 |
show master status | 38 | 0.9 | <0.01 |
truncate | 36 | 0.9 | <0.01 |
show warnings | 16 | 0.4 | <0.01 |
show status | 14 | 0.3 | <0.01 |
show collations | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |