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 | 86 | 2245370156832 | 60949680 | 26108955312.0000 | 1069671907920 | 18 | NULL | |
log_writer_thread | 130 | 804991415184 | 695904 | 6192241440.0000 | 779585431152 | 20 | NULL | |
io_write_thread | 20 | 308355664320 | 2185298016 | 15417783216.0000 | 43837988832 | 9 | NULL | |
page_flush_coordinator_thread | 288 | 235750998912 | 4603632 | 436022004.0000 | 56034862752 | 13 | NULL | |
main | 146 | 179798419152 | 233376 | 858238590.0000 | 51349673232 | 1 | NULL | |
log_checkpointer_thread | 12 | 107218214400 | 11562672 | 8934851112.0000 | 31923112848 | 15 | NULL | |
io_write_thread | 4 | 46692125568 | 1664106048 | 11673031392.0000 | 17423317824 | 12 | NULL | |
io_write_thread | 4 | 35468910048 | 7800213696 | 8867227512.0000 | 10757860080 | 10 | NULL | |
clone_gtid_thread | 5 | 1670069280 | 6183936 | 334013856.0000 | 873826272 | 35 | NULL | |
srv_worker_thread | 3 | 1425557232 | 12186240 | 475185744.0000 | 1125949440 | 42 | NULL | |
srv_worker_thread | 1 | 558844176 | 558844176 | 558844176.0000 | 558844176 | 40 | NULL | |
root@192.168.30.20 | 1 | 417906192 | 417906192 | 417906192.0000 | 417906192 | 677 | 625 | |
srv_purge_thread | 1 | 328837872 | 328837872 | 328837872.0000 | 328837872 | 36 | NULL | |
srv_worker_thread | 2 | 21414096 | 7064112 | 10707048.0000 | 14349984 | 38 | NULL |
|