List:Commits« Previous MessageNext Message »
From:paul.dubois Date:November 22 2010 12:22am
Subject:svn commit - mysqldoc@docsrva: r23896 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-5.6
View as plain text  
Author: paul
Date: 2010-11-22 01:22:52 +0100 (Mon, 22 Nov 2010)
New Revision: 23896

Log:
 r44497@arctic:  paul | 2010-11-21 13:32:23 -0600
 5.6 has optimizer_join_cache_level


Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml
   trunk/dynamic-docs/command-optvars/mysqld.xml
   trunk/refman-5.6/dba-mysqld-server-core.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:44467
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:65842
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
   + 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:44497
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:65842
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2010-11-20 23:35:48 UTC (rev 23895)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2010-11-22 00:22:52 UTC (rev 23896)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 407 bytes

@@ -24007,6 +24007,7 @@
     </bugs>
 
     <versions>
+      <version ver="5.6.1"/>
       <version ver="6.0.14"/>
     </versions>
 


Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml	2010-11-20 23:35:48 UTC (rev 23895)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml	2010-11-22 00:22:52 UTC (rev 23896)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 458 bytes

@@ -18410,6 +18410,7 @@
     </values>
 
     <versions>
+      <manual version="5.6"/>
       <manual version="6.0"/>
       <introduced version="6.0.14"/>
     </versions>


Modified: trunk/refman-5.6/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.6/dba-mysqld-server-core.xml	2010-11-20 23:35:48 UTC (rev 23895)
+++ trunk/refman-5.6/dba-mysqld-server-core.xml	2010-11-22 00:22:52 UTC (rev 23896)
Changed blocks: 1, Lines Added: 102, Lines Deleted: 0; 4752 bytes

@@ -7864,6 +7864,108 @@
       </listitem>
 
       <listitem>
+        <para id="sysvar_optimizer_join_cache_level">
+          <indexterm>
+            <primary>optimizer_join_cache_level system variable</primary>
+          </indexterm>
+
+          <indexterm>
+            <primary>system variable</primary>
+            <secondary>optimizer_join_cache_level</secondary>
+          </indexterm>
+
+          <literal role="sysvar">optimizer_join_cache_level</literal>
+        </para>
+
+        <para condition="dynamic:optvar:item" role="6.0:mysqld:optimizer_join_cache_level"/>
+
+        <para>
+          This variable is used for join buffer managment. It controls
+          for which join operations of which types join buffers are
+          supposed to be used.
+
+<!--
+ See
+          <xref linkend="bnl-bka-optimization"/>.
+-->
+
+          The following table shows the permissible
+          <literal role="sysvar">optimizer_join_cache_level</literal>
+          values.
+        </para>
+
+        <informaltable>
+          <tgroup cols="2">
+            <colspec colwidth="15*"/>
+            <colspec colwidth="70*"/>
+            <thead>
+              <row>
+                <entry>Option</entry>
+                <entry>Description</entry>
+              </row>
+            </thead>
+            <tbody>
+              <row>
+                <entry><literal>0</literal></entry>
+                <entry>No join buffer is used for any join operation. This setting can be
+                  useful for assessing baseline join performance in
+                  comparison to performance with nonzero values that
+                  enable use of join buffering.</entry>
+              </row>
+              <row>
+                <entry><literal>1</literal></entry>
+                <entry>This is the default value. Join buffers are employed exactly in the same
+                  cases as in versions of MySQL prior to 6.0.9: They are
+                  used only for inner joins that are executed by the
+                  original Block Nested-Loop (BNL) join algorithm. When
+                  this algorithm is applied, rows of the inner table are
+                  accessed through a table scan, a plain index scan, or
+                  a range index scan.</entry>
+              </row>
+              <row>
+                <entry><literal>2</literal></entry>
+                <entry>The server employs an incremental join buffer for a join operation if
+                  its first operand is produced by a join operation that
+                  uses a join buffer itself.</entry>
+              </row>
+              <row>
+                <entry><literal>3</literal></entry>
+                <entry>The BNL algorithm is used for an outer join and semi-join operation with
+                  one inner table, and for inner joins.</entry>
+              </row>
+              <row>
+                <entry><literal>4</literal></entry>
+                <entry>The BNL algorithm uses incremental buffers for inner tables. In this
+                  case, the BNL algorithm can be used for nested outer
+                  joins and semi-joins (outer joins and semi-joins with
+                  several inner tables). Such an operation can be
+                  executed only if incremental join buffers are used to
+                  join all inner tables but the first one.</entry>
+              </row>
+              <row>
+                <entry><literal>5</literal></entry>
+                <entry>The BKA algorithm uses regular buffers for any join operation with index
+                  access to the joined table.</entry>
+              </row>
+              <row>
+                <entry><literal>6</literal></entry>
+                <entry>The BKA algorithm uses incremental buffers for any join operation with
+                  index access to the joined table.</entry>
+              </row>
+              <row>
+                <entry><literal>7</literal></entry>
+                <entry>The BKA algorithm uses regular join buffers with a hash table.</entry>
+              </row>
+              <row>
+                <entry><literal>8</literal></entry>
+                <entry>The BKA algorithm uses incremental join buffers with a hash table.</entry>
+              </row>
+            </tbody>
+          </tgroup>
+        </informaltable>
+      </listitem>
+
+      <listitem>
         <para id="sysvar_optimizer_prune_level">
           <indexterm>
             <primary>optimizer_prune_level system variable</primary>


Thread
svn commit - mysqldoc@docsrva: r23896 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-5.6paul.dubois22 Nov