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 | 77 | 1090235973552 | 80980944 | 14158908720.0000 | 39607370352 | 18 | NULL | |
io_write_thread | 65 | 522533772288 | 56183424 | 8038981104.0000 | 29442897792 | 9 | NULL | |
page_flush_coordinator_thread | 346 | 493681657920 | 4297920 | 742893756.0000 | 57295939536 | 13 | NULL | |
log_checkpointer_thread | 56 | 338377636080 | 9527232 | 6042457608.0000 | 26612431296 | 15 | NULL | |
io_write_thread | 10 | 72991855728 | 1370327376 | 7299185520.0000 | 16101618192 | 10 | NULL | |
main | 127 | 39746436048 | 77616 | 208755162.0000 | 14955057216 | 1 | NULL | |
log_writer_thread | 111 | 24137861616 | 544368 | 217458120.0000 | 4201674048 | 20 | NULL | |
clone_gtid_thread | 5 | 1655916768 | 244407504 | 331183248.0000 | 371722560 | 35 | NULL | |
dict_stats_thread | 1 | 293001456 | 293001456 | 293001456.0000 | 293001456 | 26 | NULL | |
io_read_thread | 1 | 19927248 | 19927248 | 19927248.0000 | 19927248 | 5 | NULL | |
buf_dump_thread | 2 | 10964448 | 4092000 | 5482224.0000 | 6872448 | 34 | NULL |
|