Going to do that test. Dbmail-util -cy doesn't reduce the size of the db, in fact it run's in about 10 seconds
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Aaron Stone > Sent: sábado, 2 de Agosto de 2008 18:27 > To: DBMail mailinglist > Subject: Re: [Dbmail] Db growing size > > 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 _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
