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 | 1272 | 17230850524250 | 57910450 | 13546266025.0000 | 259958771440 | 18 | NULL | |
page_flush_coordinator_thread | 2686 | 2669473747070 | 3525560 | 520865317.5000 | 117902776040 | 13 | NULL | |
io_write_thread | 158 | 1502189545940 | 1422404990 | 9507528755.0000 | 28051297280 | 9 | NULL | |
io_write_thread | 91 | 1067586779870 | 1576600010 | 11731722780.0000 | 37503431230 | 10 | NULL | |
log_checkpointer_thread | 109 | 869500300120 | 6568820 | 9811583262.5000 | 105965693100 | 15 | NULL | |
log_writer_thread | 2954 | 606643756330 | 460040 | 205363340.0000 | 14596667990 | 20 | NULL | |
io_write_thread | 48 | 498546915210 | 77095920 | 10386393835.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 |
|