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 | 639 | 7883150146080 | 59385744 | 12336698088.0000 | 100663943424 | 18 | NULL | |
page_flush_coordinator_thread | 2424 | 1510844485920 | 3405600 | 900021804.0000 | 59624750592 | 13 | NULL | |
io_write_thread | 115 | 1121153914848 | 1452481008 | 9749164392.0000 | 30197194896 | 9 | NULL | |
log_checkpointer_thread | 94 | 636255168384 | 7936368 | 6768671976.0000 | 44361698304 | 15 | NULL | |
io_write_thread | 55 | 533742918192 | 1614813552 | 9704416656.0000 | 29018123904 | 10 | NULL | |
log_writer_thread | 985 | 473917542384 | 623040 | 481134456.0000 | 241912409376 | 20 | NULL | |
io_write_thread | 22 | 168399997392 | 1532253888 | 7654545096.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 | 7 | 268918848 | 27362544 | 38416752.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 |
|