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 | 822 | 10975137004128 | 54329616 | 13351747992.0000 | 134404247472 | 18 | NULL | |
page_flush_coordinator_thread | 2450 | 2214194679312 | 3347520 | 649083864.0000 | 184099439568 | 13 | NULL | |
io_write_thread | 155 | 1540889958432 | 135802656 | 9941225448.0000 | 34567727040 | 9 | NULL | |
log_checkpointer_thread | 136 | 910809894720 | 8093184 | 6697131408.0000 | 29639860272 | 15 | NULL | |
io_write_thread | 46 | 517498229424 | 1604674896 | 11249961360.0000 | 37041392784 | 11 | NULL | |
io_write_thread | 39 | 447132912864 | 1651710192 | 11464946328.0000 | 33686868864 | 12 | NULL | |
log_writer_thread | 1593 | 440715683760 | 475728 | 276657480.0000 | 53335736256 | 20 | NULL | |
io_write_thread | 44 | 428071129200 | 1606331232 | 9728889192.0000 | 31756161360 | 10 | NULL | |
main | 148 | 111516629136 | 147312 | 544346715.0000 | 33607266000 | 1 | NULL | |
srv_purge_thread | 3 | 9874582080 | 259617600 | 3291527184.0000 | 5585035104 | 36 | NULL | |
srv_worker_thread | 2 | 1803364992 | 7831824 | 901682496.0000 | 1795533168 | 40 | NULL | |
clone_gtid_thread | 4 | 714071424 | 6046656 | 178517856.0000 | 370881984 | 35 | NULL | |
srv_worker_thread | 2 | 28284960 | 7086288 | 14142480.0000 | 21198672 | 42 | NULL |
|