[
https://issues.apache.org/jira/browse/CONNECTORS-510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438022#comment-13438022
]
Karl Wright commented on CONNECTORS-510:
----------------------------------------
OPTIMIZE happens infrequently enough that it is probably comparable to VACUUM
in PostgreSQL, which basically means we give this functionality to the user to
set up. Apparently, REINDEX is not needed on MySQL indexes, so that's not a
problem either. Only ANALYZE seems to be a requirement on MySQL, then.
> 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
