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 | 2726 | 32836452015312 | 48555936 | 12045653664.0000 | 703004902512 | 18 | NULL | |
page_flush_coordinator_thread | 9814 | 3984999277248 | 3405072 | 223854840.0000 | 41641953936 | 13 | NULL | |
io_write_thread | 228 | 2013157964400 | 1508484912 | 8829639984.0000 | 38708969376 | 10 | NULL | |
io_write_thread | 244 | 1927344406944 | 1491435792 | 7898952336.0000 | 30462248256 | 9 | NULL | |
log_checkpointer_thread | 176 | 1224879778320 | 8717280 | 6959543976.0000 | 101544580368 | 15 | NULL | |
log_writer_thread | 4400 | 902527193568 | 483648 | 205119816.0000 | 12465154416 | 20 | NULL | |
io_write_thread | 92 | 875683111776 | 1533922368 | 9518294544.0000 | 117729340080 | 11 | NULL | |
io_write_thread | 75 | 613027934112 | 1494147600 | 8173705584.0000 | 32055317184 | 12 | NULL | |
main | 149 | 95049828720 | 74976 | 407662860.0000 | 26931266208 | 1 | NULL | |
srv_purge_thread | 4 | 4541442576 | 183343776 | 1135360512.0000 | 3813973680 | 36 | NULL | |
srv_worker_thread | 2 | 577924512 | 7755792 | 288962256.0000 | 570168720 | 42 | NULL | |
clone_gtid_thread | 4 | 455854080 | 5932608 | 113963520.0000 | 222505536 | 35 | NULL | |
io_read_thread | 8 | 212866896 | 18089280 | 26608296.0000 | 49304112 | 5 | NULL | |
srv_worker_thread | 2 | 22490160 | 8439024 | 11245080.0000 | 14051136 | 38 | NULL |
|