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 | 156 | 2050378705056 | 94211040 | 13143453048.0000 | 100663943424 | 18 | NULL | |
log_writer_thread | 240 | 296000059872 | 682704 | 1233333552.0000 | 241912409376 | 20 | NULL | |
io_write_thread | 26 | 295173046080 | 1557244656 | 11352809424.0000 | 28892680608 | 9 | NULL | |
page_flush_coordinator_thread | 633 | 251384490720 | 4149552 | 236931816.0000 | 50083774224 | 13 | NULL | |
log_checkpointer_thread | 18 | 110933174352 | 11850960 | 6162954072.0000 | 20022668688 | 15 | NULL | |
main | 150 | 94539133920 | 93456 | 390609549.0000 | 35470844640 | 1 | NULL | |
io_write_thread | 7 | 61463411856 | 1582600272 | 8780487408.0000 | 15734152896 | 11 | NULL | |
io_write_thread | 4 | 40169969136 | 2008698384 | 10042492152.0000 | 13254618432 | 10 | 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 | |
srv_worker_thread | 2 | 72773184 | 16334736 | 36386592.0000 | 56438448 | 38 | NULL | |
srv_worker_thread | 2 | 39202416 | 15616128 | 19601208.0000 | 23586288 | 42 | NULL |
|