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 | 171 | 2482713764784 | 1237855872 | 14518793784.0000 | 111094090272 | 18 | NULL | |
log_writer_thread | 301 | 442527682080 | 584496 | 1470191448.0000 | 179795740608 | 20 | NULL | |
page_flush_coordinator_thread | 584 | 331861544256 | 3538128 | 332779920.0000 | 44348046336 | 13 | NULL | |
io_write_thread | 17 | 195555173088 | 1684584528 | 11503245336.0000 | 27940286880 | 9 | NULL | |
log_checkpointer_thread | 18 | 115267240704 | 9252672 | 6403735536.0000 | 17764498224 | 15 | NULL | |
io_write_thread | 7 | 114271403664 | 4458775728 | 16324486200.0000 | 35737462992 | 10 | NULL | |
main | 150 | 100372440960 | 77088 | 386473890.0000 | 23620786464 | 1 | NULL | |
io_write_thread | 12 | 93150531408 | 1742268528 | 7762544064.0000 | 13807043184 | 12 | NULL | |
io_write_thread | 9 | 76322387856 | 1595648736 | 8480265288.0000 | 15122497104 | 11 | NULL | |
srv_worker_thread | 3 | 2624543856 | 22510752 | 874847952.0000 | 2282583600 | 38 | NULL | |
srv_purge_thread | 2 | 1965741888 | 379150464 | 982870944.0000 | 1586591424 | 36 | NULL | |
srv_worker_thread | 2 | 1471802112 | 12843600 | 735901056.0000 | 1458958512 | 42 | NULL | |
clone_gtid_thread | 4 | 503018208 | 7046160 | 125754552.0000 | 272640192 | 35 | NULL | |
root@192.168.30.20 | 1 | 415888704 | 415888704 | 415888704.0000 | 415888704 | 617 | 573 |
|