From: jon
Date: November 5 2007 9:03pm
Subject: svn commit - mysqldoc@docsrva: r8543 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1 refman-6.0
List-Archive: http://lists.mysql.com/commits/37144
Message-Id: <200711052103.lA5L3Xf4019413@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2007-11-05 22:03:32 +0100 (Mon, 05 Nov 2007)
New Revision: 8543

Log:

Documented --log-slow-slave-statements and --min-examined-row-limit 
server options (Leith/PeterG)



Modified:
   trunk/dynamic-docs/changelog/mysqld.xml
   trunk/dynamic-docs/command-optvars/mysqld.xml
   trunk/refman-5.1/dba-core.xml
   trunk/refman-6.0/dba-core.xml


Modified: trunk/dynamic-docs/changelog/mysqld.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld.xml	2007-11-05 20:46:58 UTC (rev 8542)
+++ trunk/dynamic-docs/changelog/mysqld.xml	2007-11-05 21:03:32 UTC (rev 8543)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 0; 973 bytes

@@ -8,6 +8,29 @@
 
   <logentry entrytype="feature">
 
+    <versions>
+      <version ver="5.1.21"/>
+      <version ver="6.0.4"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Two options relating to logging have been added for
+        <command>mysqld</command>.
+        <literal>--log-slow-slave-statements</literal> causes slow
+        statements executed by a replication slave to the slow query
+        log; <literal>min_examined_row_limit</literal> can be used to
+        cause queries which examine less than the stated number of rows
+        not to be logged.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
     <bugs>
       <fixes bugid="25412"/>
     </bugs>


Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml	2007-11-05 20:46:58 UTC (rev 8542)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml	2007-11-05 21:03:32 UTC (rev 8543)
Changed blocks: 4, Lines Added: 89, Lines Deleted: 3; 3401 bytes

@@ -2907,8 +2907,9 @@
     <xrefto id="option_mysqld_Compression"/>
 
     <name>Compression</name>
-    <!--shouldn't this be session only?-->
-   
+
+<!--shouldn't this be session only?-->
+
     <shortdescription lang="en">
       Whether the client connection uses compression in the
       client/server protocol

@@ -10934,6 +10935,39 @@
 
   </mysqloption>
 
+  <mysqloption command="mysqld" section="server" id="log-slow-slave-statements">
+
+    <xrefto id="option_mysqld_log-slow-slave-statements"/>
+
+    <name>log-slow-slave-statements</name>
+
+    <shortdescription lang="en">
+      Cause slow statements as executed by the slave to be written to
+      the slow query log
+    </shortdescription>
+
+    <types>
+      <optype class="cmdline" format="--log-slow-slave-statements" setvar="log_slow_slave_statements"/>
+      <optype class="cmdline" format="--log-slow-slave-statements" setvar="log_slow_slave_statements"/>
+      <optype class="mycnf" outversion="5.1.21"/>
+      <vartype scope="both" isdynamic="no" class="system"/>
+    </types>
+
+    <values vartype="boolean" platform="all">
+
+      <value default="off"/>
+
+    </values>
+
+    <versions>
+      <manual version="5.1"/>
+      <introduced version="5.1.21"/>
+      <manual version="6.0"/>
+      <introduced version="6.0.4"/>
+    </versions>
+
+  </mysqloption>
+
   <mysqloption command="mysqld" section="server" id="log-tc">
 
     <xrefto id="option_mysqld_log-tc"/>

@@ -11071,13 +11105,34 @@
       <vartype isdynamic="yes" class="system" scope="both"/>
     </types>
 
-    <values vartype="numeric" platform="all">
+    <values vartype="numeric" platform="all" outversion="5.0.20">
 
       <value minimum="1"/>
       <value default="10"/>
 
     </values>
 
+    <values vartype="numeric" platform="all" inversion="5.1.21">
+
+      <value minimum="0"/>
+      <value default="10"/>
+
+    </values>
+
+    <values vartype="numeric" platform="all" outversion="6.0.3">
+
+      <value minimum="1"/>
+      <value default="10"/>
+
+    </values>
+
+    <values vartype="numeric" platform="all" inversion="6.0.4">
+
+      <value minimum="0"/>
+      <value default="10"/>
+
+    </values>
+
     <versions>
       <manual version="4.1"/>
       <manual version="5.0"/>

@@ -12343,6 +12398,37 @@
 
   </mysqloption>
 
+  <mysqloption command="mysqld" section="server" id="min-examined-row-limit">
+
+    <xrefto id="option_mysqld_min-examined-row-limit"/>
+
+    <name>min_examined_row_limit</name>
+
+    <shortdescription lang="en">
+      Queries examining fewer than this number of rows are not logged
+    </shortdescription>
+
+    <types>
+      <optype class="cmdline" format="--min-examined-row-limit=#" setvar="min_examined_row_limit"/>
+      <optype class="mycnf"/>
+      <vartype class="system" isdynamic="yes" scope="session"/>
+    </types>
+
+    <values vartype="numeric" platform="all">
+
+      <value default="0"/>
+
+    </values>
+
+    <versions>
+      <manual version="5.1"/>
+      <introduced version="5.1.21"/>
+      <manual version="6.0"/>
+      <introduced version="6.0.4"/>
+    </versions>
+
+  </mysqloption>
+
   <mysqloption command="mysqld" section="isam" id="skip-isam">
 
     <name>skip-isam</name>


Modified: trunk/refman-5.1/dba-core.xml
===================================================================
--- trunk/refman-5.1/dba-core.xml	2007-11-05 20:46:58 UTC (rev 8542)
+++ trunk/refman-5.1/dba-core.xml	2007-11-05 21:03:32 UTC (rev 8543)
Changed blocks: 2, Lines Added: 53, Lines Deleted: 0; 2372 bytes

@@ -1924,6 +1924,33 @@
           </listitem>
 
           <listitem>
+            <para id="option_mysqld_log-slow-slave-statements">
+              <indexterm>
+                <primary>mysqld</primary>
+                <secondary>log-slow-slave-statements option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>log-slow-slave-statements option</primary>
+                <secondary>mysqld</secondary>
+              </indexterm>
+
+              <option>--log-slow-slave-statements</option>
+            </para>
+
+            <para>
+              When the slow query log is enabled, this option enables
+              logging for queries that have taken more than
+              <literal>long_query_time</literal> seconds to execute on
+              the slave.
+            </para>
+
+            <para>
+              This option was added in MySQL 5.1.21.
+            </para>
+          </listitem>
+
+          <listitem>
             <para id="option_mysqld_log-tc">
               <indexterm>
                 <primary>mysqld</primary>

@@ -2032,6 +2059,32 @@
           </listitem>
 
           <listitem>
+            <para id="option_mysqld_min-examined-row-limit">
+              <indexterm>
+                <primary>mysqld</primary>
+                <secondary>min-examined-row-limit option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>min-examined-row-limit option</primary>
+                <secondary>mysqld</secondary>
+              </indexterm>
+
+              <option>--min-examined-row-limit=<replaceable>number</replaceable></option>
+            </para>
+
+            <para>
+              When this option is set, queries which examine fewer than
+              <replaceable>number</replaceable> rows are not written to
+              the query log. The default is 0.
+            </para>
+
+            <para>
+              This option was introduced in MySQL 5.1.21.
+            </para>
+          </listitem>
+
+          <listitem>
             <para id="option_mysqld_max-binlog-dump-events">
               <indexterm>
                 <primary>mysqld</primary>


Modified: trunk/refman-6.0/dba-core.xml
===================================================================
--- trunk/refman-6.0/dba-core.xml	2007-11-05 20:46:58 UTC (rev 8542)
+++ trunk/refman-6.0/dba-core.xml	2007-11-05 21:03:32 UTC (rev 8543)
Changed blocks: 2, Lines Added: 53, Lines Deleted: 0; 2370 bytes

@@ -1881,6 +1881,33 @@
           </listitem>
 
           <listitem>
+            <para id="option_mysqld_log-slow-slave-statements">
+              <indexterm>
+                <primary>mysqld</primary>
+                <secondary>log-slow-slave-statements option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>log-slow-slave-statements option</primary>
+                <secondary>mysqld</secondary>
+              </indexterm>
+
+              <option>--log-slow-slave-statements</option>
+            </para>
+
+            <para>
+              When the slow query log is enabled, this option enables
+              logging for queries that have taken more than
+              <literal>long_query_time</literal> seconds to execute on
+              the slave.
+            </para>
+
+            <para>
+              This option was added in MySQL 6.0.4.
+            </para>
+          </listitem>
+
+          <listitem>
             <para id="option_mysqld_log-tc">
               <indexterm>
                 <primary>mysqld</primary>

@@ -1990,6 +2017,32 @@
           </listitem>
 
           <listitem>
+            <para id="option_mysqld_min-examined-row-limit">
+              <indexterm>
+                <primary>mysqld</primary>
+                <secondary>min-examined-row-limit option</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>min-examined-row-limit option</primary>
+                <secondary>mysqld</secondary>
+              </indexterm>
+
+              <option>--min-examined-row-limit=<replaceable>number</replaceable></option>
+            </para>
+
+            <para>
+              When this option is set, queries which examine fewer than
+              <replaceable>number</replaceable> rows are not written to
+              the query log. The default is 0.
+            </para>
+
+            <para>
+              This option was introduced in MySQL 6.0.4.
+            </para>
+          </listitem>
+
+          <listitem>
             <para id="option_mysqld_max-binlog-dump-events">
               <indexterm>
                 <primary>mysqld</primary>