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 | 237 | 3462371964480 | 95471904 | 14609164152.0000 | 55295861808 | 18 | NULL | |
io_write_thread | 104 | 1455194459664 | 36653760 | 13992254232.0000 | 196741934400 | 9 | NULL | |
page_flush_coordinator_thread | 889 | 1156245926880 | 4351776 | 698851296.0000 | 59134479888 | 13 | NULL | |
log_checkpointer_thread | 84 | 610953530880 | 6187632 | 7273256232.0000 | 25298740896 | 15 | NULL | |
io_write_thread | 31 | 352260156864 | 1631474064 | 11363230824.0000 | 25013520576 | 10 | NULL | |
main | 149 | 139614500784 | 78672 | 587839659.0000 | 34372297344 | 1 | NULL | |
io_write_thread | 4 | 91838856384 | 16344436944 | 22959714096.0000 | 29915858544 | 12 | NULL | |
log_writer_thread | 373 | 88466144976 | 548592 | 237174432.0000 | 11454423552 | 20 | NULL | |
io_write_thread | 6 | 57765689520 | 4283630736 | 9627614832.0000 | 15163159440 | 11 | NULL | |
srv_purge_thread | 2 | 8103000048 | 3253864944 | 4051500024.0000 | 4849135104 | 36 | NULL | |
srv_worker_thread | 2 | 842668992 | 20919888 | 421334496.0000 | 821749104 | 38 | NULL | |
clone_gtid_thread | 4 | 642102384 | 5696064 | 160525464.0000 | 348720240 | 35 | NULL | |
io_read_thread | 16 | 266580336 | 8155488 | 16661040.0000 | 92053104 | 5 | NULL | |
srv_worker_thread | 2 | 32571264 | 16149408 | 16285632.0000 | 16421856 | 42 | NULL |
|