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 | 346 | 4930657489296 | 97933440 | 14250454944.0000 | 106033953696 | 18 | NULL | |
io_write_thread | 163 | 1686835978608 | 148090272 | 10348686744.0000 | 29872443216 | 9 | NULL | |
page_flush_coordinator_thread | 1291 | 1683313084464 | 4008576 | 688851900.0000 | 41122122624 | 13 | NULL | |
log_writer_thread | 528 | 1066810145808 | 528528 | 2020473576.0000 | 849504353808 | 20 | NULL | |
log_checkpointer_thread | 124 | 921612024960 | 9097968 | 7432355040.0000 | 23954370528 | 15 | NULL | |
io_write_thread | 50 | 589917492912 | 2299367664 | 11798349816.0000 | 35727891936 | 10 | NULL | |
main | 146 | 112987081152 | 136224 | 460560606.0000 | 33475521552 | 1 | NULL | |
io_write_thread | 8 | 88139982480 | 1830324144 | 11017497744.0000 | 16328229456 | 12 | NULL | |
io_write_thread | 7 | 67807633872 | 2448818064 | 9686804688.0000 | 16071062832 | 11 | NULL | |
srv_purge_thread | 2 | 5155256832 | 799140144 | 2577628416.0000 | 4356116688 | 36 | NULL | |
srv_worker_thread | 2 | 1878091248 | 10273296 | 939045624.0000 | 1867817952 | 40 | NULL | |
clone_gtid_thread | 5 | 1074031200 | 6498096 | 214806240.0000 | 388506624 | 35 | NULL | |
io_read_thread | 11 | 396647856 | 19496400 | 36058704.0000 | 57969120 | 5 | NULL | |
srv_worker_thread | 2 | 25159728 | 7621152 | 12579864.0000 | 17538576 | 38 | NULL |
|