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 | 1007 | 14079644468736 | 86875536 | 13981771848.0000 | 342611491200 | 18 | NULL | |
page_flush_coordinator_thread | 3037 | 2918506386048 | 3504336 | 528958188.0000 | 42562812864 | 13 | NULL | |
io_write_thread | 226 | 2122635178224 | 1474059312 | 9392190984.0000 | 38569010832 | 9 | NULL | |
log_checkpointer_thread | 192 | 1269332379216 | 7183440 | 6611105952.0000 | 25730561472 | 15 | NULL | |
io_write_thread | 77 | 848481494256 | 1504181712 | 11019240144.0000 | 109809284640 | 10 | NULL | |
io_write_thread | 67 | 704853919968 | 1605280512 | 10520207544.0000 | 41381828400 | 11 | NULL | |
log_writer_thread | 1785 | 525199405632 | 474672 | 294229320.0000 | 14105958240 | 20 | NULL | |
io_write_thread | 40 | 408103974432 | 1734259824 | 10202599176.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 | 25 | 1260657024 | 9931152 | 50426112.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 |
|