Jorge,
You're cleaning out messages, but you're not reclaiming the table space.
In your first reply in this thread, you wrote:
> MySQL,
> Yes, nightly maintainance.
> ---
> /usr/local/sbin/dbmail-util -d -y
> /usr/local/sbin/dbmail-util -p -y
> /usr/local/sbin/dbmail-util -ty
> ---
You need to run 'dbmail-util -c' as well, which runs an ANALYZE TABLE
for each table. At this point, I recommend doing what everyone else is
saying you should do, which is to see how an ANALYZE performs on a
_backup_ copy of your database. Find out how long your tables will be
locked. Schedule a maintenance window on the real database once you
know how much time you need, and once you have a backup ready in case
something goes wrong.
Aaron
On Aug 2, 2008, at 8:38 AM, Jorge Bastos wrote:
Yes that that is not in case, 'cause i do maitainance.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Marc Dirix
Sent: sábado, 2 de Agosto de 2008 15:19
To: DBMail mailinglist
Subject: Re: [Dbmail] Db growing size
Yes but i have quota for all users, unless me.
So counting the maxmail_size for everyone, the db only could grow up
to that value of 22GB, not 65GB
This is not true, if you don't do maintainance.
(database, not dbmail)
_______________________________________________
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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
