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 | 1226 | 16636987177850 | 57910450 | 13570136165.0000 | 259958771440 | 18 | NULL | |
page_flush_coordinator_thread | 2564 | 2383557687150 | 3525560 | 488408117.5000 | 117902776040 | 13 | NULL | |
io_write_thread | 124 | 1255511795930 | 1422404990 | 10125095090.0000 | 28051297280 | 9 | NULL | |
io_write_thread | 75 | 944470961460 | 1576600010 | 12592946015.0000 | 37503431230 | 10 | NULL | |
log_checkpointer_thread | 77 | 629375940220 | 6568820 | 9903981210.0000 | 105965693100 | 15 | NULL | |
log_writer_thread | 2890 | 605761006350 | 460040 | 209605725.0000 | 14596667990 | 20 | NULL | |
io_write_thread | 40 | 454817834210 | 77095920 | 11370445630.0000 | 35880156240 | 11 | NULL | |
io_write_thread | 11 | 168784247850 | 1974899250 | 15344022315.0000 | 34674457650 | 12 | NULL | |
main | 149 | 109708079280 | 76850 | 436878900.6250 | 31869383360 | 1 | NULL | |
srv_purge_thread | 4 | 8353676620 | 186916690 | 2088419155.0000 | 4187584060 | 36 | NULL | |
srv_worker_thread | 2 | 1416487010 | 11035660 | 708243505.0000 | 1405451350 | 42 | NULL | |
clone_gtid_thread | 4 | 628396090 | 7653200 | 157098890.0000 | 319385950 | 35 | NULL | |
srv_worker_thread | 2 | 35244470 | 14302580 | 17622235.0000 | 20941890 | 38 | NULL | |
io_read_thread | 1 | 30073260 | 30073260 | 30073260.0000 | 30073260 | 5 | NULL |
|