Karl Heinz Peters schrieb:
Norman schrieb:
Hi Guys,
we ran in a "out-of-disk-space" server because the dspam table used all
of the *60 GB*!
We run the cleanup script every night so i thought this could never
happen... But now i noticed that after the script is run there is no new
space aviable.
After digging a while it seems that the problem is that the script don't
run an "OPTIMISE TABLE" command after cleaning up.
Anyone allready see this problem ?
bye
Norman
!DSPAM:1,45e6790a296441380872563!
old problem, known solution(s):
1) add the optimise-statements to the .sql
2) run it manually, like me:
10 2 * * * /usr/local/mysql-5.0.27/bin/mysql -u dspam -p'XXXXXX' dspam
< /home/dspam/purge-4.1.sql
20 2 * * * /usr/local/mysql-5.0.27/bin/mysql -u dspam -p'XXXXXX' dspam
-e 'analyze table dspam_signature_data, dspam_token_data; optimize
table dspam_signature_data, dspam_token_data;'
Hi Karl,
thx for the help.. Even if i not understand why this is not fixed in a
dspam patch release. IMHO its a major bug.
bye
Norman
