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 | 375 | 5100619232016 | 44661936 | 13601651184.0000 | 48145233312 | 18 | NULL | |
page_flush_coordinator_thread | 1457 | 1901131198032 | 3694416 | 1632862440.0000 | 332849750640 | 13 | NULL | |
io_write_thread | 127 | 1459446571968 | 350429376 | 11491705104.0000 | 50962227888 | 9 | NULL | |
log_checkpointer_thread | 104 | 847076039568 | 7072032 | 8144961792.0000 | 117426295008 | 15 | NULL | |
io_write_thread | 25 | 322987980480 | 1532797728 | 12919519008.0000 | 28310853648 | 10 | NULL | |
io_write_thread | 17 | 175289807616 | 1685065008 | 10311164952.0000 | 18088600464 | 11 | NULL | |
log_writer_thread | 596 | 136822541856 | 511632 | 229567800.0000 | 11632459344 | 20 | NULL | |
main | 149 | 118246615872 | 106656 | 459094515.0000 | 35026381632 | 1 | NULL | |
io_write_thread | 7 | 63658167408 | 1412771712 | 9094023840.0000 | 15903354192 | 12 | NULL | |
srv_purge_thread | 2 | 6386800464 | 195337296 | 3193400232.0000 | 6191463168 | 36 | NULL | |
srv_worker_thread | 1 | 1831709616 | 1831709616 | 1831709616.0000 | 1831709616 | 40 | NULL | |
srv_worker_thread | 3 | 1707501840 | 20208672 | 569167104.0000 | 1666857456 | 38 | NULL | |
clone_gtid_thread | 5 | 901194096 | 11996160 | 180238608.0000 | 384078816 | 35 | NULL | |
srv_worker_thread | 2 | 35414016 | 12931776 | 17707008.0000 | 22482240 | 42 | NULL |
|