i’ve got seemingly simple php script running every night on one of my servers… on the same machine i started to experience nightly oom-killer. i’ve found out that adodb’s Execute statement can do something completely else than you would expect from it – it loads whole result into memory rather than going row-by-row.
from this site. and it seems to be working. Go to MenuTools -> Error Console Paste the following in the “Code:” text-box: Press Enter or click Evaluate. The database will thence be vacuumed immediately.
i’m compressing quite a lot of data on the fly to save storage… until now i’ve been quite sure one cannot control compression level with oracle java’s GZIPOutputStream but apparently i was wrong.