The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=482 ====================================================================== Reported By: paul Assigned To: paul ====================================================================== Project: DBMail Issue ID: 482 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: assigned target: ====================================================================== Date Submitted: 01-Jan-07 17:05 CET Last Modified: 01-Jan-07 17:05 CET ====================================================================== Summary: use ANALYZE TABLE instead of OPTIMIZE TABLE in mysql driver Description:
Optimize table does a full table lock while copying the whole table. This is overkill given the intended purpose. Analyze table serves the same purpose taking less time and requires only a read lock. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 01-Jan-07 17:05 paul New Issue 01-Jan-07 17:05 paul Status new => assigned 01-Jan-07 17:05 paul Assigned To => paul ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
