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 | 230 | 3187856540352 | 68158464 | 13860245784.0000 | 76403072064 | 18 | NULL | |
page_flush_coordinator_thread | 980 | 1111761496032 | 3563472 | 641193432.0000 | 50878962816 | 13 | NULL | |
io_write_thread | 99 | 1009061148480 | 1626309696 | 10192536816.0000 | 26116429680 | 9 | NULL | |
log_checkpointer_thread | 96 | 721506441744 | 7077312 | 7515691920.0000 | 28141720992 | 15 | NULL | |
io_write_thread | 61 | 604732774800 | 1596951840 | 9913651968.0000 | 57536207520 | 10 | NULL | |
main | 150 | 108719388624 | 73920 | 416443863.0000 | 32007740160 | 1 | NULL | |
io_write_thread | 5 | 105410804928 | 9636027456 | 21082160880.0000 | 35742557664 | 11 | NULL | |
log_writer_thread | 335 | 62785009056 | 489984 | 187417824.0000 | 9578132784 | 20 | NULL | |
io_write_thread | 7 | 59908651440 | 1685112000 | 8558378664.0000 | 21807887376 | 12 | NULL | |
srv_worker_thread | 3 | 2280887136 | 15552240 | 760295712.0000 | 2242396464 | 38 | NULL | |
srv_purge_thread | 2 | 1949050224 | 399735072 | 974525112.0000 | 1549315152 | 36 | NULL | |
srv_worker_thread | 2 | 1853304816 | 8230464 | 926652408.0000 | 1845074352 | 42 | NULL | |
clone_gtid_thread | 5 | 1202571744 | 8938512 | 240514296.0000 | 407629200 | 35 | NULL | |
io_read_thread | 9 | 334824864 | 25614864 | 37202616.0000 | 49033248 | 5 | NULL |
|