Author: paul
Date: 2007-04-25 22:34:49 +0200 (Wed, 25 Apr 2007)
New Revision: 6198
Log:
r19682@frost: paul | 2007-04-25 15:33:49 -0500
Cross reference the temp-table section to EXPLAIN.
Modified:
trunk/refman-4.1/optimization.xml
trunk/refman-5.0/optimization.xml
trunk/refman-5.1/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:24049
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:19663
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:24049
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:19682
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/refman-4.1/optimization.xml
===================================================================
--- trunk/refman-4.1/optimization.xml 2007-04-25 20:25:18 UTC (rev 6197)
+++ trunk/refman-4.1/optimization.xml 2007-04-25 20:34:49 UTC (rev 6198)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 788 bytes
@@ -8349,6 +8349,14 @@
</itemizedlist>
<para>
+ You can tell whether a query requires a temporary table by using
+ <literal>EXPLAIN</literal> and checking the
+ <literal>Extra</literal> column to see whether it says
+ <literal>Using temporary</literal>. See
+ <xref linkend="explain"/>.
+ </para>
+
+ <para>
Some conditions prevent the use of a <literal>MEMORY</literal>
temporary table, in which case the server uses a
<literal>MyISAM</literal> table instead:
Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml 2007-04-25 20:25:18 UTC (rev 6197)
+++ trunk/refman-5.0/optimization.xml 2007-04-25 20:34:49 UTC (rev 6198)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 790 bytes
@@ -10619,6 +10619,14 @@
</itemizedlist>
<para>
+ You can tell whether a query requires a temporary table by using
+ <literal>EXPLAIN</literal> and checking the
+ <literal>Extra</literal> column to see whether it says
+ <literal>Using temporary</literal>. See
+ <xref linkend="explain"/>.
+ </para>
+
+ <para>
Some conditions prevent the use of a <literal>MEMORY</literal>
temporary table, in which case the server uses a
<literal>MyISAM</literal> table instead:
Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml 2007-04-25 20:25:18 UTC (rev 6197)
+++ trunk/refman-5.1/optimization.xml 2007-04-25 20:34:49 UTC (rev 6198)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 790 bytes
@@ -10775,6 +10775,14 @@
</itemizedlist>
<para>
+ You can tell whether a query requires a temporary table by using
+ <literal>EXPLAIN</literal> and checking the
+ <literal>Extra</literal> column to see whether it says
+ <literal>Using temporary</literal>. See
+ <xref linkend="explain"/>.
+ </para>
+
+ <para>
Some conditions prevent the use of a <literal>MEMORY</literal>
temporary table, in which case the server uses a
<literal>MyISAM</literal> table instead:
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6198 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 25 Apr |
