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 | 218 | 3214481619360 | 81797232 | 14745328488.0000 | 209992142448 | 18 | NULL | |
page_flush_coordinator_thread | 1338 | 1118186192112 | 3281520 | 737764632.0000 | 159932383248 | 13 | NULL | |
io_write_thread | 70 | 762780833232 | 1504002192 | 10896869016.0000 | 31488485424 | 9 | NULL | |
log_checkpointer_thread | 82 | 575995622400 | 10913232 | 7024336704.0000 | 23475215808 | 15 | NULL | |
io_write_thread | 34 | 337271150304 | 1551698016 | 9919739544.0000 | 24612277536 | 10 | NULL | |
io_write_thread | 17 | 231569692464 | 2533850880 | 13621746600.0000 | 40228012176 | 12 | NULL | |
io_write_thread | 14 | 139321450752 | 1643448048 | 9951532008.0000 | 17400573696 | 11 | NULL | |
main | 147 | 120607988688 | 93984 | 479819835.0000 | 47185489824 | 1 | NULL | |
log_writer_thread | 321 | 74997905136 | 468864 | 233638152.0000 | 17325535392 | 20 | NULL | |
srv_worker_thread | 2 | 1380413760 | 7886208 | 690206880.0000 | 1372527552 | 42 | NULL | |
clone_gtid_thread | 4 | 582271008 | 5690784 | 145567752.0000 | 301445760 | 35 | NULL | |
srv_purge_thread | 2 | 473550528 | 208963920 | 236775264.0000 | 264586608 | 36 | NULL | |
srv_worker_thread | 2 | 385567776 | 176074272 | 192783888.0000 | 209493504 | 40 | NULL | |
io_read_thread | 7 | 211451856 | 22821216 | 30207408.0000 | 39274224 | 5 | NULL | |
srv_worker_thread | 2 | 18150000 | 8972832 | 9075000.0000 | 9177168 | 38 | NULL |
|