List:Commits« Previous MessageNext Message »
From:paul.dubois Date:December 8 2010 8:41pm
Subject:svn commit - mysqldoc@docsrva: r24338 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-5.6
View as plain text  
Author: paul
Date: 2010-12-08 21:41:38 +0100 (Wed, 08 Dec 2010)
New Revision: 24338

Log:
 r36945@dhcp-215:  paul | 2010-12-08 14:34:49 -0500
 Initial information for: WL#4816: PERFORMANCE_SCHEMA Summaries


Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml
   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:45239
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
ebeeeee4-b232-4669-a521-231442eced53:/mysqldoc-local/mysqldoc/trunk:36943
   + 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:45239
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
ebeeeee4-b232-4669-a521-231442eced53:/mysqldoc-local/mysqldoc/trunk:36945


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2010-12-08 19:53:11 UTC (rev 24337)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2010-12-08 20:41:38 UTC (rev 24338)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 3; 818 bytes

@@ -33638,9 +33638,10 @@
 
       <para>
         If you upgrade to MySQL 5.5.8 from an earlier version of MySQL
-        5.5, be sure to run <command>mysql_upgrade</command> to change
-        the names of existing <literal>performance_schema</literal>
-        tables from uppercase to lowercase.
+        5.5, be sure to run <command>mysql_upgrade</command> (and
+        restart the server) to change the names of existing
+        <literal>performance_schema</literal> tables from uppercase to
+        lowercase.
       </para>
 
     </message>


Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml	2010-12-08 19:53:11 UTC (rev 24337)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml	2010-12-08 20:41:38 UTC (rev 24338)
Changed blocks: 4, Lines Added: 30, Lines Deleted: 3; 2037 bytes

@@ -18738,7 +18738,7 @@
     <name>performance_schema_events_waits_history_long_size</name>
 
     <shortdescription lang="en">
-      The number of rows in EVENTS_WAITS_HISTORY_LONG
+      The number of rows in events_waits_history_long
     </shortdescription>
 
     <types>

@@ -18768,7 +18768,7 @@
     <name>performance_schema_events_waits_history_size</name>
 
     <shortdescription lang="en">
-      The number of rows in EVENTS_WAITS_HISTORY
+      The number of rows in events_waits_history
     </shortdescription>
 
     <types>

@@ -19188,7 +19188,7 @@
     <name>performance_schema_setup_actors_size</name>
 
     <shortdescription lang="en">
-      The number of rows in SETUP_ACTORS
+      The number of rows in setup_actors
     </shortdescription>
 
     <types>

@@ -19208,6 +19208,33 @@
 
   </mysqloption>
 
+  <mysqloption section="perfschema" id="performance_schema_setup_objects_size">
+
+    <xrefto id="sysvar_performance_schema_setup_objects_size"/>
+
+    <name>performance_schema_setup_objects_size</name>
+
+    <shortdescription lang="en">
+      The number of rows in setup_objects
+    </shortdescription>
+
+    <types>
+      <optype class="mycnf" format="performance_schema_setup_objects_size=#" setvar="performance_schema_setup_objects_size"/>
+      <optype class="cmdline" format="--performance_schema_setup_objects_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-08 19:53:11 UTC (rev 24337)
+++ trunk/refman-5.6/performance-schema-core.xml	2010-12-08 20:41:38 UTC (rev 24338)
Changed blocks: 12, Lines Added: 124, Lines Deleted: 38; 9073 bytes

@@ -363,11 +363,13 @@
 | file_summary_by_event_name                   |
 | file_summary_by_instance                     |
 | mutex_instances                              |
+| objects_summary_global_by_type               |
 | performance_timers                           |
 | rwlock_instances                             |
 | setup_actors                                 |
 | setup_consumers                              |
 | setup_instruments                            |
+| setup_objects                                |
 | setup_timers                                 |
 | threads                                      |
 +----------------------------------------------+

@@ -700,18 +702,15 @@
 
 <programlisting>
 mysql&gt; <userinput>SELECT * FROM setup_consumers;</userinput>
-+----------------------------------------------+---------+
-| NAME                                         | ENABLED |
-+----------------------------------------------+---------+
-| events_waits_current                         | YES     |
-| events_waits_history                         | YES     |
-| events_waits_history_long                    | YES     |
-| events_waits_summary_by_thread_by_event_name | YES     |
-| events_waits_summary_by_event_name           | YES     |
-| events_waits_summary_by_instance             | YES     |
-| file_summary_by_event_name                   | YES     |
-| file_summary_by_instance                     | YES     |
-+----------------------------------------------+---------+
++---------------------------+---------+
+| NAME                      | ENABLED |
++---------------------------+---------+
+| events_waits_current      | YES     |
+| events_waits_history      | YES     |
+| events_waits_history_long | YES     |
+| global_instrumentation    | YES     |
+| thread_instrumentation    | YES     |
++---------------------------+---------+
 </programlisting>
 
     <para>

@@ -971,6 +970,7 @@
 | performance_schema_max_thread_classes             | 50      |
 | performance_schema_max_thread_instances           | 1000    |
 | performance_schema_setup_actors_size              | 100     |
+| performance_schema_setup_objects_size             | 100     |
 +---------------------------------------------------+---------+
 </programlisting>
 

@@ -1032,6 +1032,7 @@
 | setup_actors      |
 | setup_consumers   |
 | setup_instruments |
+| setup_objects     |
 | setup_timers      |
 +-------------------+
 </programlisting>

@@ -1163,18 +1164,15 @@
 
 <programlisting>
 mysql&gt; <userinput>SELECT * FROM setup_consumers;</userinput>
-+----------------------------------------------+---------+
-| NAME                                         | ENABLED |
-+----------------------------------------------+---------+
-| events_waits_current                         | YES     |
-| events_waits_history                         | YES     |
-| events_waits_history_long                    | YES     |
-| events_waits_summary_by_thread_by_event_name | YES     |
-| events_waits_summary_by_event_name           | YES     |
-| events_waits_summary_by_instance             | YES     |
-| file_summary_by_event_name                   | YES     |
-| file_summary_by_instance                     | YES     |
-+----------------------------------------------+---------+
++---------------------------+---------+
+| NAME                      | ENABLED |
++---------------------------+---------+
+| events_waits_current      | YES     |
+| events_waits_history      | YES     |
+| events_waits_history_long | YES     |
+| global_instrumentation    | YES     |
+| thread_instrumentation    | YES     |
++---------------------------+---------+
 </programlisting>
         </listitem>
 

@@ -2544,6 +2542,7 @@
 | setup_actors      |
 | setup_consumers   |
 | setup_instruments |
+| setup_objects     |
 | setup_timers      |
 +-------------------+
 </programlisting>

@@ -2607,18 +2606,15 @@
 
 <programlisting>
 mysql&gt; <userinput>SELECT * FROM setup_consumers;</userinput>
-+----------------------------------------------+---------+
-| NAME                                         | ENABLED |
-+----------------------------------------------+---------+
-| events_waits_current                         | YES     |
-| events_waits_history                         | YES     |
-| events_waits_history_long                    | YES     |
-| events_waits_summary_by_thread_by_event_name | YES     |
-| events_waits_summary_by_event_name           | YES     |
-| events_waits_summary_by_instance             | YES     |
-| file_summary_by_event_name                   | YES     |
-| file_summary_by_instance                     | YES     |
-+----------------------------------------------+---------+
++---------------------------+---------+
+| NAME                      | ENABLED |
++---------------------------+---------+
+| events_waits_current      | YES     |
+| events_waits_history      | YES     |
+| events_waits_history_long | YES     |
+| global_instrumentation    | YES     |
+| thread_instrumentation    | YES     |
++---------------------------+---------+
 </programlisting>
 
       <para>

@@ -2747,6 +2743,77 @@
       </itemizedlist>
 
       <para>
+        The <literal>setup_objects</literal> table lists information
+        about which objects are monitored:
+      </para>
+
+<programlisting>
+mysql&gt; <userinput>SELECT * FROM setup_objects;</userinput>
++-------------+---------------+-------------+-------+
+| OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | TIMED |
++-------------+---------------+-------------+-------+
+| TABLE       | %             | %           | YES   |
++-------------+---------------+-------------+-------+
+</programlisting>
+
+      <para>
+        The presence of a row in <literal>setup_objects</literal>
+        indicates that instrumentation should be enabled for events that
+        occur on the object or objects identified by the row.
+      </para>
+
+      <para>
+        The <literal>setup_objects</literal> table has these columns:
+      </para>
+
+      <itemizedlist>
+
+        <listitem>
+          <para>
+            <literal>OBJECT_TYPE</literal>
+          </para>
+
+          <para>
+            The type of object to instrument. Currently, this is always
+            <literal>'TABLE'</literal> (base table).
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            <literal>OBJECT_SCHEMA</literal>
+          </para>
+
+          <para>
+            The schema that contains the object. The value
+            <literal>'%'</literal> means <quote>any schema.</quote>
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            <literal>OBJECT_NAME</literal>
+          </para>
+
+          <para>
+            The name of the instrumented object. The value
+            <literal>'%'</literal> means <quote>any object.</quote>
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            <literal>TIMED</literal>
+          </para>
+
+          <para>
+            Whether the instrument is timed.
+          </para>
+        </listitem>
+
+      </itemizedlist>
+
+      <para>
         The <literal>setup_timers</literal> table shows the currently
         selected event timer:
       </para>

@@ -3181,6 +3248,7 @@
 | events_waits_summary_global_by_event_name    |
 | file_summary_by_event_name                   |
 | file_summary_by_instance                     |
+| objects_summary_global_by_type               |
 +----------------------------------------------+
 </programlisting>
 

@@ -3202,7 +3270,8 @@
 
       <para>
         <literal>events_waits_summary_by_<replaceable>xxx</replaceable></literal>
-        tables have these columns in common:
+        tables and the <literal>objects_summary_global_by_type</literal>
+        table have these columns in common:
       </para>
 
       <itemizedlist>

@@ -3268,7 +3337,8 @@
       <para>
         The remaining columns in the
         <literal>events_waits_summary_by_<replaceable>xxx</replaceable></literal>
-        tables indicate how events were aggregated:
+        and <literal>objects_summary_global_by_type</literal> tables
+        indicate how events were aggregated:
       </para>
 
       <itemizedlist>

@@ -3308,9 +3378,25 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            <literal>events_waits_summary_by_thread_by_event_name</literal>
+            has <literal>OBJECT_TYPE</literal>,
+            <literal>OBJECT_SCHEMA</literal>, and
+            <literal>OBJECT_NAME</literal> columns. Each row summaries
+            events for the given object.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
       <para>
+        The remaining columns in the
+        <literal>objects_summary_global_by_type</literal> table indicate
+        how events were aggregated:
+      </para>
+
+      <para>
         <literal>file_summary_by_<replaceable>xxx</replaceable></literal>
         tables have these columns in common:
       </para>


Thread
svn commit - mysqldoc@docsrva: r24338 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-5.6paul.dubois8 Dec