AI PM at a semiconductor simulation startup | Building AI-powered plasma simulation & digital twins | Multi-Agent systems builder | Claude Code power user
How I checked it:
1. Check the SQLite log files:
`ls -lh ~/.codex/logs_2.sqlite*`
2. See who is holding them:
`lsof ~/.codex/logs_2.sqlite*`
3. Sample whether writes continue:
`sqlite3 -readonly ~/.codex/logs_2.sqlite "select max(id), count(*) from logs;"`
Run it twice 10-20s apart. If `max(id)` keeps increasing, logs are still being inserted.
Today I found my AI coding tool quietly hammering my SSD: Codex was writing high-frequency TRACE logs into `logs_2.sqlite` via SQLite WAL.
I backed it up, added a trigger to block log inserts, checkpointed/truncated the WAL, and verified `MAX(id)` + WAL size stopped growing.