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 | 438 | 5949277246704 | 71970096 | 13582824552.0000 | 50742345984 | 18 | NULL | |
page_flush_coordinator_thread | 1717 | 1763256839520 | 4296336 | 842326056.0000 | 73640725488 | 13 | NULL | |
io_write_thread | 134 | 1519582533216 | 1635068688 | 11340168048.0000 | 39198755376 | 9 | NULL | |
log_checkpointer_thread | 128 | 937501799520 | 8416848 | 7324232784.0000 | 27210831648 | 15 | NULL | |
io_write_thread | 44 | 523719878880 | 1585345872 | 11902724328.0000 | 35958215040 | 10 | NULL | |
io_write_thread | 32 | 304650100128 | 1610933808 | 9520315464.0000 | 20788591296 | 11 | NULL | |
log_writer_thread | 683 | 226301059248 | 514800 | 331333728.0000 | 18300954672 | 20 | NULL | |
io_write_thread | 12 | 137822334144 | 4278810096 | 11485194336.0000 | 18895063968 | 12 | NULL | |
main | 148 | 107452950000 | 77088 | 418342782.0000 | 28360815648 | 1 | NULL | |
srv_purge_thread | 2 | 2282892480 | 198068112 | 1141446240.0000 | 2084824368 | 36 | NULL | |
srv_worker_thread | 2 | 1102853664 | 14825712 | 551426832.0000 | 1088027952 | 38 | NULL | |
clone_gtid_thread | 5 | 974284608 | 5306400 | 194856816.0000 | 335834400 | 35 | NULL | |
io_read_thread | 13 | 633751008 | 17053872 | 48749976.0000 | 321813360 | 5 | NULL | |
srv_worker_thread | 1 | 34642608 | 34642608 | 34642608.0000 | 34642608 | 40 | NULL | |
srv_worker_thread | 2 | 19555536 | 8668704 | 9777768.0000 | 10886832 | 42 | NULL |
|