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 | 1673 | 23189595679536 | 42511392 | 13861085040.0000 | 681651236112 | 18 | NULL | |
page_flush_coordinator_thread | 3745 | 4023223360992 | 3414576 | 565092000.0000 | 106776941040 | 13 | NULL | |
io_write_thread | 229 | 2299381082592 | 184395552 | 10040965176.0000 | 30027861072 | 9 | NULL | |
log_checkpointer_thread | 196 | 1388238370992 | 8156016 | 7082848608.0000 | 45471978288 | 15 | NULL | |
io_write_thread | 119 | 1198339165584 | 1552832688 | 10070076984.0000 | 42626753664 | 10 | NULL | |
log_writer_thread | 3253 | 907070364288 | 472032 | 278841024.0000 | 93403101264 | 20 | NULL | |
io_write_thread | 77 | 870062132016 | 1785473184 | 11299508088.0000 | 35668302384 | 11 | NULL | |
io_write_thread | 38 | 347801879040 | 72949008 | 9152680944.0000 | 27966559104 | 12 | NULL | |
main | 145 | 118076150016 | 73920 | 476585967.0000 | 34575279552 | 1 | NULL | |
srv_purge_thread | 5 | 7234586832 | 197621952 | 1446917208.0000 | 4317916944 | 36 | NULL | |
io_read_thread | 18 | 1094687616 | 27050496 | 60815832.0000 | 418686048 | 5 | NULL | |
srv_worker_thread | 1 | 885045744 | 885045744 | 885045744.0000 | 885045744 | 40 | NULL | |
clone_gtid_thread | 4 | 601031376 | 5065104 | 150257712.0000 | 294811440 | 35 | NULL | |
srv_worker_thread | 2 | 62034720 | 10152384 | 31017360.0000 | 51882336 | 38 | NULL | |
srv_worker_thread | 2 | 32907072 | 6455856 | 16453536.0000 | 26451216 | 42 | NULL |
|