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 321 5727926596656 85855440 17844007896.0000 595801238736 18 NULL
page_flush_coordinator_thread 1040 757370895072 3595152 392649972.0000 48315328512 13 NULL
io_write_thread 51 524386396512 1692290688 10282086144.0000 23445378000 9 NULL
io_write_thread 22 378806207472 2834347824 17218463856.0000 63049728720 12 NULL
io_write_thread 31 339319656720 1651362240 10945795344.0000 22982480400 10 NULL
log_checkpointer_thread 44 332474571264 9029856 7556240208.0000 38125212048 15 NULL
log_writer_thread 735 216888506736 466224 295086264.0000 93364505520 20 NULL
io_write_thread 13 184370464608 2915305536 14182343208.0000 35091392688 11 NULL
srv_purge_thread 2 114734679312 1852489584 57367339656.0000 112882189728 36 NULL
main 148 89492362080 80256 376686948.0000 32172832560 1 NULL
clone_gtid_thread 5 852342480 4401408 170468496.0000 297160512 35 NULL
io_read_thread 3 182982624 35329008 60994032.0000 105778992 5 NULL
srv_worker_thread 3 144482976 7664976 48160992.0000 126642912 42 NULL
srv_worker_thread 2 24178176 6534528 12089088.0000 17643648 38 NULL
Query results operations