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 | 701 | 8706518382672 | 59385744 | 12420140304.0000 | 100663943424 | 18 | NULL | |
page_flush_coordinator_thread | 2863 | 1813356745200 | 3363888 | 705751200.0000 | 59624750592 | 13 | NULL | |
io_write_thread | 148 | 1380906424128 | 1452481008 | 9330448776.0000 | 30197194896 | 9 | NULL | |
log_checkpointer_thread | 116 | 786084750000 | 7936368 | 6776592504.0000 | 44361698304 | 15 | NULL | |
io_write_thread | 67 | 617260136592 | 1596439680 | 9212837832.0000 | 29018123904 | 10 | NULL | |
log_writer_thread | 1080 | 513854583264 | 623040 | 475791096.0000 | 241912409376 | 20 | NULL | |
io_write_thread | 23 | 180972220704 | 1532253888 | 7868357376.0000 | 21321020160 | 11 | NULL | |
io_write_thread | 13 | 148294095312 | 1760215248 | 11407238040.0000 | 30261052800 | 12 | NULL | |
main | 150 | 94539133920 | 93456 | 390609549.0000 | 35470844640 | 1 | NULL | |
srv_purge_thread | 3 | 13436078832 | 219710832 | 4478692944.0000 | 8412074880 | 36 | NULL | |
srv_worker_thread | 2 | 1449044784 | 267593568 | 724522392.0000 | 1181451216 | 40 | NULL | |
clone_gtid_thread | 4 | 504009264 | 7854000 | 126002184.0000 | 250001664 | 35 | NULL | |
io_read_thread | 8 | 294757584 | 25838736 | 36844632.0000 | 62097024 | 5 | NULL | |
srv_worker_thread | 2 | 72773184 | 16334736 | 36386592.0000 | 56438448 | 38 | NULL | |
srv_worker_thread | 2 | 39202416 | 15616128 | 19601208.0000 | 23586288 | 42 | NULL |
|