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 | 71 | 1042557029712 | 1476852960 | 14683901760.0000 | 84598364400 | 18 | NULL | |
page_flush_coordinator_thread | 280 | 225552712176 | 4076688 | 805545312.0000 | 37867883856 | 13 | NULL | |
io_write_thread | 21 | 206282601888 | 1989253200 | 9822980904.0000 | 16475907360 | 10 | NULL | |
log_checkpointer_thread | 22 | 165175295472 | 15020016 | 7507967808.0000 | 22245064512 | 15 | NULL | |
io_write_thread | 8 | 124174923312 | 3165850512 | 15521865216.0000 | 27252743760 | 9 | NULL | |
io_write_thread | 12 | 115971705168 | 1688390880 | 9664308720.0000 | 18682546080 | 11 | NULL | |
main | 148 | 99372235248 | 74448 | 395167377.0000 | 35924106768 | 1 | NULL | |
log_writer_thread | 109 | 9348176112 | 764016 | 85763040.0000 | 1943885328 | 20 | NULL | |
root@192.168.30.20 | 2 | 2070857712 | 225679344 | 1035428856.0000 | 1845178368 | 345 | 281 | |
clone_gtid_thread | 5 | 1147076832 | 5679696 | 229415208.0000 | 400493280 | 35 | NULL | |
srv_worker_thread | 2 | 530208624 | 254907312 | 265104312.0000 | 275301312 | 38 | NULL | |
srv_purge_thread | 1 | 247410240 | 247410240 | 247410240.0000 | 247410240 | 36 | NULL | |
io_read_thread | 4 | 202453152 | 6229344 | 50613288.0000 | 139026096 | 5 | NULL | |
srv_worker_thread | 2 | 123533520 | 18776208 | 61766760.0000 | 104757312 | 42 | NULL |
|