Jorge Bastos wrote:
> Hi Paul,
> 
>  
> 
> In 2.3x version, with the new database design, the size that the
> database has, it’s 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

Reply via email to