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 | 55 | 789430313760 | 5651055696 | 14353278192.0000 | 30147636816 | 18 | NULL | |
io_write_thread | 16 | 225940462704 | 2401550976 | 14121278688.0000 | 25426728624 | 9 | NULL | |
page_flush_coordinator_thread | 248 | 217254225936 | 10117008 | 876024864.0000 | 40664042496 | 13 | NULL | |
log_checkpointer_thread | 20 | 146675405712 | 20172240 | 7333770048.0000 | 18451803216 | 15 | NULL | |
io_write_thread | 15 | 138194872992 | 2452548912 | 9212991480.0000 | 15219903072 | 10 | NULL | |
main | 151 | 108736264032 | 74448 | 538498521.0000 | 26331450288 | 1 | NULL | |
io_write_thread | 4 | 41840868960 | 5234779440 | 10460217240.0000 | 13691218992 | 11 | NULL | |
log_writer_thread | 84 | 8913155328 | 637296 | 106108992.0000 | 4172473536 | 20 | NULL | |
clone_gtid_thread | 5 | 1074681168 | 7096320 | 214936128.0000 | 357005088 | 35 | NULL | |
root@192.168.30.20 | 1 | 357043104 | 357043104 | 357043104.0000 | 357043104 | 181 | 141 | |
srv_purge_thread | 1 | 277311936 | 277311936 | 277311936.0000 | 277311936 | 36 | NULL | |
srv_worker_thread | 1 | 53310048 | 53310048 | 53310048.0000 | 53310048 | 42 | NULL | |
srv_worker_thread | 1 | 12826704 | 12826704 | 12826704.0000 | 12826704 | 38 | NULL |
|