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 | 182 | 2495636871024 | 219079872 | 13712290416.0000 | 52403278224 | 18 | NULL | |
io_write_thread | 108 | 989894933280 | 1535760336 | 9165693768.0000 | 23491961856 | 9 | NULL | |
page_flush_coordinator_thread | 829 | 821530985088 | 3793152 | 558661884.0000 | 32265245232 | 13 | NULL | |
log_checkpointer_thread | 74 | 484650726912 | 11085360 | 6549333912.0000 | 21718232976 | 15 | NULL | |
io_write_thread | 33 | 310643569632 | 1602784128 | 9413441400.0000 | 23376626064 | 10 | NULL | |
main | 149 | 112508239536 | 74976 | 432416358.0000 | 32835747120 | 1 | NULL | |
io_write_thread | 9 | 73378516992 | 1632052224 | 8153168496.0000 | 22616914848 | 11 | NULL | |
io_write_thread | 6 | 58048834272 | 1585560240 | 9674805624.0000 | 21262063152 | 12 | NULL | |
log_writer_thread | 275 | 17859225120 | 539616 | 64942416.0000 | 3662654688 | 20 | NULL | |
clone_gtid_thread | 5 | 1351894896 | 8109552 | 270378768.0000 | 471094272 | 35 | NULL | |
srv_purge_thread | 2 | 1303789872 | 376543728 | 651894936.0000 | 927246144 | 36 | NULL | |
srv_worker_thread | 2 | 318059280 | 8355072 | 159029640.0000 | 309704208 | 42 | NULL | |
root@192.168.30.20 | 1 | 312828912 | 312828912 | 312828912.0000 | 312828912 | 4077 | 4005 | |
srv_worker_thread | 2 | 251383968 | 18681168 | 125691984.0000 | 232702800 | 38 | NULL |
|