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 | 620 | 8012549563920 | 51618864 | 12923466864.0000 | 99861570864 | 18 | NULL | |
page_flush_coordinator_thread | 2130 | 1733039122320 | 3530736 | 449193624.0000 | 41497504224 | 13 | NULL | |
io_write_thread | 99 | 1070890469088 | 1496476080 | 10817075280.0000 | 35062796208 | 10 | NULL | |
io_write_thread | 86 | 882049929024 | 1630168848 | 10256394456.0000 | 32072436000 | 9 | NULL | |
log_checkpointer_thread | 102 | 688620767472 | 7896768 | 6751183824.0000 | 19215412128 | 15 | NULL | |
io_write_thread | 44 | 424575468240 | 1551198000 | 9649442352.0000 | 25592086608 | 11 | NULL | |
log_writer_thread | 1013 | 290659951296 | 487872 | 286929720.0000 | 62191541808 | 20 | NULL | |
io_write_thread | 27 | 239360103840 | 1639284240 | 8865188904.0000 | 27620815200 | 12 | NULL | |
main | 148 | 111303530448 | 73920 | 429020064.0000 | 28334670144 | 1 | NULL | |
srv_purge_thread | 2 | 4811410032 | 907331568 | 2405705016.0000 | 3904078464 | 36 | NULL | |
clone_gtid_thread | 5 | 909953616 | 4989072 | 181990512.0000 | 312573360 | 35 | NULL | |
srv_worker_thread | 2 | 396918720 | 76300224 | 198459360.0000 | 320618496 | 42 | NULL | |
root@192.168.30.20 | 1 | 354850320 | 354850320 | 354850320.0000 | 354850320 | 2787 | 2591 | |
io_read_thread | 9 | 324538368 | 23388816 | 36059760.0000 | 53237712 | 5 | NULL | |
srv_worker_thread | 2 | 39579936 | 10353552 | 19789968.0000 | 29226384 | 38 | NULL |
|