I'm already using innodb_file_per_table, In fact it's my default for my MySQL Servers.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Peter Rabbitson > Sent: sexta-feira, 1 de Agosto de 2008 22:32 > To: DBMail mailinglist > Subject: Re: [Dbmail] Db growing size > > Jorge Bastos wrote: > > Hi Paul, > > > > > > > > In 2.3x version, with the new database design, the size that the > > database has, its not the real size. > > > > I have now 52GB of DB Size, but comparing with the email that is > stored > > in this very moment: > > > > SELECT round((sum(curmail_size)/1024)/1024,2) FROM dbmail_users ; > > > > Result: > > > > 8648.34 > > > > Wich mean that I have currently about 8,5GB of email. > > > > > > > > Is there something to tune this? > > > > Is there a special reason for this huge size? > > > > In case you are using the standard innodb pool - yes. The pool never > shrinks, > and unless you "defragment" it, it will keep growing. In order to avoid > this > situation it is very advisable to use > http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
