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 | 374 | 5266152484032 | 113126640 | 14080621368.0000 | 73656150480 | 18 | NULL | |
page_flush_coordinator_thread | 1625 | 1462462244496 | 3341712 | 650242428.0000 | 72125942592 | 13 | NULL | |
io_write_thread | 110 | 1262458113312 | 1562233200 | 11476891800.0000 | 35640392832 | 9 | NULL | |
log_checkpointer_thread | 90 | 693258251664 | 13041600 | 7702869240.0000 | 35200168608 | 15 | NULL | |
io_write_thread | 50 | 626164152768 | 2411943072 | 12523282992.0000 | 26791148208 | 10 | NULL | |
io_write_thread | 12 | 161346097968 | 2323530000 | 13445508120.0000 | 28454180832 | 11 | NULL | |
log_writer_thread | 587 | 160663103040 | 570240 | 273702000.0000 | 23353527648 | 20 | NULL | |
io_write_thread | 12 | 116428570896 | 2202169728 | 9702380688.0000 | 19300778640 | 12 | NULL | |
main | 148 | 100851103584 | 74448 | 495521103.0000 | 24204492048 | 1 | NULL | |
srv_purge_thread | 2 | 4721746128 | 310227984 | 2360873064.0000 | 4411518144 | 36 | NULL | |
srv_worker_thread | 1 | 1913893872 | 1913893872 | 1913893872.0000 | 1913893872 | 40 | NULL | |
srv_worker_thread | 2 | 1844536848 | 13766016 | 922268424.0000 | 1830770832 | 42 | NULL | |
clone_gtid_thread | 5 | 839522112 | 7009200 | 167904264.0000 | 393738576 | 35 | NULL | |
io_read_thread | 2 | 73039296 | 33921360 | 36519648.0000 | 39117936 | 5 | NULL | |
srv_worker_thread | 2 | 27379968 | 10956528 | 13689984.0000 | 16423440 | 38 | NULL |
|