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;'
