You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (JIRA)" <ji...@apache.org> on 2012/08/21 04:01:38 UTC
[jira] [Resolved] (CONNECTORS-510) MySQL database driver needs to
periodically analyze and optimize
[ https://issues.apache.org/jira/browse/CONNECTORS-510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-510.
------------------------------------
Resolution: Fixed
Fix Version/s: ManifoldCF 0.7
> MySQL database driver needs to periodically analyze and optimize
> ----------------------------------------------------------------
>
> Key: CONNECTORS-510
> URL: https://issues.apache.org/jira/browse/CONNECTORS-510
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework core
> Reporter: Karl Wright
> Assignee: Karl Wright
> Fix For: ManifoldCF 0.7
>
>
> MySQL also accumulates bad statistics and dead tuples, much like PostgreSQL. It therefore needs logic in place which re-analyzes the stats and cleans out the dead tuples. The MySQL commands that do this are:
> ANALYZE <table>
> OPTIMIZE <table>
> No idea how often this needs to be done yet.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira