Hum on messageblks i gained about 800MB less. On headervalue gained 900MB less. But the problem is dbmail_mimeparts, that has the complete email. It has 45GB, that doesn’t corresponde to the email that is stored. Can I consider a bug here? I didn't run optimize on this table... I'm scared to do it :) What do you say paul? Even without optimize this should contain the correct size regarding the email that is stored?
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Uwe Kiewel > Sent: sábado, 2 de Agosto de 2008 9:11 > To: DBMail mailinglist > Subject: Re: [Dbmail] Db growing size > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Jorge, > > Jorge Bastos schrieb: > | I'm already using innodb_file_per_table, > | In fact it's my default for my MySQL Servers. > > > did you ever use the "optimize table" command? On my test environment I > can seee the result as follow: > > before: > 473956352 2008-08-02 09:47 dbmail_messageblks.ibd > > after: > 461373440 2008-08-02 10:05 dbmail_messageblks.ibd > > The mysql command is: > optimize table dbmail_messageblks; > > Another result for the header values table: > > before: > 117440512 2008-08-02 09:47 dbmail_headervalue.ibd > > after: > 67108864 2008-08-02 10:08 dbmail_headervalue.ibd > > > All values are "kb". Keep in mind, all results are depending on your > system :-) > > > HTH, > Uwe > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iQEVAwUBSJQWrNs3frmum9swAQKv/ggAtq697L3XFWOxdsTcvdmNsv/XBOU75m4H > uPmnIVAMKXP6kvQ19u+T1NQJl5jqb17t6nfhZ2JvxApkWbMR76edRESzKYHkXcEr > KF94XpV+MWwI7+vtTtDJcpHi3RmYfvtaikOYCd1BegVqd+GdIufICZXHQ5NAJXXg > CIQqik20ROQy95BEMy+D9JK2lPTvZ7bdglv6b1WF2yl1e8A0xm4IgQWzub9995H6 > iX6MfJLHnF3x21m2lgzQsFcuK8jGkQnF9h5LmQfvw2XfcrIDQuoB7Zk+OimkIE9Q > vuZ8yLWT2xiv0cwLq2z9NSGDSU9iTZaz2V3eouH3sHtfD35ZWP+NZg== > =Q4AD > -----END PGP SIGNATURE----- > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
