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 | 329 | 4426127411904 | 152509104 | 13453274736.0000 | 133153853184 | 18 | NULL | |
page_flush_coordinator_thread | 1124 | 1841122446240 | 3813216 | 847304304.0000 | 558456978816 | 13 | NULL | |
io_write_thread | 90 | 894102676368 | 1610865696 | 9934474176.0000 | 36015567984 | 9 | NULL | |
log_checkpointer_thread | 123 | 868715443728 | 7180272 | 7062727056.0000 | 57050887344 | 15 | NULL | |
io_write_thread | 80 | 771548322336 | 1560284352 | 9644354016.0000 | 34460715168 | 10 | NULL | |
io_write_thread | 33 | 376869164496 | 1573409376 | 11420277528.0000 | 29529855696 | 11 | NULL | |
io_write_thread | 16 | 152214933024 | 2564945328 | 9513433248.0000 | 18073901472 | 12 | NULL | |
log_writer_thread | 483 | 140257569936 | 526944 | 290388120.0000 | 85135479264 | 20 | NULL | |
main | 146 | 90440818512 | 141504 | 363787413.0000 | 24379301760 | 1 | NULL | |
srv_purge_thread | 2 | 1164583728 | 326722704 | 582291864.0000 | 837861024 | 36 | NULL | |
srv_worker_thread | 1 | 814299552 | 814299552 | 814299552.0000 | 814299552 | 40 | NULL | |
clone_gtid_thread | 4 | 614977440 | 9540960 | 153744360.0000 | 316478448 | 35 | NULL | |
srv_worker_thread | 2 | 244289760 | 9142320 | 122144880.0000 | 235147440 | 38 | NULL | |
srv_worker_thread | 2 | 23313312 | 9418992 | 11656656.0000 | 13894320 | 42 | NULL |
|