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 666 3290058524016 4940027664 55941856608 991046496 74261860464 3214805617056 8 70656 8832.0000 390 327680 840.2051
innodb/innodb_data_file 2585 1646578879968 636974184 166257791568 135086385984 30954675312 1480537818672 1427 28884992 20241.7603 809 35405824 43764.9246
innodb/innodb_temp_file 380 648837996576 1707468312 31644407520 0 5688995136 643149001440 0 0 0.0000 300 6881280 22937.6000
sql/binlog 205 110879379072 540875016 19205654160 6887191344 5553180336 98439007392 50 41331 826.6200 8 1523 190.3750
sql/io_cache 362 56261386896 155418120 20209811952 1016968128 6048848784 49195569984 148 8921296 60279.0270 154 8921296 57930.4935
sql/ERRMSG 55 22748184096 413603256 3005070816 15248655840 0 7499528256 33 3378381 102375.1818 0 0 0.0000
sql/binlog_index 23 2590743936 112640880 1499027376 908326320 0 1682417616 5 160 32.0000 0 0 0.0000
sql/casetest 15 1382973504 92198040 1247282784 0 0 1382973504 0 0 0.0000 0 0 0.0000
mysys/cnf 5 293971920 58794384 265769328 267234528 0 26737392 3 56 18.6667 0 0 0.0000
mysys/charset 3 256581072 85527024 221153856 221153856 0 35427216 1 19495 19495.0000 0 0 0.0000
sql/misc 5 52722912 10544424 13053216 0 0 52722912 0 0 0.0000 0 0 0.0000
sql/pid 3 19885008 6628248 16137264 0 2752464 17132544 0 0 0.0000 1 5 5.0000
Query results operations