Karl Wright created CONNECTORS-510:
--------------------------------------

             Summary: 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


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

        

Reply via email to