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 | 380 | 5547824999376 | 38501760 | 14599539240.0000 | 237351339456 | 18 | NULL | |
page_flush_coordinator_thread | 1320 | 1831617134688 | 3344352 | 729234000.0000 | 45097449936 | 13 | NULL | |
io_write_thread | 102 | 1052604335376 | 1670493264 | 10319650176.0000 | 26666639472 | 9 | NULL | |
log_checkpointer_thread | 136 | 998214085440 | 7804896 | 7339809312.0000 | 26211284880 | 15 | NULL | |
io_write_thread | 84 | 932755271184 | 1528561056 | 11104229400.0000 | 30437416416 | 10 | NULL | |
io_write_thread | 58 | 674347034592 | 343191024 | 11626672992.0000 | 34148847744 | 11 | NULL | |
log_writer_thread | 596 | 266391530592 | 504768 | 446965464.0000 | 147070553520 | 20 | NULL | |
main | 151 | 93132455328 | 71280 | 367023327.0000 | 21197113344 | 1 | NULL | |
io_write_thread | 8 | 83717695776 | 2570744352 | 10464711840.0000 | 20496813744 | 12 | NULL | |
srv_purge_thread | 2 | 1411109040 | 368246208 | 705554520.0000 | 1042862832 | 36 | NULL | |
clone_gtid_thread | 5 | 954756528 | 6795888 | 190951200.0000 | 335975904 | 35 | NULL | |
srv_worker_thread | 1 | 938130864 | 938130864 | 938130864.0000 | 938130864 | 40 | NULL | |
io_read_thread | 7 | 237761568 | 26262192 | 33965712.0000 | 56055648 | 5 | NULL | |
srv_worker_thread | 3 | 201762528 | 10660320 | 67254000.0000 | 174358800 | 42 | NULL | |
srv_worker_thread | 2 | 200816352 | 9937488 | 100408176.0000 | 190878864 | 38 | NULL |
|