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 | 178 | 2834036425440 | 1436318928 | 15921552768.0000 | 145411461888 | 18 | NULL | |
page_flush_coordinator_thread | 724 | 911074194096 | 4234032 | 675959592.0000 | 43437949632 | 13 | NULL | |
io_write_thread | 55 | 673791170448 | 2335033536 | 12250748400.0000 | 32858769504 | 9 | NULL | |
io_write_thread | 40 | 596457915504 | 1652374944 | 14911447848.0000 | 75130649088 | 10 | NULL | |
log_checkpointer_thread | 56 | 458806316496 | 12063744 | 8192969928.0000 | 32569494672 | 15 | NULL | |
main | 149 | 120061411536 | 74448 | 473783640.0000 | 33693560208 | 1 | NULL | |
io_write_thread | 9 | 118991426928 | 3072445200 | 13221269424.0000 | 22990019712 | 11 | NULL | |
log_writer_thread | 270 | 79701420480 | 523248 | 295190280.0000 | 36612836304 | 20 | NULL | |
io_write_thread | 4 | 56229496752 | 4297266864 | 14057374056.0000 | 20157399504 | 12 | NULL | |
srv_purge_thread | 2 | 5263189536 | 256218336 | 2631594768.0000 | 5006971200 | 36 | NULL | |
clone_gtid_thread | 4 | 723787152 | 8123280 | 180946656.0000 | 382192272 | 35 | NULL | |
root@192.168.30.20 | 1 | 385888272 | 385888272 | 385888272.0000 | 385888272 | 4059 | 3839 | |
io_read_thread | 10 | 355478640 | 12485616 | 35547864.0000 | 102813744 | 5 | NULL | |
srv_worker_thread | 2 | 39879840 | 7947984 | 19939920.0000 | 31931856 | 38 | NULL | |
srv_worker_thread | 2 | 14253888 | 7085232 | 7126944.0000 | 7168656 | 42 | NULL |
|