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 | 180 | 2813640731616 | 137984880 | 15631337304.0000 | 83043635664 | 18 | NULL | |
page_flush_coordinator_thread | 715 | 1294669388496 | 4205520 | 3692985648.0000 | 95678832480 | 13 | NULL | |
io_write_thread | 108 | 1223975257824 | 1583378016 | 11333104200.0000 | 39080688240 | 9 | NULL | |
log_checkpointer_thread | 80 | 634819103952 | 7653360 | 7935238608.0000 | 28034253456 | 15 | NULL | |
io_write_thread | 32 | 397057979472 | 1618825824 | 12408061776.0000 | 30554893776 | 10 | NULL | |
io_write_thread | 17 | 178877336880 | 2330829600 | 10522196256.0000 | 15880747872 | 11 | NULL | |
main | 147 | 115281861552 | 102960 | 446411889.0000 | 26807888976 | 1 | NULL | |
log_writer_thread | 261 | 92431165728 | 505296 | 354142272.0000 | 22720053840 | 20 | NULL | |
srv_purge_thread | 2 | 4099027680 | 258987168 | 2049513840.0000 | 3840040512 | 36 | NULL | |
clone_gtid_thread | 5 | 956994720 | 5291616 | 191398944.0000 | 335403024 | 35 | NULL | |
io_read_thread | 5 | 164987856 | 26524608 | 32997360.0000 | 52289952 | 5 | NULL | |
srv_worker_thread | 3 | 64277136 | 9002928 | 21425712.0000 | 36998016 | 38 | NULL | |
srv_worker_thread | 2 | 26103792 | 13004112 | 13051896.0000 | 13099680 | 42 | NULL |
|