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