svn commit - mysqldoc@docsrva: r801 - in trunk: . refman-5.1

[paul]

Author: paul
Date: 2006-01-13 05:36:53 +0100 (Fri, 13 Jan 2006)
New Revision: 801

Log:
 r6161@frost:  paul | 2006-01-12 22:36:43 -0600
 New ARCHIVE feature.


Modified:
   trunk/
   trunk/refman-5.1/storage-engines.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6159
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2101
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6161
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2101

Modified: trunk/refman-5.1/storage-engines.xml
===================================================================
--- trunk/refman-5.1/storage-engines.xml	2006-01-13 04:32:44 UTC (rev 800)
+++ trunk/refman-5.1/storage-engines.xml	2006-01-13 04:36:53 UTC (rev 801)
@@ -3776,6 +3776,19 @@
     </para>
 
     <para>
+      As of MySQL 5.1.6, the <literal>ARCHIVE</literal> engine ignores
+      <literal>BLOB</literal> columns if they are not requested and
+      scans past them while reading. Formerly, the following two
+      statements had the same cost, but as of 5.1.6, the second is much
+      more efficient than the first:
+    </para>
+
+<programlisting>
+SELECT a, b, blob_col FROM archive_table;
+SELECT a, b FROM archive_table;
+</programlisting>
+
+    <para>
       <emphasis role="bold">Storage:</emphasis> Rows are compressed as
       they are inserted. The <literal>ARCHIVE</literal> engine uses
       <literal>zlib</literal> lossless data compression (see