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 | 206 | 2876762061888 | 66013200 | 13964864232.0000 | 195887045376 | 18 | NULL | |
io_write_thread | 46 | 1038251586240 | 1694717376 | 22570686600.0000 | 555946494576 | 9 | NULL | |
page_flush_coordinator_thread | 682 | 683983841376 | 4357584 | 1002908808.0000 | 55993148112 | 13 | NULL | |
io_write_thread | 45 | 436396594128 | 1592419488 | 9697702080.0000 | 21276756864 | 10 | NULL | |
log_checkpointer_thread | 50 | 405116328672 | 11993520 | 8102326320.0000 | 51152771472 | 15 | NULL | |
log_writer_thread | 313 | 176876261232 | 517968 | 565099656.0000 | 109518901008 | 20 | NULL | |
io_write_thread | 12 | 106222408512 | 2356565904 | 8851867200.0000 | 17824992768 | 11 | NULL | |
main | 145 | 85794887904 | 77616 | 373752588.0000 | 24489775200 | 1 | NULL | |
io_write_thread | 4 | 37390588224 | 2627867616 | 9347647056.0000 | 14454737088 | 12 | NULL | |
srv_purge_thread | 2 | 4056814608 | 167508528 | 2028407304.0000 | 3889306080 | 36 | NULL | |
srv_worker_thread | 1 | 1183676736 | 1183676736 | 1183676736.0000 | 1183676736 | 40 | NULL | |
clone_gtid_thread | 5 | 651119040 | 8116416 | 130223808.0000 | 228393792 | 35 | NULL | |
srv_worker_thread | 2 | 369923136 | 13989888 | 184961568.0000 | 355933248 | 38 | NULL | |
io_read_thread | 10 | 110735856 | 6568848 | 11073480.0000 | 28290240 | 5 | NULL | |
srv_worker_thread | 2 | 23727264 | 9431664 | 11863632.0000 | 14295600 | 42 | NULL |
|