List:Commits« Previous MessageNext Message »
From:paul.dubois Date:December 7 2010 7:11pm
Subject:svn commit - mysqldoc@docsrva: r24304 - in trunk: . dynamic-docs/command-optvars refman-5.6
View as plain text  
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&gt; <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.6paul.dubois7 Dec