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 | 251 | 3723984044352 | 114111360 | 14836589592.0000 | 184761579024 | 18 | NULL | |
page_flush_coordinator_thread | 1015 | 902484585024 | 3911424 | 889147248.0000 | 56868288048 | 13 | NULL | |
io_write_thread | 60 | 631595838192 | 1579195200 | 10526597136.0000 | 30136498656 | 9 | NULL | |
log_checkpointer_thread | 73 | 516120556512 | 6978576 | 7070144400.0000 | 37888915152 | 15 | NULL | |
io_write_thread | 44 | 451933211664 | 1614338352 | 10271209344.0000 | 28142720496 | 10 | NULL | |
io_write_thread | 11 | 180652407408 | 4693344480 | 16422946056.0000 | 26380732752 | 11 | NULL | |
io_write_thread | 17 | 146076147360 | 1593197760 | 8592714504.0000 | 13580702784 | 12 | NULL | |
log_writer_thread | 401 | 106211692224 | 450912 | 264866976.0000 | 14193336960 | 20 | NULL | |
main | 146 | 101405371056 | 103488 | 420307503.0000 | 30143874816 | 1 | NULL | |
clone_gtid_thread | 5 | 1054565952 | 6436320 | 210913032.0000 | 352761552 | 35 | NULL | |
io_read_thread | 25 | 588925392 | 5126880 | 23556984.0000 | 71253600 | 5 | NULL | |
srv_purge_thread | 2 | 541515744 | 220796928 | 270757872.0000 | 320718816 | 36 | NULL | |
srv_worker_thread | 2 | 181322064 | 8179248 | 90661032.0000 | 173142816 | 38 | NULL | |
srv_worker_thread | 2 | 46780800 | 21105216 | 23390400.0000 | 25675584 | 42 | NULL |
|