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_bytes`
event_name total total_latency min_latency avg_latency max_latency count_read total_read avg_read count_write total_written avg_written total_requested
innodb/innodb_data_file 3065 3945507358848 0 1287277992 251879416800 1490 29523968 19814.7436 1090 43859968 40238.5028 73383936
sql/io_cache 248 118995494640 0 479820528 99457762800 124 5712630 46069.5968 94 5712630 60772.6596 11425260
innodb/innodb_temp_file 232 768773685504 0 3313679424 45797898432 0 0 0.0000 154 4358144 28299.6364 4358144
sql/ERRMSG 70 47964225408 3081936 685203024 3373521888 42 4295551 102275.0238 0 0 0.0000 4295551
innodb/innodb_log_file 1095 6206220187728 231264 5667780888 76632790080 8 70656 8832.0000 637 503296 790.1036 573952
mysys/charset 3 237507600 2109360 79169112 223908432 1 19495 19495.0000 0 0 0.0000 19495
myisam/kfile 16 4107372720 748176 256710696 2540267136 8 1703 212.8750 0 0 0.0000 1703
sql/binlog 329 90075266160 0 273784896 34319600304 78 908 11.6410 5 702 140.4000 1610
myisam/dfile 22 2567777520 326304 116717040 840070176 5 684 136.8000 0 0 0.0000 684
sql/binlog_index 38 49527827184 0 1303363776 29235324624 9 288 32.0000 0 0 0.0000 288
csv/metadata 8 4715480352 583968 589434912 2288548944 2 70 35.0000 0 0 0.0000 70
mysys/cnf 5 497655312 97680 99530904 467324352 3 56 18.6667 0 0 0.0000 56
sql/pid 3 50563920 2946768 16854552 37407216 0 0 0.0000 1 4 4.0000 4
sql/casetest 15 840492048 0 56032680 762506976 0 0 0.0000 0 0 0.0000 0
sql/misc 2 24433200 0 12216600 12694176 0 0 0.0000 0 0 0.0000 0
csv/data 45 3075678144 0 68348280 2702957664 17 0 0.0000 0 0 0.0000 0
Query results operations