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 | 43 | 620969019264 | 1539468480 | 14441139768.0000 | 92903915808 | 18 | NULL | |
io_write_thread | 23 | 264814857120 | 1728259104 | 11513689440.0000 | 18922258080 | 9 | NULL | |
page_flush_coordinator_thread | 221 | 191140057152 | 4169088 | 445968732.0000 | 33737755920 | 13 | NULL | |
main | 148 | 126295940496 | 80784 | 551259522.0000 | 39646162512 | 1 | NULL | |
log_checkpointer_thread | 16 | 121421213232 | 13911216 | 7588825728.0000 | 21745874832 | 15 | NULL | |
io_write_thread | 8 | 78264565104 | 2646161232 | 9783070440.0000 | 18355372464 | 10 | NULL | |
log_writer_thread | 68 | 72459625392 | 704880 | 1065582672.0000 | 63912217776 | 20 | NULL | |
root@192.168.30.20 | 1 | 2034800064 | 2034800064 | 2034800064.0000 | 2034800064 | 222 | 174 | |
srv_purge_thread | 1 | 1062978048 | 1062978048 | 1062978048.0000 | 1062978048 | 36 | NULL | |
clone_gtid_thread | 5 | 916420560 | 7737840 | 183284112.0000 | 310655136 | 35 | NULL | |
srv_worker_thread | 3 | 157242096 | 5062992 | 52414032.0000 | 143277024 | 42 | NULL | |
srv_worker_thread | 2 | 48978864 | 20823264 | 24489432.0000 | 28155600 | 38 | NULL |
|