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 | 551 | 6815043730176 | 59385744 | 12368500320.0000 | 100663943424 | 18 | NULL | |
page_flush_coordinator_thread | 2077 | 1319607353856 | 3405600 | 902818224.0000 | 59624750592 | 13 | NULL | |
io_write_thread | 95 | 951735730704 | 1521511728 | 10018270680.0000 | 30197194896 | 9 | NULL | |
log_checkpointer_thread | 80 | 545724123120 | 7936368 | 6821551440.0000 | 44361698304 | 15 | NULL | |
io_write_thread | 45 | 446516459664 | 1614813552 | 9922587840.0000 | 29018123904 | 10 | NULL | |
log_writer_thread | 849 | 423301610688 | 623040 | 498588288.0000 | 241912409376 | 20 | NULL | |
io_write_thread | 19 | 149137035168 | 1532253888 | 7849317432.0000 | 21321020160 | 11 | NULL | |
io_write_thread | 9 | 112855806624 | 1760215248 | 12539534040.0000 | 30261052800 | 12 | NULL | |
main | 150 | 94539133920 | 93456 | 390609549.0000 | 35470844640 | 1 | NULL | |
srv_purge_thread | 2 | 8631785712 | 219710832 | 4315892856.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 | 5 | 202342800 | 27362544 | 40468560.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 |
|