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 | 1582 | 21427283864976 | 44094336 | 13544427072.0000 | 427685881920 | 18 | NULL | |
page_flush_coordinator_thread | 5678 | 4436367657744 | 3410880 | 1855862976.0000 | 106183103136 | 13 | NULL | |
io_write_thread | 269 | 2576414597856 | 1492320192 | 9577749192.0000 | 37200114336 | 9 | NULL | |
log_checkpointer_thread | 268 | 1944907925136 | 7842912 | 7257118968.0000 | 40536591744 | 15 | NULL | |
io_write_thread | 164 | 1574379096048 | 1615311984 | 9599872392.0000 | 35710594656 | 10 | NULL | |
io_write_thread | 122 | 1105722068880 | 1593084768 | 9063295560.0000 | 27706259856 | 11 | NULL | |
log_writer_thread | 2489 | 644454903840 | 483648 | 258921168.0000 | 99429703296 | 20 | NULL | |
io_write_thread | 72 | 627202237200 | 1543053072 | 8711142000.0000 | 21278156064 | 12 | NULL | |
main | 146 | 89458187808 | 73392 | 400143084.0000 | 28622593296 | 1 | NULL | |
srv_purge_thread | 4 | 4374304704 | 270195552 | 1093576176.0000 | 3505833408 | 36 | NULL | |
clone_gtid_thread | 5 | 1135868976 | 8994480 | 227173584.0000 | 398050752 | 35 | NULL | |
srv_worker_thread | 2 | 1078174416 | 18213360 | 539087208.0000 | 1059961056 | 38 | NULL | |
io_read_thread | 13 | 836891616 | 18720240 | 64376136.0000 | 409815648 | 5 | NULL | |
srv_worker_thread | 2 | 370861920 | 12163008 | 185430960.0000 | 358698912 | 42 | NULL |
|