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> <userinput>ALTER TABLE clients COALESCE PARTITION 6;</userinput>
+mysql> <userinput>ALTER TABLE clients COALESCE PARTITION 4;</userinput>
Query OK, 0 rows affected (0.02 sec)
</programlisting>
@@ -3125,10 +3125,17 @@
-> <userinput>PARTITIONS 12;</userinput>
Query OK, 0 rows affected (0.03 sec)
-mysql> <userinput>ALTER TABLE clients_lk COALESCE PARTITION 6;</userinput>
+mysql> <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 — 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.1 | jon | 13 Jun |