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 | 227 | 3191606523600 | 106857168 | 14059940400.0000 | 66504710976 | 18 | NULL | |
page_flush_coordinator_thread | 693 | 698474642976 | 3867600 | 535222248.0000 | 59690887344 | 13 | NULL | |
io_write_thread | 58 | 556545189552 | 1531683648 | 9595606680.0000 | 30761035536 | 9 | NULL | |
io_write_thread | 56 | 499533866832 | 1491491232 | 8920247424.0000 | 24347760624 | 10 | NULL | |
log_checkpointer_thread | 66 | 439797708768 | 7235184 | 6663601560.0000 | 18104593056 | 15 | NULL | |
io_write_thread | 16 | 154246802688 | 2331509664 | 9640425168.0000 | 20959976400 | 11 | NULL | |
log_writer_thread | 336 | 98280840768 | 523776 | 292502496.0000 | 34107095088 | 20 | NULL | |
main | 146 | 88076913936 | 74448 | 378145812.0000 | 29608567296 | 1 | NULL | |
srv_purge_thread | 2 | 9457161648 | 183506928 | 4728580824.0000 | 9273654720 | 36 | NULL | |
root@192.168.30.20 | 2 | 2244697488 | 692083920 | 1122348744.0000 | 1552613568 | 528 | 468 | |
clone_gtid_thread | 5 | 906315696 | 4011744 | 181262928.0000 | 354736800 | 35 | NULL | |
srv_worker_thread | 1 | 685471776 | 685471776 | 685471776.0000 | 685471776 | 40 | NULL | |
srv_worker_thread | 2 | 246568080 | 21805344 | 123284040.0000 | 224762736 | 42 | NULL | |
srv_worker_thread | 2 | 42695664 | 18464160 | 21347832.0000 | 24231504 | 38 | NULL |
|