Statements | # | ø per hour | % |
---|---|---|---|
select | 6,278 k | 32.1 k | 81.69 |
show tables | 261 k | 1,335.1 | 3.39 |
set option | 212 k | 1,085.6 | 2.76 |
show fields | 208 k | 1,064.2 | 2.71 |
insert | 176 k | 900.1 | 2.29 |
stmt execute | 146 k | 747 | 1.90 |
show keys | 117 k | 598.4 | 1.52 |
change db | 81,937 | 419.5 | 1.07 |
show variables | 54,582 | 279.4 | 0.71 |
show create table | 42,459 | 217.4 | 0.55 |
delete multi | 33,038 | 169.1 | 0.43 |
update | 21,382 | 109.5 | 0.28 |
show warnings | 21,300 | 109 | 0.28 |
show grants | 18,794 | 96.2 | 0.24 |
show storage engines | 5,570 | 28.5 | 0.07 |
stmt close | 3,410 | 17.5 | 0.04 |
stmt prepare | 3,410 | 17.5 | 0.04 |
show slave status | 409 | 2.1 | 0.01 |
show master status | 396 | 2 | 0.01 |
show table status | 392 | 2 | 0.01 |
show binlogs | 380 | 1.9 | <0.01 |
show status | 65 | 0.3 | <0.01 |
show processlist | 10 | 0.1 | <0.01 |
show engine status | 3 | <0.1 | <0.01 |