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 | 491 | 7584667834656 | 43764336 | 15447388440.0000 | 711622532544 | 18 | NULL | |
page_flush_coordinator_thread | 1805 | 2560697760192 | 3672768 | 931964880.0000 | 39993684720 | 13 | NULL | |
io_write_thread | 227 | 2177514948048 | 1509488640 | 9592576752.0000 | 31512757056 | 9 | NULL | |
log_checkpointer_thread | 190 | 1415762277600 | 6595776 | 7451380200.0000 | 28226837760 | 15 | NULL | |
io_write_thread | 88 | 966518984640 | 333005904 | 10983170088.0000 | 30330524928 | 10 | NULL | |
io_write_thread | 23 | 195014077632 | 1650993168 | 8478872688.0000 | 19732871136 | 11 | NULL | |
io_write_thread | 13 | 142922965152 | 4324684320 | 10994074080.0000 | 31262766480 | 12 | NULL | |
log_writer_thread | 740 | 140521931616 | 475728 | 189894408.0000 | 9410846016 | 20 | NULL | |
main | 146 | 95257736112 | 77088 | 413436606.0000 | 27324990528 | 1 | NULL | |
srv_purge_thread | 2 | 5280199584 | 272621184 | 2640099792.0000 | 5007578400 | 36 | NULL | |
io_read_thread | 19 | 1092696528 | 16129872 | 57510288.0000 | 150781488 | 5 | NULL | |
clone_gtid_thread | 5 | 959724480 | 15259728 | 191944896.0000 | 330051216 | 35 | NULL | |
srv_worker_thread | 2 | 677844816 | 7264752 | 338922408.0000 | 670580064 | 42 | NULL | |
srv_worker_thread | 2 | 14429712 | 6957984 | 7214856.0000 | 7471728 | 40 | NULL |
|