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 | 546 | 9216802108800 | 85855440 | 16880589792.0000 | 595801238736 | 18 | NULL | |
page_flush_coordinator_thread | 2017 | 2197321186896 | 3316896 | 575537028.0000 | 48315328512 | 13 | NULL | |
io_write_thread | 177 | 1885419280800 | 312890688 | 10652086104.0000 | 46359746400 | 9 | NULL | |
log_checkpointer_thread | 158 | 1152708356448 | 9029856 | 7295622312.0000 | 38125212048 | 15 | NULL | |
io_write_thread | 56 | 609135625296 | 1651362240 | 10877421720.0000 | 28757720640 | 10 | NULL | |
io_write_thread | 40 | 499220911728 | 2199247776 | 12480522648.0000 | 35091392688 | 11 | NULL | |
io_write_thread | 33 | 487475250240 | 2834347824 | 14771977176.0000 | 63049728720 | 12 | NULL | |
log_writer_thread | 1083 | 324894400512 | 466224 | 299994816.0000 | 93364505520 | 20 | NULL | |
srv_purge_thread | 2 | 114734679312 | 1852489584 | 57367339656.0000 | 112882189728 | 36 | NULL | |
main | 148 | 89492362080 | 80256 | 376686948.0000 | 32172832560 | 1 | NULL | |
clone_gtid_thread | 5 | 852342480 | 4401408 | 170468496.0000 | 297160512 | 35 | NULL | |
io_read_thread | 3 | 182982624 | 35329008 | 60994032.0000 | 105778992 | 5 | NULL | |
srv_worker_thread | 3 | 144482976 | 7664976 | 48160992.0000 | 126642912 | 42 | NULL | |
srv_worker_thread | 2 | 24178176 | 6534528 | 12089088.0000 | 17643648 | 38 | NULL |
|