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 | 3950 | 46918760381856 | 41637552 | 11878167048.0000 | 703004902512 | 18 | NULL | |
page_flush_coordinator_thread | 14041 | 5551841792112 | 3405072 | 216723144.0000 | 41641953936 | 13 | NULL | |
io_write_thread | 365 | 2738048763120 | 64045872 | 7501503240.0000 | 30462248256 | 9 | NULL | |
io_write_thread | 296 | 2555218799760 | 1508484912 | 8632495872.0000 | 38708969376 | 10 | NULL | |
log_checkpointer_thread | 270 | 1823378386896 | 8717280 | 6753253056.0000 | 101544580368 | 15 | NULL | |
log_writer_thread | 6356 | 1205007573264 | 483648 | 189585792.0000 | 12465154416 | 20 | NULL | |
io_write_thread | 118 | 1164079425696 | 103835952 | 9865079664.0000 | 117729340080 | 11 | NULL | |
io_write_thread | 119 | 867224153664 | 1450741248 | 7287597768.0000 | 32055317184 | 12 | NULL | |
main | 149 | 95049828720 | 74976 | 407662860.0000 | 26931266208 | 1 | NULL | |
srv_purge_thread | 6 | 15803395344 | 183343776 | 2633899224.0000 | 7047893424 | 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 |
|