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 | 233 | 3487258027440 | 57443232 | 14966772480.0000 | 140943293568 | 18 | NULL | |
page_flush_coordinator_thread | 969 | 1344471243456 | 4381872 | 1953174828.0000 | 317259742800 | 13 | NULL | |
io_write_thread | 66 | 835230161040 | 1660194624 | 12655002360.0000 | 29481894288 | 9 | NULL | |
log_checkpointer_thread | 82 | 578882939712 | 12047376 | 7059547968.0000 | 24980692704 | 15 | NULL | |
io_write_thread | 29 | 375948663024 | 1537098816 | 12963746928.0000 | 32199562032 | 10 | NULL | |
io_write_thread | 15 | 155215477296 | 1648618224 | 10347698328.0000 | 20887448736 | 11 | NULL | |
io_write_thread | 11 | 121420247520 | 2364388752 | 11038204320.0000 | 24815805696 | 12 | NULL | |
main | 150 | 107607007728 | 73392 | 437706687.0000 | 31654334976 | 1 | NULL | |
log_writer_thread | 364 | 75802106688 | 526944 | 208247424.0000 | 12131071920 | 20 | NULL | |
srv_purge_thread | 2 | 1505485872 | 251696544 | 752742936.0000 | 1253789328 | 36 | NULL | |
srv_worker_thread | 2 | 1246769040 | 11522544 | 623384520.0000 | 1235246496 | 38 | NULL | |
clone_gtid_thread | 5 | 978743040 | 7288512 | 195748608.0000 | 358382640 | 35 | NULL | |
io_read_thread | 16 | 654995616 | 20386608 | 40937160.0000 | 65874336 | 5 | NULL | |
srv_master_thread | 1 | 369631680 | 369631680 | 369631680.0000 | 369631680 | 25 | NULL | |
srv_worker_thread | 2 | 17354832 | 7985472 | 8677416.0000 | 9369360 | 42 | NULL |
|