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 | 81 | 1108591530288 | 77382624 | 13686314928.0000 | 36331396992 | 18 | NULL | |
page_flush_coordinator_thread | 481 | 417708354624 | 3342240 | 549375024.0000 | 29554955760 | 13 | NULL | |
io_write_thread | 47 | 337597619040 | 1555310064 | 7182927840.0000 | 21898897680 | 9 | NULL | |
log_checkpointer_thread | 44 | 270717349056 | 7773744 | 6152666784.0000 | 15751503504 | 15 | NULL | |
io_write_thread | 7 | 83797680912 | 1612905360 | 11971097160.0000 | 42105118704 | 11 | NULL | |
io_write_thread | 10 | 76100267760 | 1761209472 | 7610026776.0000 | 22320733776 | 10 | NULL | |
main | 133 | 51946791072 | 73392 | 242374572.0000 | 24349930176 | 1 | NULL | |
log_writer_thread | 127 | 29815947216 | 576048 | 234770976.0000 | 3933433680 | 20 | NULL | |
io_write_thread | 4 | 16632022704 | 1739393040 | 4158005544.0000 | 11351551200 | 12 | NULL | |
clone_gtid_thread | 4 | 1182756432 | 213102912 | 295688976.0000 | 335605248 | 35 | NULL | |
srv_worker_thread | 1 | 359889552 | 359889552 | 359889552.0000 | 359889552 | 40 | NULL | |
io_read_thread | 3 | 63045840 | 17241840 | 21015192.0000 | 25642848 | 5 | NULL | |
buf_dump_thread | 5 | 23678688 | 3520176 | 4735632.0000 | 6304848 | 34 | NULL |
|