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 | 290 | 4151884226688 | 122925792 | 14316841968.0000 | 107043385152 | 18 | NULL | |
page_flush_coordinator_thread | 1261 | 1570303821504 | 3682272 | 1096759092.0000 | 63907502208 | 13 | NULL | |
io_write_thread | 110 | 1179611787552 | 1572888240 | 10723743360.0000 | 37032959568 | 9 | NULL | |
log_checkpointer_thread | 128 | 946325170032 | 7537200 | 7393165296.0000 | 33636448560 | 15 | NULL | |
io_write_thread | 72 | 795186436704 | 1686360192 | 11044255992.0000 | 39284227488 | 10 | NULL | |
io_write_thread | 42 | 398933368944 | 1551517440 | 9498413496.0000 | 21318585024 | 11 | NULL | |
main | 150 | 117929498016 | 136224 | 458213844.0000 | 33164253408 | 1 | NULL | |
log_writer_thread | 441 | 106303688832 | 498432 | 241051272.0000 | 9337868496 | 20 | NULL | |
io_write_thread | 5 | 53052276816 | 2453660880 | 10610455152.0000 | 18898181808 | 12 | NULL | |
srv_purge_thread | 2 | 5112038976 | 892775664 | 2556019488.0000 | 4219263312 | 36 | NULL | |
clone_gtid_thread | 5 | 1537546560 | 6977520 | 307509312.0000 | 564069264 | 35 | NULL | |
io_read_thread | 7 | 275094336 | 30157776 | 39299040.0000 | 60397392 | 5 | NULL | |
srv_worker_thread | 3 | 237327024 | 7975968 | 79108920.0000 | 217803696 | 38 | NULL | |
srv_worker_thread | 1 | 213855312 | 213855312 | 213855312.0000 | 213855312 | 40 | NULL | |
srv_worker_thread | 2 | 27168768 | 10643424 | 13584384.0000 | 16525344 | 42 | NULL |
|