Author: paul
Date: 2007-03-16 18:49:22 +0100 (Fri, 16 Mar 2007)
New Revision: 5422
Log:
r17863@frost: paul | 2007-03-16 12:48:26 -0500
Document the innodb_stats_on_metadata system variable. (Bug#26598)
Modified:
trunk/dynamic-docs/mysqld-optvar/options.xml
trunk/mysqld-optvars/options.xml
trunk/refman-5.1/news-5.1.xml
trunk/refman-5.1/se-innodb.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:21582
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:17861
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:21582
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:17863
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/dynamic-docs/mysqld-optvar/options.xml
===================================================================
--- trunk/dynamic-docs/mysqld-optvar/options.xml 2007-03-16 17:12:49 UTC (rev 5421)
+++ trunk/dynamic-docs/mysqld-optvar/options.xml 2007-03-16 17:49:22 UTC (rev 5422)
Changed blocks: 1, Lines Added: 18, Lines Deleted: 0; 1205 bytes
@@ -4833,6 +4833,24 @@
<manual version="4.1"/>
</versions>
</option>
+ <option command="mysqld" section="innodb" id="innodb_stats_on_metadata">
+ <xrefto id="optvar_innodb_stats_on_metadata"/>
+ <name>innodb_stats_on_metadata</name>
+ <shortdescription lang="en">Enable or disable InnoDB table statistics updates for metadata statements</shortdescription>
+ <types>
+ <optype class="cmdline" format="--innodb_stats_on_metadata"
+ setvar="innodb_stats_on_metadata"/>
+ <optype class="mycnf"/>
+ <vartype isdynamic="no" class="server"/>
+ </types>
+ <values vartype="boolean" platform="all">
+ <value default="ON"/>
+ </values>
+ <versions>
+ <manual version="5.1"/>
+ <introduced version="5.1.17"/>
+ </versions>
+ </option>
<option command="mysqld" section="innodb" id="innodb_status_file">
<xrefto id="optvar_innodb_status_file"/>
<!-- checked -->
Modified: trunk/mysqld-optvars/options.xml
===================================================================
--- trunk/mysqld-optvars/options.xml 2007-03-16 17:12:49 UTC (rev 5421)
+++ trunk/mysqld-optvars/options.xml 2007-03-16 17:49:22 UTC (rev 5422)
Changed blocks: 1, Lines Added: 22, Lines Deleted: 0; 1254 bytes
@@ -5507,6 +5507,28 @@
<manual version="4.1"/>
</versions>
</mysqloption>
+ <mysqloption id="innodb_stats_on_metadata">
+ <xrefto id="optvar_innodb_stats_on_metadata"/>
+ <name>innodb_stats_on_metadata</name>
+ <shortdescription lang="en">Enable or disable InnoDB table statistics updates for metadata statements</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms applies="all"/>
+ <types>
+ <optype class="cmdline" format="--innodb_stats_on_metadata"
+ setvar="innodb_stats_on_metadata"/>
+ <optype class="mycnf"/>
+ <vartype isdynamic="no" class="server"/>
+ </types>
+ <values vartype="boolean" platform="all">
+ <value default="ON"/>
+ </values>
+ <versions>
+ <manual version="5.1"/>
+ <introduced version="5.1.17"/>
+ </versions>
+ </mysqloption>
<mysqloption id="innodb_status_file">
<xrefto id="optvar_innodb_status_file"/>
<name>innodb_status_file</name>
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2007-03-16 17:12:49 UTC (rev 5421)
+++ trunk/refman-5.1/news-5.1.xml 2007-03-16 17:49:22 UTC (rev 5422)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1345 bytes
@@ -177,6 +177,16 @@
<listitem>
<para>
+ Added the <literal>innodb_stats_on_metadata</literal> system
+ variable to enable control over whether
+ <literal>InnoDB</literal> performs statistics gathering when
+ metadata statements are executed. See
+ <xref linkend="innodb-parameters"/>. (Bug #26598)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
The server now includes a timestamp in error messages logged
as a result of unhandled signals (such as <literal>mysqld got
signal 11</literal> messages). (Bug #24878)
@@ -242,9 +252,9 @@
<listitem>
<para>
If a thread previously serviced a connection that was killed,
- excessive memory and CPU use by the thread occurred if it later
- serviced a connection that had to wait for a table lock. (Bug
- #25966)
+ excessive memory and CPU use by the thread occurred if it
+ later serviced a connection that had to wait for a table lock.
+ (Bug #25966)
</para>
</listitem>
Modified: trunk/refman-5.1/se-innodb.xml
===================================================================
--- trunk/refman-5.1/se-innodb.xml 2007-03-16 17:12:49 UTC (rev 5421)
+++ trunk/refman-5.1/se-innodb.xml 2007-03-16 17:49:22 UTC (rev 5422)
Changed blocks: 2, Lines Added: 29, Lines Deleted: 2; 2129 bytes
@@ -1656,6 +1656,33 @@
</listitem>
<listitem>
+ <para id="optvar_innodb_stats_on_metadata">
+ <literal>innodb_stats_on_metadata</literal>
+ </para>
+
+ <para>
+ When this variable is enabled (which is the default, as before
+ the variable was created), <literal>InnoDB</literal> updates
+ statistics during metadata statements such as <literal>SHOW
+ TABLE STATUS</literal> or <literal>SHOW INDEX</literal>, or
+ when accessing the <literal>INFORMATION_SCHEMA</literal>
+ tables <literal>TABLES</literal> or
+ <literal>STATISTICS</literal>. (These updates are similar to
+ what happens for <literal>ANALYZE TABLE</literal>.) When
+ disabled, <literal>InnoDB</literal> does not updates
+ statistics during these operations. Disabling this variable
+ can improve access speed for schemas that have a large nmber
+ of tables or indexes. In can also improved the stability of
+ output for <literal>EXPLAIN</literal> for queries that involve
+ <literal>InnoDB</literal> tables.
+ </para>
+
+ <para>
+ This variable was added in MySQL 5.1.17.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="optvar_innodb_support_xa">
<literal>innodb_support_xa</literal>
</para>
@@ -2860,8 +2887,8 @@
at all. MySQL replication is based on the binary log where MySQL
writes SQL statements that modify data. A transaction that fails
(for example, because of a foreign key violation, or because it
- is rolled back) is not written to the binary log, so it is
- not sent to slaves. See <xref linkend="commit"/>.
+ is rolled back) is not written to the binary log, so it is not
+ sent to slaves. See <xref linkend="commit"/>.
</para>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5422 - in trunk: . dynamic-docs/mysqld-optvar mysqld-optvars refman-5.1 | paul | 16 Mar |
