Bug #38690 Obsolete info in the OPTIMIZE page
Submitted: 9 Aug 2008 11:51 Modified: 9 Aug 2008 16:56
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Aug 2008 11:51] Federico Razzoli
Description:
The page is:
http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

* In this page there are still info about BDB engine, which is no more supported:

"For BDB tables, OPTIMIZE TABLE currently is mapped to ANALYZE TABLE. See Section 12.5.2.1, “ANALYZE TABLE Syntax”. "

* Also, it talks about a bug which seems to be fixed in recent versions:

"OPTIMIZE TABLE does not sort R-tree indexes, such as spatial indexes on POINT columns. (Bug#23578)"

How to repeat:
read
[9 Aug 2008 14:47] Paul DuBois
BDB is deprecated, but still available in 5.0.

Reference to problems that have been fixed appear in various places throughout the manual.
[9 Aug 2008 16:56] Sveta Smirnova
Thank you for the report.

Paul is correct and BDB is still supported. Regarding to bug #23578 fix for this bug introduces limitation described. So manual is correct in both cases.