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 | 314 | 4589968664160 | 76569504 | 14617734384.0000 | 136677701424 | 18 | NULL | |
page_flush_coordinator_thread | 1158 | 1397832845904 | 3747216 | 631966500.0000 | 69610509408 | 13 | NULL | |
io_write_thread | 96 | 1042734020592 | 1639269456 | 10861812456.0000 | 31294951776 | 9 | NULL | |
log_checkpointer_thread | 104 | 796155895392 | 7651776 | 7655345016.0000 | 27820858560 | 15 | NULL | |
io_write_thread | 53 | 652680133248 | 1662350448 | 12314719296.0000 | 31828539600 | 10 | NULL | |
log_writer_thread | 494 | 279115912416 | 548592 | 565011744.0000 | 98014193376 | 20 | NULL | |
io_write_thread | 19 | 229446419664 | 2775410352 | 12076127184.0000 | 30338261184 | 11 | NULL | |
io_write_thread | 14 | 164207994720 | 1730539008 | 11729142480.0000 | 25332106272 | 12 | NULL | |
main | 149 | 92412109152 | 74448 | 390052410.0000 | 37395751536 | 1 | NULL | |
srv_purge_thread | 2 | 6509691408 | 1828710576 | 3254845704.0000 | 4680980832 | 36 | NULL | |
srv_worker_thread | 2 | 1299604416 | 15096048 | 649802208.0000 | 1284508368 | 38 | NULL | |
clone_gtid_thread | 4 | 679046544 | 5624256 | 169761504.0000 | 366232944 | 35 | NULL | |
srv_worker_thread | 3 | 52709712 | 10366224 | 17569728.0000 | 28707888 | 42 | NULL | |
io_read_thread | 1 | 49349520 | 49349520 | 49349520.0000 | 49349520 | 5 | NULL |
|