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 | 60 | 828873149280 | 2125389552 | 13814552400.0000 | 43199187504 | 18 | NULL | |
io_write_thread | 36 | 447289995504 | 2068522368 | 12424722024.0000 | 26407634880 | 9 | NULL | |
page_flush_coordinator_thread | 273 | 293883353808 | 3985344 | 587272092.0000 | 33068931456 | 13 | NULL | |
log_checkpointer_thread | 27 | 190839148896 | 7159152 | 6749385456.0000 | 18613109328 | 15 | NULL | |
main | 147 | 103467496176 | 73920 | 406219836.0000 | 29506490640 | 1 | NULL | |
io_write_thread | 7 | 66712646880 | 4111934112 | 9530378088.0000 | 14175238704 | 11 | NULL | |
log_writer_thread | 94 | 14896324080 | 561264 | 158471280.0000 | 4085565264 | 20 | NULL | |
clone_gtid_thread | 5 | 1212834480 | 6170208 | 242566896.0000 | 414031728 | 35 | NULL | |
root@192.168.30.20 | 2 | 715446864 | 273165024 | 357723432.0000 | 442281840 | 1199 | 1103 | |
srv_purge_thread | 1 | 265506384 | 265506384 | 265506384.0000 | 265506384 | 36 | NULL | |
srv_worker_thread | 3 | 171799584 | 16828416 | 57266352.0000 | 136071936 | 42 | NULL | |
srv_worker_thread | 2 | 41785392 | 14372160 | 20892696.0000 | 27413232 | 38 | NULL | |
io_read_thread | 1 | 8807568 | 8807568 | 8807568.0000 | 8807568 | 5 | NULL |
|