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$waits_by_host_by_latency`
host event total total_latency avg_latency max_latency
192.168.30.20 wait/io/file/innodb/innodb_data_file 1068 5147465867808 4819724448 61316928288
192.168.30.20 wait/io/file/sql/binlog 460 960986206224 2089100376 26358768480
192.168.30.20 wait/io/file/innodb/innodb_temp_file 10 152836673088 15283667256 59326410000
192.168.30.20 wait/lock/metadata/sql/mdl 3 106157302416 35385767472 42809364048
192.168.30.20 wait/io/file/sql/ERRMSG 75 51143245296 681909888 3520746768
192.168.30.20 wait/io/table/sql/handler 493 12296637936 24942456 2296954704
192.168.30.20 wait/io/file/csv/metadata 8 7341413904 917676672 6102433392
192.168.30.20 wait/io/file/sql/io_cache 128 5635510320 44027280 1315923840
192.168.30.20 wait/io/file/sql/misc 1 475957680 475957680 475957680
192.168.30.20 wait/lock/table/sql/handler 278 437200368 1572648 16683216
192.168.30.20 wait/io/file/csv/data 24 239854560 9993720 34653696
192.168.30.20 wait/io/file/sql/binlog_index 2 6160704 3080352 3734544
background wait/io/file/innodb/innodb_log_file 5462 25549429237728 4677668952 271082991168
background wait/io/file/innodb/innodb_data_file 3215 5243370415008 1630908312 226523228976
background wait/lock/metadata/sql/mdl 3 871696326864 290565442200 322456460832
background wait/io/file/innodb/innodb_temp_file 171 335738307168 1963381728 24377057232
background wait/io/file/sql/binlog_index 36 52277213472 1452144672 32349496608
background wait/io/file/sql/binlog 37 29572919376 799267920 15486371472
background wait/io/file/sql/casetest 15 1883990064 125599320 1775838768
background wait/io/file/sql/ERRMSG 5 1439908272 287981496 515430432
background wait/io/file/mysys/cnf 5 503242080 100648416 479072880
background wait/io/file/mysys/charset 3 289720992 96573576 262500480
background wait/io/file/sql/pid 3 16400208 5466648 13230624
background wait/io/file/sql/misc 1 5912016 5912016 5912016
Query results operations