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 | 321 | 5727926596656 | 85855440 | 17844007896.0000 | 595801238736 | 18 | NULL | |
page_flush_coordinator_thread | 1040 | 757370895072 | 3595152 | 392649972.0000 | 48315328512 | 13 | NULL | |
io_write_thread | 51 | 524386396512 | 1692290688 | 10282086144.0000 | 23445378000 | 9 | NULL | |
io_write_thread | 22 | 378806207472 | 2834347824 | 17218463856.0000 | 63049728720 | 12 | NULL | |
io_write_thread | 31 | 339319656720 | 1651362240 | 10945795344.0000 | 22982480400 | 10 | NULL | |
log_checkpointer_thread | 44 | 332474571264 | 9029856 | 7556240208.0000 | 38125212048 | 15 | NULL | |
log_writer_thread | 735 | 216888506736 | 466224 | 295086264.0000 | 93364505520 | 20 | NULL | |
io_write_thread | 13 | 184370464608 | 2915305536 | 14182343208.0000 | 35091392688 | 11 | NULL | |
srv_purge_thread | 2 | 114734679312 | 1852489584 | 57367339656.0000 | 112882189728 | 36 | NULL | |
main | 148 | 89492362080 | 80256 | 376686948.0000 | 32172832560 | 1 | NULL | |
clone_gtid_thread | 5 | 852342480 | 4401408 | 170468496.0000 | 297160512 | 35 | NULL | |
io_read_thread | 3 | 182982624 | 35329008 | 60994032.0000 | 105778992 | 5 | NULL | |
srv_worker_thread | 3 | 144482976 | 7664976 | 48160992.0000 | 126642912 | 42 | NULL | |
srv_worker_thread | 2 | 24178176 | 6534528 | 12089088.0000 | 17643648 | 38 | NULL |
|