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