Author: paul
Date: 2010-03-12 13:58:23 +0100 (Fri, 12 Mar 2010)
New Revision: 19518
Log:
r56774@frost: paul | 2010-03-11 13:22:53 -0500
Minor Performance Schema revisions
Modified:
trunk/refman-5.5/manual.xml
trunk/refman-5.5/performance-schema.xml
trunk/refman-6.0/manual.xml
trunk/refman-6.0/performance-schema.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:37390
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:56773
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:37390
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:56774
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/refman-5.5/manual.xml
===================================================================
--- trunk/refman-5.5/manual.xml 2010-03-12 12:58:17 UTC (rev 19517)
+++ trunk/refman-5.5/manual.xml 2010-03-12 12:58:23 UTC (rev 19518)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 625 bytes
@@ -98,7 +98,7 @@
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="information-schema.xml"/>
- <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="performance-schema.xml"/>
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="dynxml-local-performance-schema.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="connectors-apis.xml"/>
Modified: trunk/refman-5.5/performance-schema.xml
===================================================================
--- trunk/refman-5.5/performance-schema.xml 2010-03-12 12:58:17 UTC (rev 19517)
+++ trunk/refman-5.5/performance-schema.xml 2010-03-12 12:58:23 UTC (rev 19518)
Changed blocks: 6, Lines Added: 36, Lines Deleted: 17; 4740 bytes
@@ -7,6 +7,8 @@
<title>MySQL Performance Schema</title>
+ <remark role="dynamic-dependency-list"/>
+
<indexterm>
<primary>Performance Schema</primary>
</indexterm>
@@ -3716,11 +3718,11 @@
<title>Performance Schema and Plugins</title>
<para>
- Information collected for code in a plugin is not affected by
- removing the plugin with <literal role="stmt">UNINSTALL
- PLUGIN</literal>. Time spent executing code in the plugin was
- still spent even if the plugin is unloaded later, and the
- associated event information (including aggregate information)
+ Removing the plugin with <literal role="stmt">UNINSTALL
+ PLUGIN</literal> does not affect information already collected for
+ code in the plugin. Time spent executing the code while the plugin
+ was loaded was still spent even if the plugin is unloaded later.
+ The associated event information, including aggregate information,
remains readable in <literal>performance_schema</literal> database
tables. For additional information about the effect of plugin
installation and removal, see
@@ -3781,6 +3783,10 @@
+---------------------------------------------------+--------+
</programlisting>
+ <para condition="dynamic:optvar:fullsummary" role="5.5:mysqld:section-perfschema">
+ <citetitle>Performance Schema Variable Reference</citetitle>
+ </para>
+
<para>
The variables have the following meanings:
</para>
@@ -3805,7 +3811,7 @@
The value of this variable is <literal>ON</literal> or
<literal>OFF</literal> to indicate whether Performance Schema
is enabled. By default, the value is <literal>OFF</literal>.
- You can specify this variable at server startup with no value
+ At server startup, you can specify this variable with no value
or a value of 1 to enable it, or with a value of 0 to disable
it.
</para>
@@ -3927,9 +3933,10 @@
</para>
<para>
+ The value of
<literal role="sysvar">performance_schema_max_file_handles</literal>
- should be greater than the
- <literal role="sysvar">open_files_limit</literal> value:
+ should be greater than the value of
+ <literal role="sysvar">open_files_limit</literal>:
<literal role="sysvar">open_files_limit</literal> affects the
maximum number of open file handles the server can support and
<literal role="sysvar">performance_schema_max_file_handles</literal>
@@ -4169,33 +4176,45 @@
<itemizedlist>
<listitem>
- <para>
+ <para id="statvar_Performance_schema_xxx_classes_lost">
<literal>Performance_schema_<replaceable>xxx</replaceable>_classes_lost</literal>
- indicates how many instruments of type
- <replaceable>xxx</replaceable> could not be loaded.
</para>
+
+ <para>
+ How many instruments of type <replaceable>xxx</replaceable>
+ could not be loaded.
+ </para>
</listitem>
<listitem>
+ <para id="statvar_Performance_schema_xxx_instances_lost">
+ <literal>Performance_schema_<replaceable>xxx</replaceable>_instances_lost</literal>
+ </para>
+
<para>
- <literal>Performance_schema_<replaceable>xxx</replaceable>_instances_lost</literal>
- indicates how many instances of object type
+ How many instances of object type
<replaceable>xxx</replaceable> could not be created.
</para>
</listitem>
<listitem>
+ <para id="statvar_Performance_schema_xxx_handles_lost">
+ <literal>Performance_schema_<replaceable>xxx</replaceable>_handles_lost</literal>
+ </para>
+
<para>
- <literal>Performance_schema_<replaceable>xxx</replaceable>_handles_lost</literal>
- indicates how many instances of object type
+ How many instances of object type
<replaceable>xxx</replaceable> could not be opened.
</para>
</listitem>
<listitem>
+ <para id="statvar_Performance_schema_locker_lost">
+ <literal>Performance_schema_locker_lost</literal>
+ </para>
+
<para>
- <literal>Performance_schema_locker_lost</literal> indicates
- how many events are <quote>lost</quote> or not recorded, due
+ How many events are <quote>lost</quote> or not recorded, due
to the following conditions:
</para>
Modified: trunk/refman-6.0/manual.xml
===================================================================
--- trunk/refman-6.0/manual.xml 2010-03-12 12:58:17 UTC (rev 19517)
+++ trunk/refman-6.0/manual.xml 2010-03-12 12:58:23 UTC (rev 19518)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 625 bytes
@@ -94,7 +94,7 @@
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="information-schema.xml"/>
- <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="performance-schema.xml"/>
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="dynxml-local-performance-schema.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="connectors-apis.xml"/>
Modified: trunk/refman-6.0/performance-schema.xml
===================================================================
--- trunk/refman-6.0/performance-schema.xml 2010-03-12 12:58:17 UTC (rev 19517)
+++ trunk/refman-6.0/performance-schema.xml 2010-03-12 12:58:23 UTC (rev 19518)
Changed blocks: 6, Lines Added: 36, Lines Deleted: 17; 4740 bytes
@@ -7,6 +7,8 @@
<title>MySQL Performance Schema</title>
+ <remark role="dynamic-dependency-list"/>
+
<indexterm>
<primary>Performance Schema</primary>
</indexterm>
@@ -3716,11 +3718,11 @@
<title>Performance Schema and Plugins</title>
<para>
- Information collected for code in a plugin is not affected by
- removing the plugin with <literal role="stmt">UNINSTALL
- PLUGIN</literal>. Time spent executing code in the plugin was
- still spent even if the plugin is unloaded later, and the
- associated event information (including aggregate information)
+ Removing the plugin with <literal role="stmt">UNINSTALL
+ PLUGIN</literal> does not affect information already collected for
+ code in the plugin. Time spent executing the code while the plugin
+ was loaded was still spent even if the plugin is unloaded later.
+ The associated event information, including aggregate information,
remains readable in <literal>performance_schema</literal> database
tables. For additional information about the effect of plugin
installation and removal, see
@@ -3781,6 +3783,10 @@
+---------------------------------------------------+--------+
</programlisting>
+ <para condition="dynamic:optvar:fullsummary" role="6.0:mysqld:section-perfschema">
+ <citetitle>Performance Schema Variable Reference</citetitle>
+ </para>
+
<para>
The variables have the following meanings:
</para>
@@ -3805,7 +3811,7 @@
The value of this variable is <literal>ON</literal> or
<literal>OFF</literal> to indicate whether Performance Schema
is enabled. By default, the value is <literal>OFF</literal>.
- You can specify this variable at server startup with no value
+ At server startup, you can specify this variable with no value
or a value of 1 to enable it, or with a value of 0 to disable
it.
</para>
@@ -3927,9 +3933,10 @@
</para>
<para>
+ The value of
<literal role="sysvar">performance_schema_max_file_handles</literal>
- should be greater than the
- <literal role="sysvar">open_files_limit</literal> value:
+ should be greater than the value of
+ <literal role="sysvar">open_files_limit</literal>:
<literal role="sysvar">open_files_limit</literal> affects the
maximum number of open file handles the server can support and
<literal role="sysvar">performance_schema_max_file_handles</literal>
@@ -4169,33 +4176,45 @@
<itemizedlist>
<listitem>
- <para>
+ <para id="statvar_Performance_schema_xxx_classes_lost">
<literal>Performance_schema_<replaceable>xxx</replaceable>_classes_lost</literal>
- indicates how many instruments of type
- <replaceable>xxx</replaceable> could not be loaded.
</para>
+
+ <para>
+ How many instruments of type <replaceable>xxx</replaceable>
+ could not be loaded.
+ </para>
</listitem>
<listitem>
+ <para id="statvar_Performance_schema_xxx_instances_lost">
+ <literal>Performance_schema_<replaceable>xxx</replaceable>_instances_lost</literal>
+ </para>
+
<para>
- <literal>Performance_schema_<replaceable>xxx</replaceable>_instances_lost</literal>
- indicates how many instances of object type
+ How many instances of object type
<replaceable>xxx</replaceable> could not be created.
</para>
</listitem>
<listitem>
+ <para id="statvar_Performance_schema_xxx_handles_lost">
+ <literal>Performance_schema_<replaceable>xxx</replaceable>_handles_lost</literal>
+ </para>
+
<para>
- <literal>Performance_schema_<replaceable>xxx</replaceable>_handles_lost</literal>
- indicates how many instances of object type
+ How many instances of object type
<replaceable>xxx</replaceable> could not be opened.
</para>
</listitem>
<listitem>
+ <para id="statvar_Performance_schema_locker_lost">
+ <literal>Performance_schema_locker_lost</literal>
+ </para>
+
<para>
- <literal>Performance_schema_locker_lost</literal> indicates
- how many events are <quote>lost</quote> or not recorded, due
+ How many events are <quote>lost</quote> or not recorded, due
to the following conditions:
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r19518 - in trunk: . refman-5.5 refman-6.0 | paul.dubois | 12 Mar 2010 |
