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 1403 8925337748448 6361609056 711622532544 1927803504 145543019952 8777866924992 8 70656 8832.0000 817 692736 847.9021
innodb/innodb_data_file 3938 6677519274096 1695662496 266892107328 408757542864 103006259664 6165755471568 1604 31391744 19570.9127 1580 58572800 37071.3924
innodb/innodb_temp_file 207 603932470944 2917547952 35035000704 0 40210032720 563722438224 0 0 0.0000 137 3555328 25951.2993
sql/binlog 289 262085872752 906871416 35352778560 1204177920 1252809360 259628885472 62 844 13.6129 17 4851 285.3529
sql/binlog_index 38 59488653840 1565490696 27324990528 8945675376 0 50542978464 9 288 32.0000 0 0 0.0000
sql/ERRMSG 60 48285240432 804753840 5980265280 22640292048 0 25644948384 36 3685829 102384.1389 0 0 0.0000
myisam/kfile 12 6780730176 565060848 2509270896 6656752608 0 123977568 6 1311 218.5000 0 0 0.0000
sql/io_cache 146 3266209584 22371096 190022448 374675664 1961788752 929745168 68 3387866 49821.5588 58 3387866 58411.4828
mysys/cnf 5 1897008960 379401792 1880750256 1882199616 0 14809344 3 56 18.6667 0 0 0.0000
csv/metadata 8 742338432 92792304 389370432 565041312 0 177297120 2 70 35.0000 0 0 0.0000
sql/casetest 15 715649088 47709816 648433632 0 0 715649088 0 0 0.0000 0 0 0.0000
myisam/dfile 61 411875904 6752064 265378080 279453504 0 132422400 50 1950 39.0000 0 0 0.0000
mysys/charset 3 300604656 100201464 279493104 279493104 0 21111552 1 19495 19495.0000 0 0 0.0000
csv/data 12 264611424 22050864 175740576 19649520 0 244961904 3 0 0.0000 0 0 0.0000
sql/misc 5 73586304 14717208 20865504 0 0 73586304 0 0 0.0000 0 0 0.0000
sql/pid 3 17739216 5913072 11240064 0 5728272 12010944 0 0 0.0000 1 4 4.0000
Query results operations