Thanks, Its a great blog Did you use "received" header just as an example in the blog, or is it really safe to delete it from the cache, received header has the biggest number in the table, besides that I see a lots of x- headers in the table which I think are safe to remove.
----- Original Message ---- From: Paul J Stevens <[email protected]> To: DBMail mailinglist <[email protected]> Sent: Sat, February 13, 2010 2:20:45 AM Subject: Re: [Dbmail] dbmail_headervalue N Sj wrote: > In our dbmail environment dbmail_headervalue > table has become very large and DBA is recommending running optimize table. > Then I ran into a thread in dbmail archives that if the table > dbmail_headervalue is dropped and recreated then it will get re-populated by > running "dbmail-util -by", if that is possible then should we run OPTIMIZE > TABLE or just drop and recreate the table. Dropping, re-creating and re-populating the table is a valid procedure. However, you will end up with the same sized table. I've blogged about a better approach on blog.dbmail.eu. > > Also we run "dbmail-util- a -y -vv" every night. > > Thank you for your input. > > > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
