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 | 687 | 9563601123120 | 106812288 | 13920816624.0000 | 52457835936 | 18 | NULL | |
page_flush_coordinator_thread | 1989 | 2157442756128 | 3449424 | 1908981096.0000 | 144452091696 | 13 | NULL | |
io_write_thread | 98 | 1257584492736 | 1640287968 | 12832494576.0000 | 32595925824 | 9 | NULL | |
log_checkpointer_thread | 98 | 720933111888 | 10302864 | 7623541596.0000 | 38743893408 | 15 | NULL | |
io_write_thread | 45 | 541014194688 | 53756208 | 12022537560.0000 | 30024817152 | 10 | NULL | |
io_write_thread | 41 | 526851134832 | 237893040 | 12850027608.0000 | 39810468192 | 11 | NULL | |
log_writer_thread | 1528 | 450094955376 | 465168 | 294564600.0000 | 13263440784 | 20 | NULL | |
io_write_thread | 10 | 124878743616 | 1971028224 | 12487874256.0000 | 40236255312 | 12 | NULL | |
main | 147 | 105002350464 | 73920 | 425440323.0000 | 23615888208 | 1 | NULL | |
srv_worker_thread | 3 | 9986105184 | 7854000 | 3328701552.0000 | 9024750768 | 40 | NULL | |
srv_purge_thread | 2 | 3904044672 | 197552256 | 1952022336.0000 | 3706492416 | 36 | NULL | |
clone_gtid_thread | 5 | 1077175968 | 6772128 | 215435088.0000 | 363170544 | 35 | NULL | |
srv_worker_thread | 2 | 23933184 | 6710880 | 11966592.0000 | 17222304 | 42 | NULL |
|