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 | 395 | 6172341762048 | 49553328 | 15626181648.0000 | 491965089264 | 18 | NULL | |
page_flush_coordinator_thread | 1192 | 1207330131216 | 3544992 | 709121688.0000 | 62509003920 | 13 | NULL | |
io_write_thread | 83 | 1065877133376 | 1751568192 | 12841892976.0000 | 36574606464 | 9 | NULL | |
log_checkpointer_thread | 66 | 543160013616 | 6162816 | 8229697080.0000 | 41283021120 | 15 | NULL | |
log_writer_thread | 625 | 419026597968 | 577104 | 670442520.0000 | 113794733712 | 20 | NULL | |
io_write_thread | 32 | 414767445312 | 1643644464 | 12961482600.0000 | 39205351680 | 10 | NULL | |
io_write_thread | 16 | 224422396704 | 1809654000 | 14026399728.0000 | 35795516592 | 12 | NULL | |
main | 149 | 159120518304 | 135168 | 676461522.0000 | 42135305520 | 1 | NULL | |
io_write_thread | 7 | 89612075520 | 1591839216 | 12801724848.0000 | 30029492592 | 11 | NULL | |
srv_purge_thread | 2 | 4514527776 | 316277808 | 2257263888.0000 | 4198249968 | 36 | NULL | |
srv_worker_thread | 2 | 1113946416 | 6489648 | 556973208.0000 | 1107456768 | 38 | NULL | |
clone_gtid_thread | 4 | 658735968 | 8340816 | 164683992.0000 | 328804080 | 35 | NULL | |
io_read_thread | 7 | 229929216 | 24170256 | 32846880.0000 | 42049920 | 5 | NULL | |
srv_worker_thread | 2 | 22640640 | 7173936 | 11320320.0000 | 15466704 | 42 | NULL |
|