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.6 | paul.dubois | 22 Nov |
