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 | 191 | 2636332715280 | 63248064 | 13802788824.0000 | 49256825376 | 18 | NULL | |
page_flush_coordinator_thread | 1025 | 1529762980944 | 3660624 | 1319258820.0000 | 185601274320 | 13 | NULL | |
io_write_thread | 71 | 781451197824 | 1654167504 | 11006354832.0000 | 31355094672 | 9 | NULL | |
log_checkpointer_thread | 86 | 641519100816 | 12043152 | 7459524336.0000 | 23285004336 | 15 | NULL | |
io_write_thread | 45 | 495127560048 | 1737638496 | 11002834656.0000 | 30729487536 | 10 | NULL | |
io_write_thread | 14 | 159464670288 | 1829795088 | 11390333592.0000 | 25754064336 | 11 | NULL | |
main | 148 | 105511860432 | 74976 | 409386384.0000 | 23180321472 | 1 | NULL | |
io_write_thread | 3 | 47463282240 | 2760137424 | 15821093904.0000 | 26341774800 | 12 | NULL | |
log_writer_thread | 274 | 38780983296 | 473616 | 141536208.0000 | 13086137328 | 20 | NULL | |
io_read_thread | 35 | 2108038416 | 17318928 | 60229488.0000 | 197545920 | 5 | NULL | |
srv_purge_thread | 2 | 1672987008 | 286523952 | 836493504.0000 | 1386463056 | 36 | NULL | |
clone_gtid_thread | 5 | 1059744048 | 6851328 | 211948704.0000 | 378554352 | 35 | NULL | |
srv_worker_thread | 2 | 36520704 | 9245808 | 18260352.0000 | 27274896 | 38 | NULL | |
srv_worker_thread | 3 | 25378320 | 7114272 | 8459352.0000 | 10311312 | 42 | NULL |
|