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 | 3082 | 39632754221808 | 51003216 | 12859427064.0000 | 145649519664 | 18 | NULL | |
page_flush_coordinator_thread | 7265 | 6080873604432 | 3093552 | 448830888.0000 | 332113968912 | 13 | NULL | |
io_write_thread | 377 | 3310730926272 | 128426496 | 8781779424.0000 | 35684354640 | 9 | NULL | |
log_checkpointer_thread | 289 | 1892729310384 | 5111040 | 6549236232.0000 | 29658626448 | 15 | NULL | |
io_write_thread | 158 | 1565483009904 | 1463160336 | 9908120112.0000 | 31056971616 | 10 | NULL | |
log_writer_thread | 5504 | 1386520310736 | 465168 | 251911176.0000 | 54400760304 | 20 | NULL | |
io_write_thread | 157 | 1369962217008 | 1516718016 | 8725873992.0000 | 32022247488 | 11 | NULL | |
io_write_thread | 71 | 622829005392 | 1532772912 | 8772239256.0000 | 34284842592 | 12 | NULL | |
main | 147 | 87146979216 | 82368 | 350560551.0000 | 26377545216 | 1 | NULL | |
srv_purge_thread | 5 | 9584784528 | 207395232 | 1916956800.0000 | 4498452288 | 36 | NULL | |
clone_gtid_thread | 5 | 880767888 | 5367120 | 176153472.0000 | 301839648 | 35 | NULL | |
srv_worker_thread | 3 | 104073024 | 4961088 | 34690920.0000 | 91311264 | 38 | NULL | |
srv_worker_thread | 2 | 40649664 | 14979888 | 20324832.0000 | 25669776 | 42 | NULL | |
io_read_thread | 1 | 25207248 | 25207248 | 25207248.0000 | 25207248 | 5 | NULL |
|