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 | 281 | 3768547706100 | 68227960 | 13411201620.0000 | 87932891480 | 18 | NULL | |
io_write_thread | 51 | 694155126620 | 1729800220 | 13610884685.0000 | 36798269940 | 10 | NULL | |
page_flush_coordinator_thread | 1062 | 647581584910 | 3216570 | 335634557.5000 | 41088845190 | 13 | NULL | |
io_write_thread | 47 | 461099453570 | 1523846990 | 9810626480.0000 | 33333993310 | 9 | NULL | |
log_checkpointer_thread | 42 | 292922494560 | 10742570 | 6974344995.0000 | 24248271680 | 15 | NULL | |
main | 150 | 183965729500 | 110240 | 859360483.7500 | 43046257620 | 1 | NULL | |
io_write_thread | 13 | 166854223170 | 2413234690 | 12834940040.0000 | 29124591270 | 11 | NULL | |
io_write_thread | 8 | 142673312900 | 1709330030 | 17834163980.0000 | 48605299890 | 12 | NULL | |
log_writer_thread | 504 | 119458061040 | 580350 | 237019710.0000 | 22812814910 | 20 | NULL | |
srv_worker_thread | 2 | 4781826420 | 53067310 | 2390913210.0000 | 4728759110 | 42 | NULL | |
root@192.168.30.20 | 1 | 2206393710 | 2206393710 | 2206393710.0000 | 2206393710 | 1371 | 1123 | |
clone_gtid_thread | 5 | 1190869720 | 7142280 | 238173785.0000 | 408301400 | 35 | NULL | |
srv_purge_thread | 2 | 531389660 | 241636540 | 265694830.0000 | 289753120 | 36 | NULL | |
dict_stats_thread | 2 | 463093330 | 224406770 | 231546665.0000 | 238686560 | 26 | NULL | |
srv_worker_thread | 3 | 232451640 | 25686980 | 77483880.0000 | 154109160 | 38 | NULL |
|