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 | 1069 | 15829608257232 | 80079120 | 14807865336.0000 | 681651236112 | 18 | NULL | |
page_flush_coordinator_thread | 2562 | 2930643740112 | 3414576 | 602976660.0000 | 50779473888 | 13 | NULL | |
io_write_thread | 162 | 1722246685104 | 184395552 | 10631152224.0000 | 30027861072 | 9 | NULL | |
log_checkpointer_thread | 140 | 970739777568 | 8156016 | 6933855456.0000 | 31897352784 | 15 | NULL | |
io_write_thread | 91 | 934660799952 | 1552832688 | 10270997616.0000 | 42626753664 | 10 | NULL | |
log_writer_thread | 1946 | 582463273920 | 472560 | 299312904.0000 | 63722210112 | 20 | NULL | |
io_write_thread | 48 | 561698756256 | 2423418096 | 11702057400.0000 | 31362289200 | 11 | NULL | |
io_write_thread | 17 | 164425703376 | 72949008 | 9672100152.0000 | 27966559104 | 12 | NULL | |
main | 145 | 118076150016 | 73920 | 476585967.0000 | 34575279552 | 1 | NULL | |
srv_purge_thread | 5 | 7234586832 | 197621952 | 1446917208.0000 | 4317916944 | 36 | NULL | |
io_read_thread | 18 | 1094687616 | 27050496 | 60815832.0000 | 418686048 | 5 | NULL | |
srv_worker_thread | 1 | 885045744 | 885045744 | 885045744.0000 | 885045744 | 40 | NULL | |
clone_gtid_thread | 4 | 601031376 | 5065104 | 150257712.0000 | 294811440 | 35 | NULL | |
srv_worker_thread | 2 | 62034720 | 10152384 | 31017360.0000 | 51882336 | 38 | NULL | |
srv_worker_thread | 2 | 32907072 | 6455856 | 16453536.0000 | 26451216 | 42 | NULL |
|