svn commit - mysqldoc@docsrva: r2157 - in trunk: . refman-5.0 refman-5.1 refman-common

[paul]

Author: paul
Date: 2006-05-22 20:06:46 +0200 (Mon, 22 May 2006)
New Revision: 2157

Log:
 r7517@kite-hub:  paul | 2006-05-22 13:04:50 -0500
 Document log_queries_not_using_indexes system variable. (Bug#19616)


Modified:
   trunk/
   trunk/refman-5.0/database-administration.xml
   trunk/refman-5.1/database-administration.xml
   trunk/refman-common/news-5.0.xml
   trunk/refman-common/news-5.1.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7689
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10590
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:5310
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7689
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10590
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:7517

Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml	2006-05-22 16:41:03 UTC (rev 2156)
+++ trunk/refman-5.0/database-administration.xml	2006-05-22 18:06:46 UTC (rev 2157)
@@ -4756,6 +4756,18 @@
 
           <listitem>
             <para>
+              <literal>log_queries_not_using_indexes</literal>
+            </para>
+
+            <para>
+              Whether queries that do not use indexes are logged to the
+              slow query log. See <xref linkend="slow-query-log"/>. This
+              variable was added in MySQL 5.0.22.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
               <literal>log_slave_updates</literal>
             </para>
 
@@ -7688,6 +7700,11 @@
                   <entry><literal>GLOBAL</literal></entry>
                 </row>
                 <row>
+                 
<entry><literal>log_queries_not_using_indexes</literal></entry>
+                  <entry>boolean</entry>
+                  <entry><literal>GLOBAL</literal></entry>
+                </row>
+                <row>
                   <entry><literal>log_warnings</literal></entry>
                   <entry>numeric</entry>
                   <entry><literal>GLOBAL</literal></entry>

Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml	2006-05-22 16:41:03 UTC (rev 2156)
+++ trunk/refman-5.1/database-administration.xml	2006-05-22 18:06:46 UTC (rev 2157)
@@ -5113,6 +5113,18 @@
 
           <listitem>
             <para>
+              <literal>log_queries_not_using_indexes</literal>
+            </para>
+
+            <para>
+              Whether queries that do not use indexes are logged to the
+              slow query log. See <xref linkend="slow-query-log"/>. This
+              variable was added in MySQL 5.1.11.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
               <literal>log_slave_updates</literal>
             </para>
 
@@ -8089,6 +8101,11 @@
                   <entry><literal>GLOBAL</literal></entry>
                 </row>
                 <row>
+                 
<entry><literal>log_queries_not_using_indexes</literal></entry>
+                  <entry>boolean</entry>
+                  <entry><literal>GLOBAL</literal></entry>
+                </row>
+                <row>
                   <entry><literal>log_warnings</literal></entry>
                   <entry>numeric</entry>
                   <entry><literal>GLOBAL</literal></entry>

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2006-05-22 16:41:03 UTC (rev 2156)
+++ trunk/refman-common/news-5.0.xml	2006-05-22 18:06:46 UTC (rev 2157)
@@ -231,6 +231,13 @@
 
       <listitem>
         <para>
+          Added the <literal>log_queries_not_using_indexes</literal>
+          system variable. (Bug#19616)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The <literal>ONLY_FULL_GROUP_BY</literal> SQL mode now also
           applies to the <literal>HAVING</literal> clause. That is,
           columns not named in the <literal>GROUP BY</literal> clause

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2006-05-22 16:41:03 UTC (rev 2156)
+++ trunk/refman-common/news-5.1.xml	2006-05-22 18:06:46 UTC (rev 2157)
@@ -86,6 +86,13 @@
 
       <listitem>
         <para>
+          Added the <literal>log_queries_not_using_indexes</literal>
+          system variable. (Bug#19616)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           To prevent inadvertant loss of data, <literal>ALTER
           TABLE</literal> can no longer be used to change the storage
           engine of a table to <literal>MERGE</literal> or