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$host_summary_by_file_io_type`
host event_name total total_latency max_latency
192.168.30.20 wait/io/file/sql/binlog 1454 1931540757168 33625497312
192.168.30.20 wait/io/file/innodb/innodb_temp_file 172 1485051051264 34506066144
192.168.30.20 wait/io/file/innodb/innodb_data_file 688 965926196928 35831249520
192.168.30.20 wait/io/file/sql/ERRMSG 50 38797784256 9018566832
192.168.30.20 wait/io/file/sql/io_cache 48 8163907488 7347689184
192.168.30.20 wait/io/file/csv/metadata 8 4179483264 1603221312
192.168.30.20 wait/io/file/csv/data 9 1158915648 805551648
192.168.30.20 wait/io/file/myisam/kfile 4 618404160 594906048
192.168.30.20 wait/io/file/sql/misc 5 572665104 293603904
192.168.30.20 wait/io/file/myisam/dfile 2 9832944 9354576
192.168.30.20 wait/io/file/sql/binlog_index 2 5592048 3021216
background wait/io/file/innodb/innodb_log_file 3704 19454767097568 232667263488
background wait/io/file/innodb/innodb_data_file 5792 11126060827728 198498515952
background wait/io/file/innodb/innodb_temp_file 371 1259463704400 430788258912
background wait/io/file/sql/binlog_index 36 51560047968 34978297728
background wait/io/file/sql/binlog 37 28157115888 15152027088
background wait/io/file/mysys/cnf 5 1336449312 1318897536
background wait/io/file/sql/ERRMSG 5 1232995632 369688176
background wait/io/file/sql/casetest 15 910048128 839172576
background wait/io/file/mysys/charset 3 304270560 262034784
background wait/io/file/sql/pid 3 12713712 10369392
background wait/io/file/sql/misc 1 4122624 4122624
Query results operations