Press Ctrl+Enter to execute queryPress Enter to execute query
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: mysql Queried time: During current session
SELECT * FROM `innodb_index_stats`
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,152 k | 313.6 k | 73.88 |
| delete | 238 k | 23.7 k | 5.59 |
| insert | 137 k | 13.7 k | 3.22 |
| show fields | 131 k | 13 k | 3.07 |
| show keys | 118 k | 11.7 k | 2.76 |
| update | 102 k | 10.2 k | 2.40 |
| change db | 92,822 | 9,237.6 | 2.18 |
| set option | 68,853 | 6,852.2 | 1.61 |
| show tables | 66,540 | 6,622 | 1.56 |
| show create table | 47,930 | 4,769.9 | 1.12 |
| flush | 34,052 | 3,388.8 | 0.80 |
| show variables | 22,613 | 2,250.4 | 0.53 |
| show grants | 11,849 | 1,179.2 | 0.28 |
| replace | 11,222 | 1,116.8 | 0.26 |
| show slave status | 8,664 | 862.2 | 0.20 |
| show master status | 8,407 | 836.7 | 0.20 |
| show create proc | 5,124 | 509.9 | 0.12 |
| show binlogs | 4,138 | 411.8 | 0.10 |
| show create func | 1,586 | 157.8 | 0.04 |
| show storage engines | 805 | 80.1 | 0.02 |
| show plugins | 790 | 78.6 | 0.02 |
| call procedure | 380 | 37.8 | 0.01 |
| show status | 369 | 36.7 | 0.01 |
| insert select | 291 | 29 | 0.01 |
| create temporary table | 291 | 29 | 0.01 |
| drop table | 291 | 29 | 0.01 |
| stmt prepare | 52 | 5.2 | <0.01 |
| stmt close | 52 | 5.2 | <0.01 |
| stmt execute | 52 | 5.2 | <0.01 |
| show processlist | 28 | 2.8 | <0.01 |