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 | 457 | 6301272012816 | 60016176 | 13788341160.0000 | 99341989824 | 18 | NULL | |
page_flush_coordinator_thread | 1401 | 1429996297488 | 3914592 | 544280616.0000 | 45902672112 | 13 | NULL | |
io_write_thread | 110 | 1201026541968 | 1633890720 | 10918423032.0000 | 37640903520 | 9 | NULL | |
log_checkpointer_thread | 108 | 772806325632 | 9189840 | 7155613872.0000 | 37397468592 | 15 | NULL | |
io_write_thread | 50 | 481146637488 | 1718539152 | 9622932528.0000 | 31356405696 | 10 | NULL | |
io_write_thread | 30 | 285285324192 | 1671585696 | 9509510736.0000 | 26480487264 | 11 | NULL | |
io_write_thread | 23 | 267498523776 | 1997704368 | 11630370576.0000 | 26029281696 | 12 | NULL | |
log_writer_thread | 724 | 186740159232 | 488400 | 257928264.0000 | 8573883120 | 20 | NULL | |
main | 148 | 117582181200 | 75504 | 458109300.0000 | 40778321760 | 1 | NULL | |
srv_worker_thread | 3 | 4808731488 | 14747040 | 1602910320.0000 | 4773627408 | 38 | NULL | |
srv_worker_thread | 2 | 1908771744 | 7870368 | 954385872.0000 | 1900901376 | 42 | NULL | |
io_read_thread | 40 | 1333530000 | 15659952 | 33338184.0000 | 64685808 | 5 | NULL | |
clone_gtid_thread | 5 | 1176601008 | 7694016 | 235320096.0000 | 417385056 | 35 | NULL | |
srv_purge_thread | 2 | 685198272 | 323581104 | 342599136.0000 | 361617168 | 36 | NULL |
|