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 | 51 | 765118053744 | 74824992 | 15002314536.0000 | 113166174000 | 18 | NULL | |
page_flush_coordinator_thread | 227 | 137779900368 | 4562976 | 321842928.0000 | 50271564288 | 13 | NULL | |
io_write_thread | 12 | 136529668704 | 1592545152 | 11377472304.0000 | 22759719840 | 9 | NULL | |
main | 150 | 127405644432 | 73920 | 517717563.0000 | 35691669552 | 1 | NULL | |
log_checkpointer_thread | 8 | 58972771440 | 26709408 | 7371596232.0000 | 17325158400 | 15 | NULL | |
io_write_thread | 4 | 58496375520 | 10716987072 | 14624093880.0000 | 21711474576 | 10 | NULL | |
log_writer_thread | 77 | 26151475680 | 498960 | 339629400.0000 | 7927874592 | 20 | NULL | |
root@192.168.30.20 | 1 | 6047556240 | 6047556240 | 6047556240.0000 | 6047556240 | 377 | 273 | |
clone_gtid_thread | 5 | 934061040 | 4448400 | 186812208.0000 | 324934368 | 35 | NULL | |
srv_purge_thread | 1 | 933075792 | 933075792 | 933075792.0000 | 933075792 | 36 | NULL | |
io_read_thread | 15 | 710931408 | 28218432 | 47395392.0000 | 77050512 | 5 | NULL | |
srv_worker_thread | 2 | 48585504 | 17587152 | 24292752.0000 | 30998352 | 42 | NULL | |
srv_worker_thread | 3 | 37100976 | 7570464 | 12366816.0000 | 17230752 | 38 | NULL |
|