| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,208 k | 4,054.7 | 62.79 |
| stmt execute | 135 k | 452.4 | 7.01 |
| stmt prepare | 135 k | 452.4 | 7.01 |
| stmt close | 129 k | 433.6 | 6.71 |
| show tables | 71,619 | 240.5 | 3.72 |
| show fields | 70,605 | 237.1 | 3.67 |
| change db | 51,045 | 171.4 | 2.65 |
| set option | 39,855 | 133.8 | 2.07 |
| show keys | 37,953 | 127.4 | 1.97 |
| show variables | 14,081 | 47.3 | 0.73 |
| replace | 11,457 | 38.5 | 0.60 |
| show create table | 9,032 | 30.3 | 0.47 |
| show warnings | 6,305 | 21.2 | 0.33 |
| insert | 3,033 | 10.2 | 0.16 |
| show storage engines | 1,271 | 4.3 | 0.07 |
| update | 218 | 0.7 | 0.01 |
| show slave status | 179 | 0.6 | 0.01 |
| show master status | 175 | 0.6 | 0.01 |
| show table status | 123 | 0.4 | 0.01 |
| show grants | 79 | 0.3 | <0.01 |
| show binlogs | 36 | 0.1 | <0.01 |
| delete | 33 | 0.1 | <0.01 |
| show status | 19 | 0.1 | <0.01 |
| insert select | 12 | <0.1 | <0.01 |
| load | 6 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| truncate | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |