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 | 89 | 1376637537264 | 1468383840 | 15467837352.0000 | 79359668784 | 18 | NULL | |
io_write_thread | 16 | 207481092192 | 4037972928 | 12967568064.0000 | 22041977760 | 9 | NULL | |
page_flush_coordinator_thread | 295 | 142634106384 | 6182880 | 263436756.0000 | 36711125616 | 13 | NULL | |
main | 146 | 94290161328 | 117744 | 376551681.0000 | 35059058496 | 1 | NULL | |
log_checkpointer_thread | 14 | 93319612848 | 16721232 | 6665686632.0000 | 17961853536 | 15 | NULL | |
io_write_thread | 4 | 49076240928 | 1728763344 | 12269060232.0000 | 19865900208 | 12 | NULL | |
log_writer_thread | 143 | 14622148464 | 592944 | 102252744.0000 | 3824790816 | 20 | NULL | |
clone_gtid_thread | 5 | 948520320 | 11038896 | 189704064.0000 | 345500496 | 35 | NULL | |
srv_worker_thread | 1 | 568330224 | 568330224 | 568330224.0000 | 568330224 | 40 | NULL | |
srv_worker_thread | 2 | 352714560 | 10312368 | 176357280.0000 | 342402192 | 42 | NULL | |
root@192.168.30.20 | 1 | 334721376 | 334721376 | 334721376.0000 | 334721376 | 672 | 620 | |
srv_purge_thread | 1 | 281015856 | 281015856 | 281015856.0000 | 281015856 | 36 | NULL | |
io_read_thread | 1 | 34185888 | 34185888 | 34185888.0000 | 34185888 | 5 | NULL | |
srv_worker_thread | 1 | 25469136 | 25469136 | 25469136.0000 | 25469136 | 38 | NULL |
|