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 | 270 | 5007224537568 | 85855440 | 18545275848.0000 | 595801238736 | 18 | NULL | |
page_flush_coordinator_thread | 936 | 623834502720 | 3595152 | 355465176.0000 | 48315328512 | 13 | NULL | |
io_write_thread | 40 | 416045500992 | 1692290688 | 10401137472.0000 | 23445378000 | 9 | NULL | |
io_write_thread | 18 | 337897472352 | 2834347824 | 18772081680.0000 | 63049728720 | 12 | NULL | |
io_write_thread | 24 | 261258999936 | 1781198496 | 10885791576.0000 | 22982480400 | 10 | NULL | |
log_checkpointer_thread | 30 | 208755656736 | 9029856 | 6958521768.0000 | 25729646448 | 15 | NULL | |
log_writer_thread | 658 | 203232455712 | 466224 | 308863896.0000 | 93364505520 | 20 | NULL | |
io_write_thread | 10 | 162085650144 | 8108003904 | 16208564856.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 | |
srv_worker_thread | 3 | 144482976 | 7664976 | 48160992.0000 | 126642912 | 42 | NULL | |
io_read_thread | 2 | 77203632 | 35329008 | 38601816.0000 | 41874624 | 5 | NULL | |
srv_worker_thread | 2 | 24178176 | 6534528 | 12089088.0000 | 17643648 | 38 | NULL |
|