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 | 354 | 4914330440976 | 64818336 | 13882289256.0000 | 68031389184 | 18 | NULL | |
page_flush_coordinator_thread | 1224 | 1516538626416 | 3980064 | 673955436.0000 | 47066444832 | 13 | NULL | |
io_write_thread | 123 | 1272634203456 | 1614654096 | 10346619360.0000 | 35510841696 | 9 | NULL | |
log_checkpointer_thread | 136 | 1004688916176 | 10252176 | 7387418280.0000 | 26521800096 | 15 | NULL | |
io_write_thread | 82 | 922557633888 | 1564845744 | 11250702672.0000 | 28553352432 | 10 | NULL | |
io_write_thread | 18 | 208650522432 | 1658986032 | 11591695632.0000 | 24829710576 | 12 | NULL | |
io_write_thread | 21 | 182029437216 | 2599921632 | 8668068288.0000 | 15072080496 | 11 | NULL | |
log_writer_thread | 521 | 160255036656 | 523248 | 307591152.0000 | 19856322816 | 20 | NULL | |
main | 149 | 116281529232 | 72864 | 451407792.0000 | 33989701152 | 1 | NULL | |
srv_purge_thread | 2 | 4258186416 | 521515104 | 2129093208.0000 | 3736671312 | 36 | NULL | |
srv_worker_thread | 2 | 1662680448 | 8821296 | 831340224.0000 | 1653859152 | 42 | NULL | |
srv_worker_thread | 3 | 1449985152 | 12113904 | 483328296.0000 | 931830240 | 38 | NULL | |
clone_gtid_thread | 5 | 1052694192 | 4380816 | 210538680.0000 | 370272672 | 35 | NULL | |
io_read_thread | 4 | 149535408 | 25697760 | 37383720.0000 | 53291040 | 5 | NULL |
|