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 491 7584667834656 43764336 15447388440.0000 711622532544 18 NULL
page_flush_coordinator_thread 1805 2560697760192 3672768 931964880.0000 39993684720 13 NULL
io_write_thread 227 2177514948048 1509488640 9592576752.0000 31512757056 9 NULL
log_checkpointer_thread 190 1415762277600 6595776 7451380200.0000 28226837760 15 NULL
io_write_thread 88 966518984640 333005904 10983170088.0000 30330524928 10 NULL
io_write_thread 23 195014077632 1650993168 8478872688.0000 19732871136 11 NULL
io_write_thread 13 142922965152 4324684320 10994074080.0000 31262766480 12 NULL
log_writer_thread 740 140521931616 475728 189894408.0000 9410846016 20 NULL
main 146 95257736112 77088 413436606.0000 27324990528 1 NULL
srv_purge_thread 2 5280199584 272621184 2640099792.0000 5007578400 36 NULL
io_read_thread 19 1092696528 16129872 57510288.0000 150781488 5 NULL
clone_gtid_thread 5 959724480 15259728 191944896.0000 330051216 35 NULL
srv_worker_thread 2 677844816 7264752 338922408.0000 670580064 42 NULL
srv_worker_thread 2 14429712 6957984 7214856.0000 7471728 40 NULL
Query results operations