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 | 1209 | 17294385927984 | 88497024 | 14304702984.0000 | 275769921504 | 18 | NULL | |
page_flush_coordinator_thread | 2929 | 4145427579744 | 3476352 | 2913127008.0000 | 478346846736 | 13 | NULL | |
io_write_thread | 239 | 2411130364368 | 1524962208 | 10088411520.0000 | 40007717904 | 9 | NULL | |
log_checkpointer_thread | 190 | 1345037987040 | 6453744 | 7079147064.0000 | 26354238768 | 15 | NULL | |
io_write_thread | 88 | 957195413328 | 1648996272 | 10877220552.0000 | 33562205424 | 10 | NULL | |
log_writer_thread | 2181 | 765407510208 | 500016 | 350943120.0000 | 114250350192 | 20 | NULL | |
io_write_thread | 62 | 699310421568 | 1519677984 | 11279200152.0000 | 36197694720 | 11 | NULL | |
io_write_thread | 24 | 305653885152 | 2482092096 | 12735578328.0000 | 31101299856 | 12 | NULL | |
main | 146 | 87307158576 | 73920 | 357669444.0000 | 24221401776 | 1 | NULL | |
srv_purge_thread | 5 | 6761195760 | 264832656 | 1352239152.0000 | 4152904272 | 36 | NULL | |
io_read_thread | 29 | 2193095520 | 22033440 | 75623856.0000 | 330742896 | 5 | NULL | |
srv_worker_thread | 1 | 1150209456 | 1150209456 | 1150209456.0000 | 1150209456 | 40 | NULL | |
clone_gtid_thread | 4 | 823819920 | 5570928 | 205954848.0000 | 422556816 | 35 | NULL | |
srv_worker_thread | 2 | 395971488 | 22872960 | 197985744.0000 | 373098528 | 42 | NULL | |
srv_worker_thread | 3 | 154429440 | 19353840 | 51476304.0000 | 114803040 | 38 | NULL |
|