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 | 344 | 4997107465152 | 122350800 | 14526475128.0000 | 169157118768 | 18 | NULL | |
io_write_thread | 80 | 1654717555920 | 359864736 | 20683969416.0000 | 643749785184 | 9 | NULL | |
page_flush_coordinator_thread | 1243 | 1420580143488 | 3454704 | 1761739452.0000 | 139770565968 | 13 | NULL | |
log_checkpointer_thread | 82 | 582676092768 | 7261056 | 7105805784.0000 | 25346858592 | 15 | NULL | |
io_write_thread | 43 | 402133664592 | 1607060928 | 9351945504.0000 | 23647475280 | 10 | NULL | |
io_write_thread | 26 | 324185514048 | 1680502560 | 12468673536.0000 | 34321178496 | 11 | NULL | |
log_writer_thread | 526 | 139332198192 | 470976 | 264889944.0000 | 41808967728 | 20 | NULL | |
main | 149 | 95006835792 | 77088 | 374191290.0000 | 27625846512 | 1 | NULL | |
io_write_thread | 7 | 64273912560 | 5045924928 | 9181987320.0000 | 14235576432 | 12 | NULL | |
srv_purge_thread | 2 | 10901568480 | 2084151168 | 5450784240.0000 | 8817417312 | 36 | NULL | |
clone_gtid_thread | 5 | 838960848 | 4209216 | 167792064.0000 | 304057776 | 35 | NULL | |
io_read_thread | 10 | 289425312 | 7479648 | 28942320.0000 | 43822416 | 5 | NULL | |
srv_worker_thread | 2 | 118335888 | 18802608 | 59167944.0000 | 99533280 | 38 | NULL | |
srv_worker_thread | 2 | 35143680 | 7973856 | 17571840.0000 | 27169824 | 42 | NULL |
|