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 | 415 | 5772265360752 | 64818336 | 13909073112.0000 | 68031389184 | 18 | NULL | |
page_flush_coordinator_thread | 1454 | 1823919983952 | 3980064 | 680667240.0000 | 47066444832 | 13 | NULL | |
io_write_thread | 149 | 1521985113792 | 1614654096 | 10214665032.0000 | 35510841696 | 9 | NULL | |
log_checkpointer_thread | 164 | 1233513266304 | 9320256 | 7521422304.0000 | 27919820544 | 15 | NULL | |
io_write_thread | 94 | 1051195874256 | 1564845744 | 11182934664.0000 | 28553352432 | 10 | NULL | |
io_write_thread | 33 | 305395526304 | 2599921632 | 9254409648.0000 | 18389464896 | 11 | NULL | |
io_write_thread | 22 | 235390716000 | 1658986032 | 10699577856.0000 | 24829710576 | 12 | NULL | |
log_writer_thread | 605 | 187161523296 | 523248 | 309357840.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 |
|