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 1231 16074410204160 50896560 13058009712.0000 232667263488 18 NULL
page_flush_coordinator_thread 3915 5290094582256 3419856 2253008208.0000 430788258912 13 NULL
io_write_thread 476 3702519537024 1416223248 7778402280.0000 42988670736 9 NULL
log_checkpointer_thread 364 2327574422976 6345504 6394435080.0000 24873566256 15 NULL
io_write_thread 175 1399012884720 116481024 7994359296.0000 42591527088 10 NULL
io_write_thread 85 734511193152 1601212800 8641307928.0000 24091550208 11 NULL
log_writer_thread 1976 466108197456 453024 235884528.0000 115221619392 20 NULL
io_write_thread 36 337947183024 1477180848 9387421560.0000 29795541600 12 NULL
main 148 90241464720 74976 378293883.0000 34978297728 1 NULL
srv_purge_thread 3 7095487344 171519216 2365162272.0000 4488255552 36 NULL
io_read_thread 16 627285120 27664032 39205320.0000 64732272 5 NULL
srv_worker_thread 2 622887408 7290624 311443704.0000 615596784 42 NULL
clone_gtid_thread 4 486169728 5510208 121542432.0000 278672064 35 NULL
srv_worker_thread 3 175569504 9224160 58522992.0000 156761088 38 NULL
srv_worker_thread 1 10656624 10656624 10656624.0000 10656624 40 NULL
Query results operations