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 | 189 | 3412825443456 | 90809136 | 18057277392.0000 | 854732927136 | 18 | NULL | |
io_write_thread | 90 | 1041295187328 | 1762109712 | 11569946520.0000 | 46986683040 | 9 | NULL | |
page_flush_coordinator_thread | 897 | 988836136464 | 3821664 | 1060074840.0000 | 45206677824 | 13 | NULL | |
log_writer_thread | 285 | 823493598576 | 524832 | 2889450960.0000 | 749429056992 | 20 | NULL | |
log_checkpointer_thread | 66 | 503671520880 | 10601184 | 7631386488.0000 | 21537819600 | 15 | NULL | |
io_write_thread | 38 | 364792337712 | 1565754960 | 9599798208.0000 | 26670025008 | 10 | NULL | |
main | 149 | 108486835776 | 71280 | 426507015.0000 | 26006069760 | 1 | NULL | |
io_write_thread | 9 | 106650430128 | 3945084000 | 11850047616.0000 | 21592043088 | 11 | NULL | |
io_write_thread | 4 | 34269332592 | 4732312464 | 8567333016.0000 | 13551000672 | 12 | NULL | |
srv_purge_thread | 2 | 4074374832 | 315096672 | 2037187416.0000 | 3759278160 | 36 | NULL | |
srv_worker_thread | 2 | 1927123968 | 11910624 | 963561984.0000 | 1915213344 | 42 | NULL | |
clone_gtid_thread | 4 | 659976768 | 7026624 | 164994192.0000 | 341374704 | 35 | NULL | |
srv_worker_thread | 3 | 61938096 | 11369424 | 20645856.0000 | 28420656 | 38 | NULL |
|