Tonni, Can you post your mysql configuration?
My ibdata1 is too big: -rw-rw---- 1 mysql mysql 64G 2007-11-05 12:32 ibdata1 -rw-rw---- 1 mysql mysql 800M 2007-10-28 14:24 ibdata2 64GB it's bigger than my mysql tables... On Nov 2, 2007, at 2:34 PM, Tony Earnshaw wrote:
Aleksander Kamenik skrev, on 02-11-2007 16:08:Well, I use MySQL 5.0 on RHL5/Fedora FC6 and InnoDB and gave up on the purge*sql script many months ago - seem to remember it did nasty things.Can you elaborate?Sorry, no - I didn't, unfortunately, take notes.InnoDB doesn't work like MyISAM - perhaps it has something to do with that.Anyway, on InnoDB 'dspam_clean -p' works as desired ;) Best, --Tonni -- Tony Earnshaw Email: tonni at hetnet dot nl
-- Ítalo Rossi Administração de redes Diginet Brasil [EMAIL PROTECTED] (+55) 84 4008-9000Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você não for o destinatário ou a pessoa autorizada a receber
esta mensagem, não pode usar, copiar ou divulgar as informações nela contidas ou tomar qualquer ação baseada nessas informações. Se você recebeu esta mensagem por engano, por favor avise imediatamente o remetente, respondendo o e-mail e em seguida apague-o. Agradecemos sua cooperação. This message, including its attachments, may contain confidential and/orprivileged information. If you are not the recipient or authorized person to receive this message, you must not use, copy, disclose or take any action based
on this message or any information herein. If you received this messageby mistake, please advise the sender immediately by replying the e- mail and
deleting this message. Thank you for your cooperation.
PGP.sig
Description: This is a digitally signed message part
