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 | 99 | 1298700577152 | 130501008 | 13118187456.0000 | 40220072640 | 18 | NULL | |
page_flush_coordinator_thread | 332 | 324628569408 | 4530768 | 531713028.0000 | 77519602512 | 13 | NULL | |
io_write_thread | 25 | 297964980720 | 1557442656 | 11918599176.0000 | 24432830400 | 9 | NULL | |
log_checkpointer_thread | 18 | 135146000352 | 14092848 | 7508110896.0000 | 18644270304 | 15 | NULL | |
main | 150 | 116007284448 | 194832 | 461535393.0000 | 34276862400 | 1 | NULL | |
io_write_thread | 8 | 92665261920 | 1927885344 | 11583157608.0000 | 21041626848 | 11 | NULL | |
io_write_thread | 4 | 35398361856 | 7676249328 | 8849590464.0000 | 10865573136 | 12 | NULL | |
log_writer_thread | 166 | 33316454160 | 490512 | 200701512.0000 | 9384264384 | 20 | NULL | |
clone_gtid_thread | 4 | 609064896 | 12458160 | 152266224.0000 | 337932144 | 35 | NULL | |
srv_purge_thread | 1 | 311143008 | 311143008 | 311143008.0000 | 311143008 | 36 | NULL | |
srv_worker_thread | 2 | 27729504 | 7794864 | 13864752.0000 | 19934640 | 38 | NULL | |
srv_worker_thread | 3 | 24336576 | 4626864 | 8112192.0000 | 11937024 | 42 | NULL |
|