Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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.