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 | 608 | 8262182216112 | 103333296 | 13589115408.0000 | 268152557904 | 18 | NULL | |
page_flush_coordinator_thread | 1656 | 1380000199248 | 3525456 | 442151556.0000 | 157880099520 | 13 | NULL | |
io_write_thread | 56 | 824178193872 | 2518830336 | 14717467512.0000 | 62867380224 | 10 | NULL | |
io_write_thread | 63 | 729366989472 | 1589511792 | 11577253776.0000 | 28529230752 | 9 | NULL | |
log_writer_thread | 1309 | 510944267856 | 470976 | 390331656.0000 | 129430657488 | 20 | NULL | |
log_checkpointer_thread | 56 | 375123859440 | 10238448 | 6698640168.0000 | 18249981552 | 15 | NULL | |
io_write_thread | 28 | 331407922560 | 1629429120 | 11835997008.0000 | 33095688384 | 11 | NULL | |
io_write_thread | 18 | 229206621600 | 2564210352 | 12733701024.0000 | 23151968400 | 12 | NULL | |
main | 150 | 90615285024 | 77088 | 363035805.0000 | 33167726064 | 1 | NULL | |
srv_purge_thread | 3 | 2451354576 | 202567728 | 817118016.0000 | 1159958976 | 36 | NULL | |
srv_worker_thread | 2 | 1407482208 | 7439520 | 703741104.0000 | 1400042688 | 42 | NULL | |
clone_gtid_thread | 5 | 808673184 | 6493872 | 161734584.0000 | 268537632 | 35 | NULL | |
root@192.168.30.20 | 16 | 697575120 | 496320 | 207570792.0000 | 394967760 | 1459 | 1399 | |
root@192.168.30.20 | 15 | 288189264 | 323136 | 19212600.0000 | 52958400 | 1461 | 1401 | |
srv_worker_thread | 2 | 33784608 | 16547520 | 16892304.0000 | 17237088 | 38 | NULL |
|