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 | 321 | 5247276952896 | 49553328 | 16346656920.0000 | 491965089264 | 18 | NULL | |
page_flush_coordinator_thread | 1110 | 1034484820512 | 3544992 | 669738432.0000 | 62509003920 | 13 | NULL | |
io_write_thread | 68 | 927308593200 | 2332915200 | 13636890960.0000 | 36574606464 | 9 | NULL | |
log_checkpointer_thread | 62 | 514399499856 | 6162816 | 8296766016.0000 | 41283021120 | 15 | NULL | |
log_writer_thread | 500 | 391527147792 | 577104 | 783054096.0000 | 113794733712 | 20 | NULL | |
io_write_thread | 29 | 383965449648 | 1643644464 | 13240187664.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 | 5 | 71217075072 | 1591839216 | 14243414856.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 |
|