svn commit - mysqldoc@docsrva: r2767 - in trunk: . refman-4.1 refman-5.0

[paul]

Author: paul
Date: 2006-07-18 21:30:36 +0200 (Tue, 18 Jul 2006)
New Revision: 2767

Log:


Modified:
   trunk/refman-4.1/client-utility-programs.xml
   trunk/refman-5.0/client-utility-programs.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:11558
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:12342
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:8441
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:11558
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:12366
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:8441


Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml	2006-07-18 19:26:22 UTC (rev 2766)
+++ trunk/refman-4.1/client-utility-programs.xml	2006-07-18 19:30:36 UTC (rev 2767)
Changed blocks: 7, Lines Added: 67, Lines Deleted: 1; 4009 bytes

@@ -5858,6 +5858,12 @@
         </para>
 
         <para>
+          The results may assist you in determining which queries result
+          in table scans and where it would be beneficial to add indexes
+          to your tables.
+        </para>
+
+        <para>
           Invoke <command>mysql_explain_log</command> like this, where
           <replaceable>log_file</replaceable> contains all or part of a
           MySQL query log:

@@ -5876,6 +5882,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>date option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>date option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--date=<replaceable>YYMMDD</replaceable></option>,
               <option>-d
<replaceable>YYMMDD</replaceable></option>
             </para>

@@ -5887,6 +5903,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>host option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>host option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--host=<replaceable>host_name</replaceable></option>,
               <option>-h
<replaceable>host_name</replaceable></option>
             </para>

@@ -5898,6 +5924,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>password option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>password option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--password=<replaceable>password</replaceable></option>,
              
<option>-p<replaceable>password</replaceable></option>
             </para>

@@ -5915,7 +5951,17 @@
 
           <listitem>
             <para>
-              <option>--printerror</option>, <option>-e</option>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>printerror option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>printerror option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
+              <option>--printerror=1</option>, <option>-e
1</option>
             </para>
 
             <para>

@@ -5925,6 +5971,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>socket option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>socket option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--socket=<replaceable>path</replaceable></option>,
               <option>-S <replaceable>path</replaceable></option>
             </para>

@@ -5938,6 +5994,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>user option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>user option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--user=<replaceable>user_name</replaceable></option>,
               <option>-u
<replaceable>user_name</replaceable></option>
             </para>


Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml	2006-07-18 19:26:22 UTC (rev 2766)
+++ trunk/refman-5.0/client-utility-programs.xml	2006-07-18 19:30:36 UTC (rev 2767)
Changed blocks: 7, Lines Added: 67, Lines Deleted: 1; 4009 bytes

@@ -5719,6 +5719,12 @@
         </para>
 
         <para>
+          The results may assist you in determining which queries result
+          in table scans and where it would be beneficial to add indexes
+          to your tables.
+        </para>
+
+        <para>
           Invoke <command>mysql_explain_log</command> like this, where
           <replaceable>log_file</replaceable> contains all or part of a
           MySQL query log:

@@ -5737,6 +5743,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>date option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>date option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--date=<replaceable>YYMMDD</replaceable></option>,
               <option>-d
<replaceable>YYMMDD</replaceable></option>
             </para>

@@ -5748,6 +5764,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>host option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>host option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--host=<replaceable>host_name</replaceable></option>,
               <option>-h
<replaceable>host_name</replaceable></option>
             </para>

@@ -5759,6 +5785,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>password option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>password option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--password=<replaceable>password</replaceable></option>,
              
<option>-p<replaceable>password</replaceable></option>
             </para>

@@ -5776,7 +5812,17 @@
 
           <listitem>
             <para>
-              <option>--printerror</option>, <option>-e</option>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>printerror option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>printerror option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
+              <option>--printerror=1</option>, <option>-e
1</option>
             </para>
 
             <para>

@@ -5786,6 +5832,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>socket option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>socket option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--socket=<replaceable>path</replaceable></option>,
               <option>-S <replaceable>path</replaceable></option>
             </para>

@@ -5799,6 +5855,16 @@
 
           <listitem>
             <para>
+              <indexterm>
+                <primary>mysql_explain_log</primary>
+                <secondary>user option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>user option</primary>
+                <secondary>mysql_explain_log</secondary>
+              </indexterm>
+
              
<option>--user=<replaceable>user_name</replaceable></option>,
               <option>-u
<replaceable>user_name</replaceable></option>
             </para>