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 | 516 | 7258899381888 | 1192659600 | 14067634416.0000 | 156025570800 | 18 | NULL | |
page_flush_coordinator_thread | 1229 | 975013828272 | 4123152 | 441771924.0000 | 59802832848 | 13 | NULL | |
io_write_thread | 58 | 703167631584 | 1610211504 | 12123579600.0000 | 31539042480 | 9 | NULL | |
io_write_thread | 30 | 608018159760 | 1781027424 | 20267271816.0000 | 119430016464 | 10 | NULL | |
log_writer_thread | 1259 | 361876985184 | 468864 | 287431848.0000 | 55396709280 | 20 | NULL | |
log_checkpointer_thread | 46 | 334883860080 | 9470208 | 7280083800.0000 | 23960631024 | 15 | NULL | |
io_write_thread | 15 | 191631897600 | 1605293712 | 12775459752.0000 | 34056705408 | 12 | NULL | |
io_write_thread | 13 | 182673019056 | 1708328688 | 14051770656.0000 | 50721448800 | 11 | NULL | |
main | 148 | 107076765840 | 80784 | 417332223.0000 | 33954997824 | 1 | NULL | |
srv_purge_thread | 2 | 22583731632 | 291449136 | 11291865816.0000 | 22292282496 | 36 | NULL | |
srv_worker_thread | 2 | 5433276816 | 481915632 | 2716638408.0000 | 4951361184 | 40 | NULL | |
clone_gtid_thread | 4 | 627633600 | 5568816 | 156908400.0000 | 315471024 | 35 | NULL | |
io_read_thread | 1 | 49684800 | 49684800 | 49684800.0000 | 49684800 | 5 | NULL | |
srv_worker_thread | 2 | 27898464 | 10649232 | 13949232.0000 | 17249232 | 42 | NULL | |
srv_worker_thread | 2 | 26486592 | 9384672 | 13243296.0000 | 17101920 | 38 | NULL |
|