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 | 790 | 11198248841472 | 86875536 | 14174998464.0000 | 342611491200 | 18 | NULL | |
page_flush_coordinator_thread | 2140 | 2182625186016 | 3562944 | 573594384.0000 | 42562812864 | 13 | NULL | |
io_write_thread | 169 | 1624427132064 | 1474059312 | 9611994744.0000 | 38569010832 | 9 | NULL | |
log_checkpointer_thread | 130 | 881427156720 | 7183440 | 6780208776.0000 | 25730561472 | 15 | NULL | |
io_write_thread | 55 | 665472400560 | 1504181712 | 12099498048.0000 | 109809284640 | 10 | NULL | |
log_writer_thread | 1385 | 441468004560 | 474672 | 318749376.0000 | 14105958240 | 20 | NULL | |
io_write_thread | 39 | 426718045776 | 1605280512 | 10941488184.0000 | 41381828400 | 11 | NULL | |
io_write_thread | 23 | 246845338080 | 1734259824 | 10732405992.0000 | 30035487504 | 12 | NULL | |
main | 148 | 80357215488 | 77088 | 335278152.0000 | 25226289792 | 1 | NULL | |
srv_purge_thread | 3 | 4543824384 | 431073456 | 1514608128.0000 | 2143433952 | 36 | NULL | |
srv_worker_thread | 4 | 3910110864 | 6353952 | 977527584.0000 | 3652971696 | 38 | NULL | |
io_read_thread | 23 | 1170842112 | 9931152 | 50906064.0000 | 250888176 | 5 | NULL | |
clone_gtid_thread | 4 | 497868096 | 4430448 | 124467024.0000 | 257988192 | 35 | NULL | |
srv_worker_thread | 2 | 31146720 | 8907360 | 15573360.0000 | 22239360 | 42 | NULL |
|