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 | 430 | 5807642473776 | 71970096 | 13506145224.0000 | 50742345984 | 18 | NULL | |
page_flush_coordinator_thread | 1698 | 1720723852848 | 4296336 | 836740344.0000 | 73640725488 | 13 | NULL | |
io_write_thread | 134 | 1519582533216 | 1635068688 | 11340168048.0000 | 39198755376 | 9 | NULL | |
log_checkpointer_thread | 124 | 908438616096 | 8416848 | 7326117744.0000 | 27210831648 | 15 | NULL | |
io_write_thread | 41 | 501982741392 | 1646219520 | 12243481272.0000 | 35958215040 | 10 | NULL | |
io_write_thread | 27 | 275763532704 | 1610933808 | 10213464096.0000 | 20788591296 | 11 | NULL | |
log_writer_thread | 672 | 199032665040 | 514800 | 296179488.0000 | 14405438256 | 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 |
|