[
https://issues.apache.org/jira/browse/CONNECTORS-510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438018#comment-13438018
]
Karl Wright commented on CONNECTORS-510:
----------------------------------------
For OPTIMIZE, MySQL has the ability to re-use freed tuples, so I expect that
the number of removes/updates that need to be done before this operation is
required will be fairly large (e.g. 250000 or so).
> 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
