Author: jdrussel
Date: 2011-03-29 23:25:42 +0200 (Tue, 29 Mar 2011)
New Revision: 25613
Log:
Trim down the innodb_stats_on_metadata exposition,
put the important info like purpose first, don't repeat info like when it first appeared.
Modified:
trunk/innodb-1.1/innodb-other-changes.xml
Modified: trunk/innodb-1.1/innodb-other-changes.xml
===================================================================
--- trunk/innodb-1.1/innodb-other-changes.xml 2011-03-29 21:17:10 UTC (rev 25612)
+++ trunk/innodb-1.1/innodb-other-changes.xml 2011-03-29 21:25:42 UTC (rev 25613)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 16; 1957 bytes
@@ -208,23 +208,13 @@
</indexterm>
<para>
- As noted in
- <xref
- linkend="innodb-other-changes-statistics-estimation"/>,
- you can control how InnoDB gathers information about the number
- of distinct values in an index key. A related parameter,
- <literal role="sysvar">innodb_stats_on_metadata</literal>, has
- existed since MySQL release 5.1.17 to control whether or not
- InnoDB performs statistics gathering when metadata statements
- are executed. See <xref linkend="innodb-parameters"/> for
- details.
- </para>
-
- <para>
- Beginning with release InnoDB 1.0.2, you can change the setting
- of <literal
+ In MySQL 5.5 and higher, you can change the setting of
+ <literal
role="sysvar">innodb_stats_on_metadata</literal>
- dynamically at runtime with the statement <literal>SET GLOBAL
+ dynamically at runtime, to control whether or not InnoDB
+ performs statistics gathering when metadata statements are
+ executed. To change the setting, issue the statement
+ <literal>SET GLOBAL
innodb_stats_on_metadata=<replaceable>mode</replaceable></literal>,
where <literal><replaceable>mode</replaceable></literal> is
either <literal>ON</literal> or <literal>OFF</literal> (or
@@ -233,6 +223,12 @@
immediately affects the operation of all connections.
</para>
+ <para>
+ This setting is related to the feature described in
+ <xref
+ linkend="innodb-other-changes-statistics-estimation"/>.
+ </para>
+
</section>
<section id="innodb-other-changes-innodb_lock_wait_timeout">
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r25613 - trunk/innodb-1.1 | john.russell | 29 Mar |
