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 | 319 | 4551669501456 | 149345856 | 14268556368.0000 | 106797050448 | 18 | NULL | |
page_flush_coordinator_thread | 1189 | 1591993424736 | 3517536 | 1117846752.0000 | 43082002656 | 13 | NULL | |
io_write_thread | 101 | 1154417300784 | 1544776464 | 11429874192.0000 | 29590163328 | 9 | NULL | |
io_write_thread | 68 | 703258866816 | 1578661392 | 10342042128.0000 | 33430182720 | 10 | NULL | |
log_checkpointer_thread | 96 | 693373274352 | 10653456 | 7222638192.0000 | 25261195872 | 15 | NULL | |
io_write_thread | 21 | 228454742736 | 1602202272 | 10878797160.0000 | 19135840416 | 11 | NULL | |
log_writer_thread | 483 | 116847741120 | 516384 | 241920624.0000 | 9499419072 | 20 | NULL | |
main | 148 | 112702095792 | 88176 | 462405042.0000 | 34836035520 | 1 | NULL | |
io_write_thread | 14 | 105569107248 | 1822857696 | 7540650480.0000 | 13956422304 | 12 | NULL | |
srv_purge_thread | 2 | 2774433552 | 193814544 | 1387216776.0000 | 2580619008 | 36 | NULL | |
srv_worker_thread | 2 | 1774087920 | 325242192 | 887043960.0000 | 1448845728 | 40 | NULL | |
clone_gtid_thread | 5 | 1344960672 | 13014672 | 268991976.0000 | 779244576 | 35 | NULL | |
io_read_thread | 17 | 582563520 | 22834944 | 34268256.0000 | 49775088 | 5 | NULL | |
srv_worker_thread | 2 | 349023312 | 23084160 | 174511656.0000 | 325939152 | 38 | NULL | |
srv_worker_thread | 2 | 22125312 | 10483440 | 11062656.0000 | 11641872 | 42 | NULL |
|