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 | 713 | 9364336809696 | 41534064 | 13133711976.0000 | 154196825904 | 18 | NULL | |
page_flush_coordinator_thread | 2375 | 1740764743344 | 3445200 | 2189691900.0000 | 148382622432 | 13 | NULL | |
io_write_thread | 120 | 1101837520080 | 1393126944 | 9181979136.0000 | 25621608672 | 9 | NULL | |
log_writer_thread | 1102 | 836323005408 | 497376 | 758913672.0000 | 263690719248 | 20 | NULL | |
io_write_thread | 56 | 627393287136 | 1519309968 | 11203451424.0000 | 35788967808 | 11 | NULL | |
log_checkpointer_thread | 94 | 621297160704 | 9095856 | 6609544128.0000 | 26204609376 | 15 | NULL | |
io_write_thread | 35 | 340474070640 | 1497472944 | 9727830552.0000 | 22623273024 | 10 | NULL | |
io_write_thread | 19 | 203280860112 | 1776714192 | 10698992568.0000 | 22293959952 | 12 | NULL | |
main | 147 | 113016980736 | 79200 | 435183177.0000 | 30858444672 | 1 | NULL | |
io_read_thread | 17 | 12087527760 | 20135808 | 711030936.0000 | 10908177984 | 5 | NULL | |
srv_purge_thread | 3 | 9725139072 | 211017840 | 3241713024.0000 | 5825972064 | 36 | NULL | |
srv_worker_thread | 2 | 1172856432 | 9038304 | 586428216.0000 | 1163818128 | 38 | NULL | |
clone_gtid_thread | 5 | 1016555232 | 8135952 | 203310888.0000 | 361491504 | 35 | NULL | |
srv_worker_thread | 2 | 22478016 | 10327680 | 11239008.0000 | 12150336 | 42 | NULL |
|