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 2865 2860774392432 0 998525088 241436605872 1525 30097408 19736.0052 897 38027264 42393.8283 68124672
sql/ERRMSG 55 44222346960 3449424 804042624 3556964928 33 3382422 102497.6364 0 0 0.0000 3382422
innodb/innodb_temp_file 99 491150442288 0 4961115456 58372161408 0 0 0.0000 37 1392640 37638.9189 1392640
innodb/innodb_log_file 846 4941756578880 228624 5841319704 70557660624 8 70656 8832.0000 491 376832 767.4786 447488
mysys/charset 3 261455040 3266736 87151680 241227888 1 19495 19495.0000 0 0 0.0000 19495
myisam/dfile 61 531371808 184272 8710944 409269168 50 3350 67.0000 0 0 0.0000 3350
myisam/kfile 16 3910970448 828432 244435488 1667850624 8 1703 212.8750 0 0 0.0000 1703
sql/binlog 427 47446917936 0 111116808 16443649200 103 1008 9.7864 4 400 100.0000 1408
sql/binlog_index 38 59026654368 0 1553332968 37585876944 9 288 32.0000 0 0 0.0000 288
csv/metadata 8 1266822480 660528 158352744 559567536 2 70 35.0000 0 0 0.0000 70
mysys/cnf 5 2031298368 202752 406259568 1995702192 3 56 18.6667 0 0 0.0000 56
sql/pid 3 25743168 1256112 8581056 17955696 0 0 0.0000 1 4 4.0000 4
sql/casetest 15 1043250384 0 69550008 959095632 0 0 0.0000 0 0 0.0000 0
sql/misc 2 19860192 0 9930096 10661904 0 0 0.0000 0 0 0.0000 0
csv/data 6 619933248 0 103322208 307826640 0 0 0.0000 0 0 0.0000 0
Query results operations