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.
Also we run "dbmail-util- a -y -vv" every night.
Thank you for your input.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
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.
Also we run "dbmail-util- a -y -vv" every night.
Thank you for your input.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail