Author: jstephens
Date: 2008-09-02 14:14:31 +0200 (Tue, 02 Sep 2008)
New Revision: 11633
Log:
Documented new fix for Partitioning Bug #20129:
ANALYZE|CHECK|OPTIMIZE|REPAIR TABLE supported with partitioned tables
in 5.1.27+/6.0.7+.
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/refman-5.1/partitioning.xml
trunk/refman-5.1/sql-syntax-data-definition.xml
trunk/refman-6.0/partitioning.xml
trunk/refman-6.0/sql-syntax-data-definition.xml
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-08-30 02:18:16 UTC (rev 11632)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-09-02 12:14:31 UTC (rev 11633)
Changed blocks: 2, Lines Added: 40, Lines Deleted: 1; 1785 bytes
@@ -3799,9 +3799,11 @@
<versions>
<version ver="5.1.24"/>
<version ver="6.0.5"/>
+ <version ver="5.1.27"/>
+ <version ver="6.0.7"/>
</versions>
- <message>
+ <message ver="5.1.24,6.0.5">
<para>
The following statements did not function correctly with
@@ -3843,6 +3845,43 @@
</message>
+ <message ver="5.1.27,6.0.7">
+
+ <para>
+ The statements <literal>ANALYZE TABLE</literal>, <literal>CHECK
+ TABLE</literal>, <literal>OPTIMIZE TABLE</literal>, and
+ <literal>REPAIR TABLE</literal> are now supported for
+ partitioned tables.
+ </para>
+
+ </message>
+
+ <message ver="5.1.27">
+
+ <para>
+ This restores functionality missing since the removal of
+ <literal>ALTER TABLE ... ANALYZE PARTITION</literal>,
+ <literal>ALTER TABLE ... CHECK PARTITION</literal>,
+ <literal>ALTER TABLE ... OPTIMIZE PARTITION</literal>, and
+ <literal>ALTER TABLE ... REPAIR PARTITION</literal> in MySQL
+ 5.1.24.
+ </para>
+
+ </message>
+
+ <message ver="6.0.7">
+
+ <para>
+ This restores functionality missing since the removal of
+ <literal>ALTER TABLE ... ANALYZE PARTITION</literal>,
+ <literal>ALTER TABLE ... CHECK PARTITION</literal>,
+ <literal>ALTER TABLE ... OPTIMIZE PARTITION</literal>, and
+ <literal>ALTER TABLE ... REPAIR PARTITION</literal> in MySQL
+ 6.0.5.
+ </para>
+
+ </message>
+
</logentry>
<logentry entrytype="bug">
Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml 2008-08-30 02:18:16 UTC (rev 11632)
+++ trunk/refman-5.1/partitioning.xml 2008-09-02 12:14:31 UTC (rev 11633)
Changed blocks: 1, Lines Added: 15, Lines Deleted: 9; 1892 bytes
@@ -4918,19 +4918,25 @@
<para>
The statements <literal>CHECK TABLE</literal>,
<literal>OPTIMIZE TABLE</literal>, <literal>ANALYZE
- TABLE</literal>, and <literal>REPAIR TABLE</literal> are not
- supported for partitioned tables.
+ TABLE</literal>, and <literal>REPAIR TABLE</literal> are
+ supported for partitioned tables beginning with MySQL
+ 5.1.27. Also in MySQL 5.1.27 and later,
<command>mysqlcheck</command> and
- <command>myisamchk</command> are also not supported for
- partitioned tables. However, you can use <literal>ALTER
- TABLE ... REBUILD PARTITION</literal> to rebuild one or more
- partitions of a partitioned table; <literal>ALTER TABLE ...
- REORGANIZE PARTITION</literal> also causes partitions to be
- rebuilt. See <xref linkend="alter-table"/>, for more
- information about these two statements.
+ <command>myisamchk</command> are supported with partitioned.
+ (See Bug #20129.)
</para>
</formalpara>
+
+ <para>
+ In addition, you can use <literal>ALTER TABLE ... REBUILD
+ PARTITION</literal> to rebuild one or more partitions of a
+ partitioned table; <literal>ALTER TABLE ... REORGANIZE
+ PARTITION</literal> also causes partitions to be rebuilt. Both
+ of these statements were added in MySQL 5.1.5. See
+ <xref linkend="alter-table"/>, for more information about
+ these two statements.
+ </para>
</listitem>
</itemizedlist>
Modified: trunk/refman-5.1/sql-syntax-data-definition.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-data-definition.xml 2008-08-30 02:18:16 UTC (rev 11632)
+++ trunk/refman-5.1/sql-syntax-data-definition.xml 2008-09-02 12:14:31 UTC (rev 11633)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 892 bytes
@@ -1794,6 +1794,17 @@
and <literal>REPAIR PARTITION</literal> options were removed
in MySQL 5.1.24.
</para>
+
+ <note>
+ <para>
+ Beginning with MySQL 5.1.27, you can use the statements
+ <literal>ANALYZE TABLE</literal>, <literal>CHECK
+ TABLE</literal>, <literal>OPTIMIZE TABLE</literal>, and
+ <literal>REPAIR TABLE</literal> on partitioned tables. See
+ <xref linkend="table-maintenance-sql"/>, for more
+ information.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-6.0/partitioning.xml
===================================================================
--- trunk/refman-6.0/partitioning.xml 2008-08-30 02:18:16 UTC (rev 11632)
+++ trunk/refman-6.0/partitioning.xml 2008-09-02 12:14:31 UTC (rev 11633)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 10; 1869 bytes
@@ -4824,19 +4824,23 @@
<para>
The statements <literal>CHECK TABLE</literal>,
<literal>OPTIMIZE TABLE</literal>, <literal>ANALYZE
- TABLE</literal>, and <literal>REPAIR TABLE</literal> are not
- supported for partitioned tables.
- <command>mysqlcheck</command> and
- <command>myisamchk</command> are also not supported for
- partitioned tables. However, you can use <literal>ALTER
- TABLE ... REBUILD PARTITION</literal> to rebuild one or more
- partitions of a partitioned table; <literal>ALTER TABLE ...
- REORGANIZE PARTITION</literal> also causes partitions to be
- rebuilt. See <xref linkend="alter-table"/>, for more
- information about these two statements.
+ TABLE</literal>, and <literal>REPAIR TABLE</literal> are
+ supported for partitioned tables beginning with MySQL 6.0.7.
+ Also in MySQL 6.0.7 and later, <command>mysqlcheck</command>
+ and <command>myisamchk</command> are supported with
+ partitioned tables. (See Bug #20129.)
</para>
</formalpara>
+
+ <para>
+ In addition, you can use <literal>ALTER TABLE ... REBUILD
+ PARTITION</literal> to rebuild one or more partitions of a
+ partitioned table; <literal>ALTER TABLE ... REORGANIZE
+ PARTITION</literal> also causes partitions to be rebuilt. See
+ <xref linkend="alter-table"/>, for more information about
+ these two statements.
+ </para>
</listitem>
</itemizedlist>
Modified: trunk/refman-6.0/sql-syntax-data-definition.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-data-definition.xml 2008-08-30 02:18:16 UTC (rev 11632)
+++ trunk/refman-6.0/sql-syntax-data-definition.xml 2008-09-02 12:14:31 UTC (rev 11633)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 3; 1204 bytes
@@ -1540,10 +1540,19 @@
The <literal>ANALYZE PARTITION</literal>, <literal>CHECK
PARTITION</literal>, <literal>OPTIMIZE PARTITION</literal>,
and <literal>REPAIR PARTITION</literal> options were removed
- in MySQL 6.0.5. We intend to reintroduce them (or replace them
- with similar statement providing similar functionality) in a
- future MySQL release.
+ in MySQL 6.0.5.
</para>
+
+ <note>
+ <para>
+ Beginning with MySQL 6.0.7, you can use the statements
+ <literal>ANALYZE TABLE</literal>, <literal>CHECK
+ TABLE</literal>, <literal>OPTIMIZE TABLE</literal>, and
+ <literal>REPAIR TABLE</literal> on partitioned tables. See
+ <xref linkend="table-maintenance-sql"/>, for more
+ information.
+ </para>
+ </note>
</listitem>
<listitem>
