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 | 454 | 6226388135616 | 44859936 | 13714511184.0000 | 117397966224 | 18 | NULL | |
page_flush_coordinator_thread | 2102 | 1399321583088 | 3552384 | 467765892.0000 | 41891182080 | 13 | NULL | |
io_write_thread | 102 | 1047239351136 | 91188768 | 10267052400.0000 | 35876354976 | 9 | NULL | |
log_checkpointer_thread | 111 | 717297475488 | 6998112 | 6462139200.0000 | 32502950304 | 15 | NULL | |
io_write_thread | 50 | 500199930912 | 1506750960 | 10003998576.0000 | 26979137328 | 10 | NULL | |
log_writer_thread | 762 | 343754124384 | 473616 | 451120824.0000 | 75064201872 | 20 | NULL | |
io_write_thread | 36 | 341747087616 | 104392992 | 9492974568.0000 | 25004673408 | 11 | NULL | |
io_write_thread | 19 | 282686310720 | 5424387936 | 14878226880.0000 | 29530127088 | 12 | NULL | |
main | 148 | 101682387312 | 73392 | 404926599.0000 | 41022546576 | 1 | NULL | |
clone_gtid_thread | 5 | 1023913440 | 5463744 | 204782688.0000 | 371346624 | 35 | NULL | |
srv_purge_thread | 2 | 891875424 | 436471200 | 445937712.0000 | 455404224 | 36 | NULL | |
io_read_thread | 5 | 149308896 | 21446304 | 29861568.0000 | 37558752 | 5 | NULL | |
srv_worker_thread | 2 | 80684736 | 25575792 | 40342368.0000 | 55108944 | 40 | NULL | |
srv_worker_thread | 3 | 56790624 | 13663584 | 18930120.0000 | 23109504 | 42 | NULL |
|