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 | 10 | 124805076528 | 5585291184 | 12480507600.0000 | 15861624240 | 18 | NULL | |
main | 130 | 57541802208 | 78144 | 275901054.0000 | 19752220752 | 1 | NULL | |
page_flush_coordinator_thread | 152 | 43811217648 | 4811136 | 161441016.0000 | 25087661280 | 13 | NULL | |
io_write_thread | 5 | 38892717072 | 3940748592 | 7778543256.0000 | 11954538288 | 9 | NULL | |
log_checkpointer_thread | 4 | 21395128128 | 202156416 | 5348782032.0000 | 10509079680 | 15 | NULL | |
clone_gtid_thread | 5 | 7253913216 | 299044944 | 1450782432.0000 | 4147761024 | 35 | NULL | |
log_writer_thread | 18 | 899039328 | 572880 | 49946424.0000 | 410638800 | 20 | NULL | |
root@192.168.30.20 | 6 | 486060432 | 2682240 | 81009984.0000 | 225490320 | 197 | 157 | |
root@192.168.30.20 | 1 | 225153456 | 225153456 | 225153456.0000 | 225153456 | 199 | 159 |
|