svn commit - mysqldoc@docsrva: r8384 - in trunk: dynamic-docs/changelog refman-5.1 refman-5.2

[jon]

Author: jstephens
Date: 2007-10-29 16:06:09 +0100 (Mon, 29 Oct 2007)
New Revision: 8384

Log:

Documented fix for Partitioning Bug #26527



Modified:
   trunk/dynamic-docs/changelog/mysqld.xml
   trunk/refman-5.1/partitioning.xml
   trunk/refman-5.1/sql-syntax.xml
   trunk/refman-5.2/partitioning.xml
   trunk/refman-5.2/sql-syntax.xml


Modified: trunk/dynamic-docs/changelog/mysqld.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld.xml	2007-10-29 13:04:47 UTC (rev 8383)
+++ trunk/dynamic-docs/changelog/mysqld.xml	2007-10-29 15:06:09 UTC (rev 8384)
Changed blocks: 2, Lines Added: 29, Lines Deleted: 1; 1307 bytes

@@ -9,6 +9,33 @@
   <logentry entrytype="bug">
 
     <tags>
+      <manual type="partition"/>
+      <manual type="LOAD DATA"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="26527"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.23"/>
+      <version ver="6.0.4"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <literal>LOAD DATA INFILE</literal> ran very slowly when reading
+        large files into partitioned tables.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
       <manual type="replication"/>
       <manual type="cluster"/>
       <highlight type="clusterreplication"/>

@@ -20499,7 +20526,8 @@
         <command>mysql_install_db</command> created the
         <filename>mysql_install_db.X</filename> file with a predictable
         filename and insecure permissions, which allowed local users to
-        execute arbitrary SQL statements by modifying the file's contents.
+        execute arbitrary SQL statements by modifying the file's
+        contents.
       </para>
 
     </message>


Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2007-10-29 13:04:47 UTC (rev 8383)
+++ trunk/refman-5.1/partitioning.xml	2007-10-29 15:06:09 UTC (rev 8384)
Changed blocks: 1, Lines Added: 16, Lines Deleted: 0; 914 bytes

@@ -4703,6 +4703,22 @@
         </formalpara>
       </listitem>
 
+      <listitem>
+        <formalpara>
+
+          <title>Performance with <literal>LOAD
DATA</literal></title>
+
+          <para>
+            Prior to MySQL 5.1.23, <literal>LOAD DATA</literal>
+            performed very poorly when importing into partitioned
+            tables. The statement now uses buffering to improve
+            performance; however, the buffer uses 130 KB memory per
+            partition to achieve this. (Bug #26527)
+          </para>
+
+        </formalpara>
+      </listitem>
+
     </itemizedlist>
 
     <section id="partitioning-limitations-partitioning-keys-unique-keys">


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-10-29 13:04:47 UTC (rev 8383)
+++ trunk/refman-5.1/sql-syntax.xml	2007-10-29 15:06:09 UTC (rev 8384)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 863 bytes

@@ -7694,6 +7694,16 @@
         even if no other thread is using the table at the same time.
       </para>
 
+      <note>
+        <para>
+          Prior to MySQL 5.1.23, <literal>LOAD DATA</literal> performed
+          very poorly when importing into partitioned tables. The
+          statement now uses buffering to improve performance; however,
+          the buffer uses 130 KB memory per partition to achieve this.
+          (Bug #26527)
+        </para>
+      </note>
+
       <para>
         The <literal>LOCAL</literal> keyword, if specified, is
         interpreted with respect to the client end of the connection:


Modified: trunk/refman-5.2/partitioning.xml
===================================================================
--- trunk/refman-5.2/partitioning.xml	2007-10-29 13:04:47 UTC (rev 8383)
+++ trunk/refman-5.2/partitioning.xml	2007-10-29 15:06:09 UTC (rev 8384)
Changed blocks: 1, Lines Added: 16, Lines Deleted: 0; 914 bytes

@@ -4595,6 +4595,22 @@
         </formalpara>
       </listitem>
 
+      <listitem>
+        <formalpara>
+
+          <title>Performance with <literal>LOAD
DATA</literal></title>
+
+          <para>
+            Prior to MySQL 5.1.23, <literal>LOAD DATA</literal>
+            performed very poorly when importing into partitioned
+            tables. The statement now uses buffering to improve
+            performance; however, the buffer uses 130 KB memory per
+            partition to achieve this. (Bug #26527)
+          </para>
+
+        </formalpara>
+      </listitem>
+
     </itemizedlist>
 
     <section id="partitioning-limitations-partitioning-keys-unique-keys">


Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml	2007-10-29 13:04:47 UTC (rev 8383)
+++ trunk/refman-5.2/sql-syntax.xml	2007-10-29 15:06:09 UTC (rev 8384)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 862 bytes

@@ -7632,6 +7632,16 @@
         even if no other thread is using the table at the same time.
       </para>
 
+      <note>
+        <para>
+          Prior to MySQL 6.0.4, <literal>LOAD DATA</literal> performed
+          very poorly when importing into partitioned tables. The
+          statement now uses buffering to improve performance; however,
+          the buffer uses 130 KB memory per partition to achieve this.
+          (Bug #26527)
+        </para>
+      </note>
+
       <para>
         The <literal>LOCAL</literal> keyword, if specified, is
         interpreted with respect to the client end of the connection: