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 374 5266152484032 113126640 14080621368.0000 73656150480 18 NULL
page_flush_coordinator_thread 1625 1462462244496 3341712 650242428.0000 72125942592 13 NULL
io_write_thread 110 1262458113312 1562233200 11476891800.0000 35640392832 9 NULL
log_checkpointer_thread 90 693258251664 13041600 7702869240.0000 35200168608 15 NULL
io_write_thread 50 626164152768 2411943072 12523282992.0000 26791148208 10 NULL
io_write_thread 12 161346097968 2323530000 13445508120.0000 28454180832 11 NULL
log_writer_thread 587 160663103040 570240 273702000.0000 23353527648 20 NULL
io_write_thread 12 116428570896 2202169728 9702380688.0000 19300778640 12 NULL
main 148 100851103584 74448 495521103.0000 24204492048 1 NULL
srv_purge_thread 2 4721746128 310227984 2360873064.0000 4411518144 36 NULL
srv_worker_thread 1 1913893872 1913893872 1913893872.0000 1913893872 40 NULL
srv_worker_thread 2 1844536848 13766016 922268424.0000 1830770832 42 NULL
clone_gtid_thread 5 839522112 7009200 167904264.0000 393738576 35 NULL
io_read_thread 2 73039296 33921360 36519648.0000 39117936 5 NULL
srv_worker_thread 2 27379968 10956528 13689984.0000 16423440 38 NULL
Query results operations