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 | 388 | 5461092991200 | 52159536 | 14074981800.0000 | 168557720496 | 18 | NULL | |
io_write_thread | 85 | 1032105607104 | 2369571072 | 12142418904.0000 | 33376700544 | 9 | NULL | |
page_flush_coordinator_thread | 1228 | 772996051344 | 3717120 | 329877900.0000 | 45822801024 | 13 | NULL | |
log_checkpointer_thread | 50 | 383319839232 | 12631872 | 7666396584.0000 | 26954448048 | 15 | NULL | |
io_write_thread | 19 | 328831761984 | 2558881776 | 17306934744.0000 | 46810771920 | 10 | NULL | |
log_writer_thread | 624 | 279274413792 | 540672 | 447554976.0000 | 62261388816 | 20 | NULL | |
main | 148 | 102538135392 | 67584 | 400230996.0000 | 26204664816 | 1 | NULL | |
io_write_thread | 4 | 44003714304 | 1777140288 | 11000928576.0000 | 19359602592 | 11 | NULL | |
srv_purge_thread | 2 | 4831558512 | 869187792 | 2415779256.0000 | 3962370720 | 36 | NULL | |
io_read_thread | 40 | 1504857024 | 10359360 | 37621320.0000 | 68975280 | 5 | NULL | |
srv_worker_thread | 2 | 1048397856 | 15259728 | 524198928.0000 | 1033138128 | 42 | NULL | |
clone_gtid_thread | 5 | 1022200080 | 6396720 | 204440016.0000 | 365726064 | 35 | NULL | |
srv_worker_thread | 1 | 915135408 | 915135408 | 915135408.0000 | 915135408 | 38 | NULL | |
srv_worker_thread | 2 | 534234624 | 8723616 | 267117312.0000 | 525511008 | 40 | NULL |
|