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 | 310 | 4290019150560 | 44661936 | 13838771232.0000 | 48145233312 | 18 | NULL | |
page_flush_coordinator_thread | 1293 | 1440884427840 | 3694416 | 1041949524.0000 | 175633792224 | 13 | NULL | |
io_write_thread | 119 | 1387447241664 | 350429376 | 11659220496.0000 | 50962227888 | 9 | NULL | |
log_checkpointer_thread | 94 | 777844619904 | 7072032 | 8274942720.0000 | 117426295008 | 15 | NULL | |
io_write_thread | 25 | 322987980480 | 1532797728 | 12919519008.0000 | 28310853648 | 10 | NULL | |
main | 149 | 118246615872 | 106656 | 459094515.0000 | 35026381632 | 1 | NULL | |
log_writer_thread | 497 | 111355524720 | 511632 | 224055216.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 | |
srv_worker_thread | 2 | 35414016 | 12931776 | 17707008.0000 | 22482240 | 42 | NULL |
|