Author: paul
Date: 2010-12-07 20:11:09 +0100 (Tue, 07 Dec 2010)
New Revision: 24304
Log:
r45172@arctic: paul | 2010-12-07 12:16:42 -0600
Add initial info for WL#4674: PERFORMANCE_SCHEMA Setup For Actors
Modified:
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-5.6/performance-schema-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:45171
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:66486
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:45172
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:66486
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/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2010-12-07 19:11:01 UTC (rev 24303)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2010-12-07 19:11:09 UTC (rev 24304)
Changed blocks: 1, Lines Added: 27, Lines Deleted: 0; 1277 bytes
@@ -19181,6 +19181,33 @@
</mysqloption>
+ <mysqloption section="perfschema" id="performance_schema_setup_actors_size">
+
+ <xrefto id="sysvar_performance_schema_setup_actors_size"/>
+
+ <name>performance_schema_setup_actors_size</name>
+
+ <shortdescription lang="en">
+ The number of rows in SETUP_ACTORS
+ </shortdescription>
+
+ <types>
+ <optype class="mycnf" format="performance_schema_setup_actors_size=#" setvar="performance_schema_setup_actors_size"/>
+ <optype class="cmdline" format="--performance_schema_setup_actors_size=#" />
+ <vartype isdynamic="no" class="system" scope="global"/>
+ </types>
+
+ <values vartype="numeric" platform="all">
+ <value default="100"/>
+ </values>
+
+ <versions>
+ <manual version="5.6"/>
+ <introduced version="5.6.1"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption section="perfschema" id="Performance_schema_cond_classes_lost">
<xrefto id="statvar_Performance_schema_xxx_classes_lost"/>
Modified: trunk/refman-5.6/performance-schema-core.xml
===================================================================
--- trunk/refman-5.6/performance-schema-core.xml 2010-12-07 19:11:01 UTC (rev 24303)
+++ trunk/refman-5.6/performance-schema-core.xml 2010-12-07 19:11:09 UTC (rev 24304)
Changed blocks: 9, Lines Added: 193, Lines Deleted: 6; 6658 bytes
@@ -365,6 +365,7 @@
| MUTEX_INSTANCES |
| PERFORMANCE_TIMERS |
| RWLOCK_INSTANCES |
+| SETUP_ACTORS |
| SETUP_CONSUMERS |
| SETUP_INSTRUMENTS |
| SETUP_TIMERS |
@@ -968,6 +969,7 @@
| performance_schema_max_table_instances | 1000 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | 1000 |
+| performance_schema_setup_actors_size | 100 |
+---------------------------------------------------+---------+
</programlisting>
@@ -1026,6 +1028,7 @@
+-------------------+
| TABLE_NAME |
+-------------------+
+| SETUP_ACTORS |
| SETUP_CONSUMERS |
| SETUP_INSTRUMENTS |
| SETUP_TIMERS |
@@ -2537,6 +2540,7 @@
+-------------------+
| TABLE_NAME |
+-------------------+
+| SETUP_ACTORS |
| SETUP_CONSUMERS |
| SETUP_INSTRUMENTS |
| SETUP_TIMERS |
@@ -2544,6 +2548,58 @@
</programlisting>
<para>
+ The <literal>SETUP_ACTORS</literal> table lists information that
+ determines whether new threads are monitored:
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT * FROM SETUP_ACTORS;</userinput>
++------+------+------+
+| HOST | USER | ROLE |
++------+------+------+
+| % | % | % |
++------+------+------+
+</programlisting>
+
+ <para>
+ The <literal>SETUP_ACTORS</literal> table has these columns:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>HOST</literal>
+ </para>
+
+ <para>
+ The host name.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>USER</literal>
+ </para>
+
+ <para>
+ The user name.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ROLE</literal>
+ </para>
+
+ <para>
+ Unused.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
The <literal>SETUP_CONSUMERS</literal> table lists destination
tables for event information:
</para>
@@ -3701,6 +3757,30 @@
<listitem>
<para>
+ <literal>NAME</literal>
+ </para>
+
+ <para>
+ <literal>NAME</literal> is the name associated with the
+ instrumentation of the code in the server. For example,
+ <literal>thread/sql/one_connection</literal> corresponds to
+ the thread function in the code responsible for handling a
+ user connection.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>TYPE</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>PROCESSLIST_ID</literal>
</para>
@@ -3716,18 +3796,104 @@
<listitem>
<para>
- <literal>NAME</literal>
+ <literal>PROCESSLIST_USER</literal>
</para>
<para>
- <literal>NAME</literal> is the name associated with the
- instrumentation of the code in the server. For example,
- <literal>thread/sql/one_connection</literal> corresponds to
- the thread function in the code responsible for handling a
- user connection.
+ Need description.
</para>
</listitem>
+ <listitem>
+ <para>
+ <literal>PROCESSLIST_HOST</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PROCESSLIST_DB</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PROCESSLIST_COMMAND</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PROCESSLIST_TIME</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PROCESSLIST_STATE</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PROCESSLIST_INFO</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PARENT_THREAD_ID</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ROLE</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>INSTRUMENTED</literal>
+ </para>
+
+ <para>
+ Need description.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
@@ -3791,6 +3957,7 @@
| performance_schema_max_table_instances | 1000 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | 1000 |
+| performance_schema_setup_actors_size | 100 |
+---------------------------------------------------+---------+
</programlisting>
@@ -4144,6 +4311,26 @@
</para>
</listitem>
+ <listitem>
+ <para id="sysvar_performance_schema_setup_actors_size">
+ <indexterm>
+ <primary>performance_schema_setup_actors_size system variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>system variable</primary>
+ <secondary>performance_schema_setup_actors_size</secondary>
+ </indexterm>
+
+ <literal role="sysvar">performance_schema_setup_actors_size</literal>
+ </para>
+
+ <para>
+ The number of rows in the <literal>SETUP_ACTORS</literal>
+ table.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r24304 - in trunk: . dynamic-docs/command-optvars refman-5.6 | paul.dubois | 7 Dec |
