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 | 330 | 4538742602064 | 62216880 | 13753765344.0000 | 156761479776 | 18 | NULL | |
page_flush_coordinator_thread | 1071 | 950709685728 | 4491168 | 467384808.0000 | 62313388368 | 13 | NULL | |
io_write_thread | 88 | 785884601040 | 1534276656 | 8930506728.0000 | 21442546752 | 9 | NULL | |
log_checkpointer_thread | 58 | 437884993392 | 7089984 | 7549741056.0000 | 27533306064 | 15 | NULL | |
io_write_thread | 33 | 430939068384 | 1621622640 | 13058759472.0000 | 35256273360 | 10 | NULL | |
io_write_thread | 11 | 166254969408 | 4298663952 | 15114087912.0000 | 42005072736 | 11 | NULL | |
log_writer_thread | 502 | 121770687456 | 494208 | 242570856.0000 | 8681250864 | 20 | NULL | |
main | 147 | 79780846992 | 83952 | 332599344.0000 | 26894193744 | 1 | NULL | |
io_write_thread | 7 | 65930084880 | 1880154144 | 9418583328.0000 | 14561407872 | 12 | NULL | |
io_read_thread | 39 | 6752628432 | 5730912 | 173144136.0000 | 5693151552 | 5 | NULL | |
srv_purge_thread | 2 | 3903638112 | 197988912 | 1951819056.0000 | 3705649200 | 36 | NULL | |
srv_worker_thread | 1 | 1171837392 | 1171837392 | 1171837392.0000 | 1171837392 | 40 | NULL | |
clone_gtid_thread | 5 | 933386784 | 5997024 | 186677304.0000 | 322567344 | 35 | NULL | |
srv_worker_thread | 3 | 508227456 | 13800864 | 169409064.0000 | 289433760 | 38 | NULL | |
srv_worker_thread | 3 | 49966224 | 7236768 | 16655232.0000 | 24275856 | 42 | NULL |
|