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/20 19:37:37 UTC
[jira] [Commented] (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: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