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 | 3330 | 41838050352912 | 45636624 | 12563978856.0000 | 229806344064 | 18 | NULL | |
root@192.168.30.20 | 1254 | 6421433495664 | 499488 | 5859271308.0000 | 44032606992 | 9197 | 8905 | |
page_flush_coordinator_thread | 4118 | 3423735910848 | 3463680 | 432649932.0000 | 239722177200 | 13 | NULL | |
io_write_thread | 174 | 1860340333632 | 115935072 | 10691610864.0000 | 61839174672 | 9 | NULL | |
io_write_thread | 141 | 1603842710976 | 135322704 | 11374770792.0000 | 91765976544 | 10 | NULL | |
log_writer_thread | 6537 | 1592023199712 | 460944 | 243540264.0000 | 99206339760 | 20 | NULL | |
log_checkpointer_thread | 149 | 902660472384 | 7116912 | 4947999672.0000 | 21771039840 | 15 | NULL | |
io_write_thread | 48 | 596873412960 | 1488074544 | 12434862528.0000 | 29675039856 | 12 | NULL | |
io_write_thread | 44 | 523501723536 | 1538756736 | 11897766408.0000 | 27313097856 | 11 | NULL | |
main | 151 | 108813730608 | 90288 | 432305016.0000 | 31704022416 | 1 | NULL | |
srv_purge_thread | 4 | 6609527760 | 241899504 | 1652381808.0000 | 4065177600 | 36 | NULL | |
srv_worker_thread | 2 | 1693374672 | 22927344 | 846687336.0000 | 1670447328 | 42 | NULL | |
clone_gtid_thread | 4 | 554416368 | 6940032 | 138603960.0000 | 277528944 | 35 | NULL | |
srv_worker_thread | 1 | 324086400 | 324086400 | 324086400.0000 | 324086400 | 40 | NULL | |
srv_worker_thread | 2 | 26122272 | 8970192 | 13061136.0000 | 17152080 | 38 | NULL |
|