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 | 1203 | 17180174132352 | 88497024 | 14281108776.0000 | 275769921504 | 18 | NULL | |
page_flush_coordinator_thread | 2822 | 3623776062720 | 3476352 | 673188384.0000 | 167811143280 | 13 | NULL | |
io_write_thread | 235 | 2374079271168 | 1524962208 | 10102464768.0000 | 40007717904 | 9 | NULL | |
log_checkpointer_thread | 184 | 1309147550304 | 6453744 | 7114932264.0000 | 26354238768 | 15 | NULL | |
io_write_thread | 88 | 957195413328 | 1648996272 | 10877220552.0000 | 33562205424 | 10 | NULL | |
log_writer_thread | 2174 | 763410115248 | 500016 | 351154584.0000 | 114250350192 | 20 | NULL | |
io_write_thread | 59 | 677170858848 | 1519677984 | 11477472072.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 |
|