The following issue has been ASSIGNED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=858 ====================================================================== Reported By: rcsheets Assigned To: paul ====================================================================== Project: DBMail Issue ID: 858 Category: Documentation Reproducibility: N/A Severity: minor Priority: normal Status: assigned target: ====================================================================== Date Submitted: 06-Sep-10 03:19 CEST Last Modified: 07-Sep-10 02:40 CEST ====================================================================== Summary: dbmail-util man page misrepresents -c option Description: The dbmail-util man page says the -c option will "Clean up unlinked message entries" but dbmail-util -h says "clean up database (optimize/vacuum)" which seems to be closer to reality. ======================================================================
---------------------------------------------------------------------- (0003107) netvulture (developer) - 07-Sep-10 02:40 http://www.dbmail.org/mantis/view.php?id=858#c3107 ---------------------------------------------------------------------- Both the man page and dbmail-util -h help screens are misleading. -c actually does nothing at all but print a message on the screen. Has been this way for quite a while both in 2.2.x and 2.3.x. The reason it no longer does anything is because we have moved from MyISAM to InnoDB on the MySQL side that does not require an OPTIMIZE TABLE x to reuse allocated space. While a VACUUM x on Postgres would be something to run from time to time, each command is different between the databases, and the MySQL OPTIMIZE TABLE actually locks the table like that of a Postgres VACUUM FULL x. Dbmail is trying to stay away from any code that checks what database type is in use and changes the query required. I'm not sure what we should do with the -c option. Lets wait for Paul to chime in. Issue History Date Modified Username Field Change ====================================================================== 06-Sep-10 03:19 rcsheets New Issue 07-Sep-10 02:40 netvulture Note Added: 0003107 07-Sep-10 02:40 netvulture Status new => assigned 07-Sep-10 02:40 netvulture Assigned To => paul ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev