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 | 71 | 1036920818208 | 74824992 | 14604518544.0000 | 113166174000 | 18 | NULL | |
io_write_thread | 27 | 266484260064 | 1592545152 | 9869787312.0000 | 22759719840 | 9 | NULL | |
page_flush_coordinator_thread | 282 | 252336066048 | 4031808 | 487542528.0000 | 50271564288 | 13 | NULL | |
log_checkpointer_thread | 20 | 135092691888 | 12614448 | 6754634568.0000 | 17325158400 | 15 | NULL | |
main | 150 | 127405644432 | 73920 | 517717563.0000 | 35691669552 | 1 | NULL | |
io_write_thread | 7 | 81296051232 | 3905884752 | 11613721416.0000 | 21711474576 | 10 | NULL | |
io_write_thread | 3 | 32193695952 | 2535477120 | 10731231984.0000 | 18784386720 | 11 | NULL | |
log_writer_thread | 106 | 29579145024 | 498960 | 279048528.0000 | 7927874592 | 20 | NULL | |
clone_gtid_thread | 5 | 934061040 | 4448400 | 186812208.0000 | 324934368 | 35 | NULL | |
srv_purge_thread | 1 | 933075792 | 933075792 | 933075792.0000 | 933075792 | 36 | NULL | |
io_read_thread | 15 | 710931408 | 28218432 | 47395392.0000 | 77050512 | 5 | NULL | |
srv_worker_thread | 2 | 48585504 | 17587152 | 24292752.0000 | 30998352 | 42 | NULL | |
srv_worker_thread | 3 | 37100976 | 7570464 | 12366816.0000 | 17230752 | 38 | NULL |
|