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 | 151 | 2046770421168 | 61355184 | 13554770856.0000 | 91923457824 | 18 | NULL | |
page_flush_coordinator_thread | 535 | 471058639392 | 3682272 | 461378940.0000 | 55367487648 | 13 | NULL | |
io_write_thread | 39 | 378944823840 | 1546751184 | 9716533728.0000 | 35684354640 | 9 | NULL | |
log_checkpointer_thread | 36 | 246573885888 | 11229504 | 6849274608.0000 | 25620164064 | 15 | NULL | |
io_write_thread | 20 | 208371301776 | 1569692784 | 10418564904.0000 | 22783089120 | 10 | NULL | |
io_write_thread | 8 | 96623796192 | 1562145024 | 12077974392.0000 | 27429257328 | 12 | NULL | |
main | 147 | 87146979216 | 82368 | 350560551.0000 | 26377545216 | 1 | NULL | |
log_writer_thread | 225 | 71055268944 | 492624 | 315801024.0000 | 35681413680 | 20 | NULL | |
io_write_thread | 4 | 47806950576 | 1852536576 | 11951737512.0000 | 15788852640 | 11 | NULL | |
clone_gtid_thread | 5 | 880767888 | 5367120 | 176153472.0000 | 301839648 | 35 | NULL | |
srv_purge_thread | 2 | 574020480 | 207395232 | 287010240.0000 | 366625248 | 36 | 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 |
|