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 | 13,030 k | 775.5 k | 71.12 |
| delete | 1,072 k | 63.8 k | 5.85 |
| show fields | 647 k | 38.5 k | 3.53 |
| show keys | 640 k | 38.1 k | 3.49 |
| insert | 614 k | 36.6 k | 3.35 |
| change db | 524 k | 31.2 k | 2.86 |
| update | 460 k | 27.4 k | 2.51 |
| set option | 308 k | 18.3 k | 1.68 |
| show tables | 265 k | 15.8 k | 1.45 |
| show create table | 262 k | 15.6 k | 1.43 |
| flush | 153 k | 9,113.6 | 0.84 |
| show variables | 92,122 | 5,482.7 | 0.50 |
| replace | 57,927 | 3,447.6 | 0.32 |
| show grants | 50,188 | 2,987 | 0.27 |
| show slave status | 43,086 | 2,564.3 | 0.24 |
| show master status | 42,306 | 2,517.9 | 0.23 |
| show binlogs | 19,478 | 1,159.3 | 0.11 |
| show create proc | 17,052 | 1,014.9 | 0.09 |
| show plugins | 8,612 | 512.6 | 0.05 |
| show storage engines | 5,833 | 347.2 | 0.03 |
| show create func | 5,278 | 314.1 | 0.03 |
| show status | 934 | 55.6 | 0.01 |
| call procedure | 637 | 37.9 | <0.01 |
| drop table | 461 | 27.4 | <0.01 |
| insert select | 461 | 27.4 | <0.01 |
| create temporary table | 461 | 27.4 | <0.01 |
| show table status | 421 | 25.1 | <0.01 |
| stmt prepare | 136 | 8.1 | <0.01 |
| stmt close | 136 | 8.1 | <0.01 |
| stmt execute | 136 | 8.1 | <0.01 |
| show processlist | 73 | 4.3 | <0.01 |