Drop files here

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `x$io_global_by_wait_by_latency`
event_name total total_latency avg_latency max_latency read_latency write_latency misc_latency count_read total_read avg_read count_write total_written avg_written
innodb/innodb_log_file 3051 15264139446336 5002995360 66504710976 1329255312 543823399680 14718986791344 8 70656 8832.0000 1977 2875392 1454.4219
innodb/innodb_data_file 4969 8426252813088 1695764136 896965923744 380206710048 115246772784 7930799330256 1663 32358400 19457.8473 2257 79478784 35214.3482
innodb/innodb_temp_file 175 937208381472 5355476280 45681657120 0 3911970480 933296410992 0 0 0.0000 86 3964928 46103.8140
sql/binlog 627 852250480224 1359250992 27047201280 3005384976 9681804528 839563290720 126 1100 8.7302 58 12523 215.9138
sql/ERRMSG 80 60598762752 757484376 2335312320 36772187760 0 23826574992 48 4912471 102343.1458 0 0 0.0000
sql/binlog_index 38 46624287072 1226954784 29608567296 651157056 0 45973130016 9 288 32.0000 0 0 0.0000
myisam/kfile 24 5907037488 246126408 3093195600 5228032656 0 679004832 8 1703 212.8750 0 0 0.0000
myisam/dfile 51 3616861776 70918848 2328346944 2632440096 0 984421680 4 201 50.2500 0 0 0.0000
csv/metadata 8 2092014144 261501768 1143780528 1656717216 0 435296928 2 70 35.0000 0 0 0.0000
mysys/cnf 5 1613411712 322682184 1595294448 1596990912 0 16420800 3 56 18.6667 0 0 0.0000
sql/misc 9 842293584 93588000 680217120 0 0 842293584 0 0 0.0000 0 0 0.0000
sql/casetest 15 794786784 52985592 729273600 0 0 794786784 0 0 0.0000 0 0 0.0000
sql/io_cache 15 463298352 30886416 219344400 16144128 178359456 268794768 4 278912 69728.0000 6 274538 45756.3333
mysys/charset 3 279845808 93281760 264750816 264750816 0 15094992 1 19495 19495.0000 0 0 0.0000
csv/data 20 148011600 7400448 38676000 27692016 0 120319584 7 0 0.0000 0 0 0.0000
sql/pid 3 12715296 4238256 10026720 0 1707552 11007744 0 0 0.0000 1 4 4.0000
Query results operations