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 | 283 | 3924712548240 | 106857168 | 13868242080.0000 | 66504710976 | 18 | NULL | |
page_flush_coordinator_thread | 909 | 901723533216 | 3867600 | 532078008.0000 | 59690887344 | 13 | NULL | |
io_write_thread | 69 | 670784448576 | 1531683648 | 9721513560.0000 | 30761035536 | 9 | NULL | |
io_write_thread | 74 | 664463901552 | 1491491232 | 8979241656.0000 | 24347760624 | 10 | NULL | |
log_checkpointer_thread | 86 | 583018631712 | 7235184 | 6779286360.0000 | 19142652144 | 15 | NULL | |
io_write_thread | 20 | 222484103424 | 2331509664 | 11124204960.0000 | 23975384928 | 11 | NULL | |
log_writer_thread | 419 | 115604753088 | 523776 | 275906136.0000 | 34107095088 | 20 | NULL | |
main | 146 | 88076913936 | 74448 | 378145812.0000 | 29608567296 | 1 | NULL | |
srv_purge_thread | 2 | 9457161648 | 183506928 | 4728580824.0000 | 9273654720 | 36 | NULL | |
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 |
|