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 | 271 | 3844023350112 | 154508112 | 14184588000.0000 | 48145233312 | 18 | NULL | |
io_write_thread | 103 | 1256762682912 | 350429376 | 12201579192.0000 | 50962227888 | 9 | NULL | |
page_flush_coordinator_thread | 1188 | 1197110291520 | 3694416 | 647820756.0000 | 56893695936 | 13 | NULL | |
log_checkpointer_thread | 84 | 706441896336 | 7072032 | 8410022544.0000 | 117426295008 | 15 | NULL | |
io_write_thread | 22 | 292051796256 | 2324866368 | 13275081600.0000 | 28310853648 | 10 | NULL | |
main | 149 | 118246615872 | 106656 | 459094515.0000 | 35026381632 | 1 | NULL | |
log_writer_thread | 440 | 95979102384 | 511632 | 218134224.0000 | 11632459344 | 20 | NULL | |
io_write_thread | 10 | 95892141312 | 1685065008 | 9589213920.0000 | 16771260000 | 11 | NULL | |
io_write_thread | 4 | 35078336304 | 4037035200 | 8769583944.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 | |
root@192.168.30.20 | 2 | 578180064 | 252592032 | 289090032.0000 | 325588032 | 3046 | 2734 | |
srv_worker_thread | 2 | 35414016 | 12931776 | 17707008.0000 | 22482240 | 42 | NULL |
|