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 | 170 | 2644750983072 | 137984880 | 15557358696.0000 | 83043635664 | 18 | NULL | |
page_flush_coordinator_thread | 679 | 1146002296560 | 4205520 | 3800608548.0000 | 95678832480 | 13 | NULL | |
io_write_thread | 95 | 1097811070752 | 1583378016 | 11555905944.0000 | 39080688240 | 9 | NULL | |
log_checkpointer_thread | 72 | 578973191280 | 7653360 | 8041294272.0000 | 28034253456 | 15 | NULL | |
io_write_thread | 30 | 365495494848 | 1618825824 | 12183183144.0000 | 30554893776 | 10 | NULL | |
io_write_thread | 17 | 178877336880 | 2330829600 | 10522196256.0000 | 15880747872 | 11 | NULL | |
main | 147 | 115281861552 | 102960 | 446411889.0000 | 26807888976 | 1 | NULL | |
log_writer_thread | 247 | 91217006496 | 505296 | 369299568.0000 | 22720053840 | 20 | NULL | |
srv_purge_thread | 2 | 4099027680 | 258987168 | 2049513840.0000 | 3840040512 | 36 | NULL | |
root@192.168.30.20 | 1 | 1844423328 | 1844423328 | 1844423328.0000 | 1844423328 | 3293 | 3177 | |
clone_gtid_thread | 5 | 956994720 | 5291616 | 191398944.0000 | 335403024 | 35 | NULL | |
io_read_thread | 5 | 164987856 | 26524608 | 32997360.0000 | 52289952 | 5 | NULL | |
srv_worker_thread | 3 | 64277136 | 9002928 | 21425712.0000 | 36998016 | 38 | NULL | |
srv_worker_thread | 2 | 26103792 | 13004112 | 13051896.0000 | 13099680 | 42 | NULL |
|