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 | 431 | 5984562093840 | 88397232 | 13885294632.0000 | 69729543312 | 18 | NULL | |
page_flush_coordinator_thread | 1518 | 2018899675056 | 3662208 | 716694396.0000 | 64223074608 | 13 | NULL | |
io_write_thread | 173 | 1768070799264 | 1538390832 | 10220062248.0000 | 30217517088 | 9 | NULL | |
log_checkpointer_thread | 160 | 1231131002640 | 10783344 | 7694568552.0000 | 31603305888 | 15 | NULL | |
io_write_thread | 61 | 657708757728 | 1600319424 | 10782110592.0000 | 29977400112 | 10 | NULL | |
io_write_thread | 30 | 324391354320 | 1909909584 | 10813045056.0000 | 31071138912 | 11 | NULL | |
io_write_thread | 31 | 312742719696 | 1673293776 | 10088474616.0000 | 45736813056 | 12 | NULL | |
log_writer_thread | 657 | 148280200464 | 486816 | 225692808.0000 | 13449450432 | 20 | NULL | |
main | 148 | 115209621648 | 96096 | 462150117.0000 | 41101196928 | 1 | NULL | |
srv_purge_thread | 2 | 4051154976 | 224365152 | 2025577488.0000 | 3826789824 | 36 | NULL | |
srv_worker_thread | 1 | 3082930752 | 3082930752 | 3082930752.0000 | 3082930752 | 40 | NULL | |
srv_worker_thread | 2 | 1716513744 | 7595808 | 858256872.0000 | 1708917936 | 42 | NULL | |
io_read_thread | 38 | 1440171216 | 21328032 | 37899048.0000 | 63843120 | 5 | NULL | |
clone_gtid_thread | 4 | 556580112 | 4220304 | 139144896.0000 | 281407104 | 35 | NULL | |
root@192.168.30.20 | 1 | 325259088 | 325259088 | 325259088.0000 | 325259088 | 3146 | 2694 | |
srv_worker_thread | 3 | 58522992 | 11802384 | 19507488.0000 | 26611728 | 38 | NULL |
|