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 | 273 | 3326630240208 | 89050368 | 12185458560.0000 | 59272131600 | 18 | NULL | |
io_write_thread | 20 | 271665498720 | 1625116944 | 13583274936.0000 | 30462248256 | 9 | NULL | |
page_flush_coordinator_thread | 894 | 262743067488 | 3634752 | 167941224.0000 | 41641953936 | 13 | NULL | |
io_write_thread | 17 | 203095579632 | 1610580048 | 11946798600.0000 | 24006391200 | 10 | NULL | |
log_writer_thread | 430 | 145792225920 | 580272 | 339051504.0000 | 11224898256 | 20 | NULL | |
main | 149 | 95049828720 | 74976 | 407662860.0000 | 26931266208 | 1 | NULL | |
log_checkpointer_thread | 10 | 69868218288 | 12529968 | 6986821776.0000 | 20792113584 | 15 | NULL | |
io_write_thread | 2 | 47306836368 | 20773149936 | 23653418184.0000 | 26533686432 | 12 | NULL | |
io_write_thread | 1 | 16282901712 | 16282901712 | 16282901712.0000 | 16282901712 | 11 | NULL | |
srv_purge_thread | 2 | 3997317456 | 183343776 | 1998658728.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 | |
srv_worker_thread | 2 | 22490160 | 8439024 | 11245080.0000 | 14051136 | 38 | NULL |
|