MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon Date:June 13 2006 3:49pm
Subject:svn commit - mysqldoc@docsrva: r2364 - trunk/refman-5.1
View as plain text  
Author: jstephens
Date: 2006-06-13 17:49:14 +0200 (Tue, 13 Jun 2006)
New Revision: 2364

Log:
Fixe for Docs Bug #20409 (PeterG/Mikael)

Modified:
   trunk/refman-5.1/partitioning.xml

Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2006-06-13 14:40:20 UTC (rev 2363)
+++ trunk/refman-5.1/partitioning.xml	2006-06-13 15:49:14 UTC (rev 2364)
@@ -3096,12 +3096,12 @@
 </programlisting>
 
       <para>
-        To reduce the number of partitions from twelve to six, execute
+        To reduce the number of partitions from twelve to eight, execute
         the following <literal>ALTER TABLE</literal> command:
       </para>
 
 <programlisting>
-mysql&gt; <userinput>ALTER TABLE clients COALESCE PARTITION 6;</userinput>
+mysql&gt; <userinput>ALTER TABLE clients COALESCE PARTITION 4;</userinput>
 Query OK, 0 rows affected (0.02 sec)
 </programlisting>
 
@@ -3125,10 +3125,17 @@
     -&gt; <userinput>PARTITIONS 12;</userinput>
 Query OK, 0 rows affected (0.03 sec)
 
-mysql&gt; <userinput>ALTER TABLE clients_lk COALESCE PARTITION 6;</userinput>
+mysql&gt; <userinput>ALTER TABLE clients_lk COALESCE PARTITION 4;</userinput>
 Query OK, 0 rows affected (0.06 sec)
 Records: 0  Duplicates: 0  Warnings: 0
 </programlisting>
+      
+      <para>
+        Note that the number following <literal>COALESCE
+          PARTITION</literal> is the number of partitions to merge into
+        the remainder &mdash; in other words, it is the number of
+        partitions to remove from the table. 
+      </para>
 
       <para>
         <literal>COALESCE</literal> cannot be used to increase the

Thread
svn commit - mysqldoc@docsrva: r2364 - trunk/refman-5.1jon13 Jun