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_by_thread_by_latency`
user total total_latency min_latency avg_latency max_latency thread_id processlist_id
log_flusher_thread 2305 29113232329104 53357040 12630469368.0000 116198231952 18 NULL
page_flush_coordinator_thread 9411 5905739056272 3348048 733126812.0000 658381239120 13 NULL
io_write_thread 369 3114545493840 1475753664 8440502664.0000 32042434512 9 NULL
io_write_thread 188 1773816357456 1475298000 9435193152.0000 35809787376 10 NULL
log_checkpointer_thread 254 1649939389824 9725232 6495824280.0000 23165578128 15 NULL
log_writer_thread 3691 960376048896 477840 260193912.0000 50550257472 20 NULL
io_write_thread 112 925067032560 41692464 8259526968.0000 24433925472 11 NULL
io_write_thread 47 393388145040 1644499824 8369960280.0000 28734508176 12 NULL
main 147 112940085984 104544 440013354.0000 35547195024 1 NULL
srv_purge_thread 4 12506212752 377300352 3126553056.0000 7726760976 36 NULL
srv_worker_thread 2 1489366560 18661632 744683280.0000 1470704928 38 NULL
clone_gtid_thread 5 909830592 4311648 181965960.0000 313576560 35 NULL
io_read_thread 9 150358560 6010224 16706448.0000 31891200 5 NULL
srv_worker_thread 2 29687328 10693584 14843664.0000 18993744 42 NULL
Query results operations