List:Commits« Previous MessageNext Message »
From:jon Date:September 2 2008 12:14pm
Subject:svn commit - mysqldoc@docsrva: r11633 - in trunk: dynamic-docs/changelog refman-5.1 refman-6.0
View as plain text  
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>


Thread
svn commit - mysqldoc@docsrva: r11633 - in trunk: dynamic-docs/changelog refman-5.1 refman-6.0jon2 Sep
  • Re: svn commit - mysqldoc@docsrva: r11633 - in trunk: dynamic-docs/changelogrefman-5.1 refman-6.0Mattias Jonsson2 Sep