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 | 7026 | 69710816771904 | 35653728 | 9921835440.0000 | 246000175344 | 18 | NULL | |
page_flush_coordinator_thread | 6302 | 7969161404160 | 3550800 | 2025180960.0000 | 135545000976 | 13 | NULL | |
io_write_thread | 274 | 3244767705696 | 178781856 | 11842217904.0000 | 41253447840 | 9 | NULL | |
log_writer_thread | 14907 | 2407614201168 | 465696 | 161508864.0000 | 16896444576 | 20 | NULL | |
io_write_thread | 137 | 1606867528992 | 1632267120 | 11728960056.0000 | 43738061664 | 10 | NULL | |
log_checkpointer_thread | 233 | 1459453968192 | 6184464 | 9028657572.0000 | 103356634128 | 15 | NULL | |
io_write_thread | 83 | 1022318912208 | 1521669072 | 12317095296.0000 | 106783392144 | 11 | NULL | |
io_write_thread | 66 | 752353852800 | 1708642320 | 11399300616.0000 | 31798977936 | 12 | NULL | |
main | 146 | 101293521120 | 72864 | 406539804.0000 | 29378174496 | 1 | NULL | |
srv_purge_thread | 5 | 22699387920 | 303574128 | 4539877584.0000 | 8810930832 | 36 | NULL | |
clone_gtid_thread | 4 | 1307795280 | 8996064 | 326948688.0000 | 707802480 | 35 | NULL | |
srv_worker_thread | 2 | 1302413904 | 7393584 | 651206952.0000 | 1295020320 | 38 | NULL | |
io_read_thread | 20 | 840348432 | 15488880 | 42017184.0000 | 68977392 | 5 | NULL | |
srv_worker_thread | 2 | 24747888 | 8376720 | 12373944.0000 | 16371168 | 42 | NULL |
|