List:Commits« Previous MessageNext Message »
From:paul.dubois Date:May 3 2011 6:30pm
Subject:svn commit - mysqldoc@oter02: r26113 - in trunk: . refman-5.5 refman-5.6 refman-6.0
View as plain text  
Author: pd221994
Date: 2011-05-03 20:30:23 +0200 (Tue, 03 May 2011)
New Revision: 26113

Log:
 r47674@dhcp-adc-twvpn-1-vpnpool-10-154-25-17:  paul | 2011-05-03 08:53:19 -0500
 Mention which sysvars control the size of which P_S tables


Modified:
   svk:merge
   trunk/refman-5.5/performance-schema-core.xml
   trunk/refman-5.6/performance-schema-core.xml
   trunk/refman-6.0/performance-schema-core.xml

Property changes on: trunk
___________________________________________________________________

Modified: svk:merge
===================================================================


Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 1277 bytes


Modified: trunk/refman-5.5/performance-schema-core.xml
===================================================================
--- trunk/refman-5.5/performance-schema-core.xml	2011-05-03 14:22:58 UTC (rev 26112)
+++ trunk/refman-5.5/performance-schema-core.xml	2011-05-03 18:30:23 UTC (rev 26113)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 8; 1879 bytes

@@ -3784,10 +3784,12 @@
 
         <para>
           The <literal role="ps">events_waits_history</literal> table
-          contains the most recent 10 wait events per thread. As new
-          events are added to this table, older events are discarded if
-          the table is full. Events are not added to the table until
-          they have ended.
+          contains the most recent 10 wait events per thread. The table
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_events_waits_history_size</literal>
+          system variable at server startup. As new events are added to
+          the table, older events are discarded if the table is full.
+          Events are not added to the table until they have ended.
         </para>
 
         <para>

@@ -3821,10 +3823,12 @@
 
         <para>
           The <literal role="ps">events_waits_history_long</literal>
-          table contains the most recent 10,000 wait events. As new
-          events are added to this table, older events are discarded if
-          the table is full. Events are not added to the table until
-          they have ended.
+          table contains the most recent 10,000 wait events. The table
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_events_waits_history_long_size</literal>
+          system variable at server startup. As new events are added to
+          the table, older events are discarded if the table is full.
+          Events are not added to the table until they have ended.
         </para>
 
         <para>


Modified: trunk/refman-5.6/performance-schema-core.xml
===================================================================
--- trunk/refman-5.6/performance-schema-core.xml	2011-05-03 14:22:58 UTC (rev 26112)
+++ trunk/refman-5.6/performance-schema-core.xml	2011-05-03 18:30:23 UTC (rev 26113)
Changed blocks: 4, Lines Added: 23, Lines Deleted: 9; 2881 bytes

@@ -3924,7 +3924,10 @@
           The <literal role="ps">setup_actors</literal> table contains
           information that determines whether to enable monitoring for
           new foreground server threads; that is, threads associated
-          with client connections.
+          with client connections. This table has a maximum size of 100
+          rows by default. This size may be changed by modifying the
+          <literal role="sysvar">performance_schema_setup_actors_size</literal>
+          system variable at server startup.
         </para>
 
         <para>

@@ -4252,6 +4255,13 @@
         </para>
 
         <para>
+          This table has a maximum size of 100 rows by default. This
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_setup_objects_size</literal>
+          system variable at server startup.
+        </para>
+
+        <para>
           The <literal role="ps">setup_objects</literal> table has these
           columns:
         </para>

@@ -5320,10 +5330,12 @@
 
         <para>
           The <literal role="ps">events_waits_history</literal> table
-          contains the most recent 10 wait events per thread. As new
-          events are added to this table, older events are discarded if
-          the table is full. Events are not added to the table until
-          they have ended.
+          contains the most recent 10 wait events per thread. The table
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_events_waits_history_size</literal>
+          system variable at server startup. As new events are added to
+          the table, older events are discarded if the table is full.
+          Events are not added to the table until they have ended.
         </para>
 
         <para>

@@ -5357,10 +5369,12 @@
 
         <para>
           The <literal role="ps">events_waits_history_long</literal>
-          table contains the most recent 10,000 wait events. As new
-          events are added to this table, older events are discarded if
-          the table is full. Events are not added to the table until
-          they have ended.
+          table contains the most recent 10,000 wait events. The table
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_events_waits_history_long_size</literal>
+          system variable at server startup. As new events are added to
+          the table, older events are discarded if the table is full.
+          Events are not added to the table until they have ended.
         </para>
 
         <para>


Modified: trunk/refman-6.0/performance-schema-core.xml
===================================================================
--- trunk/refman-6.0/performance-schema-core.xml	2011-05-03 14:22:58 UTC (rev 26112)
+++ trunk/refman-6.0/performance-schema-core.xml	2011-05-03 18:30:23 UTC (rev 26113)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 8; 1879 bytes

@@ -3826,10 +3826,12 @@
 
         <para>
           The <literal role="ps">events_waits_history</literal> table
-          contains the most recent 10 wait events per thread. As new
-          events are added to this table, older events are discarded if
-          the table is full. Events are not added to the table until
-          they have ended.
+          contains the most recent 10 wait events per thread. The table
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_events_waits_history_size</literal>
+          system variable at server startup. As new events are added to
+          the table, older events are discarded if the table is full.
+          Events are not added to the table until they have ended.
         </para>
 
         <para>

@@ -3863,10 +3865,12 @@
 
         <para>
           The <literal role="ps">events_waits_history_long</literal>
-          table contains the most recent 10,000 wait events. As new
-          events are added to this table, older events are discarded if
-          the table is full. Events are not added to the table until
-          they have ended.
+          table contains the most recent 10,000 wait events. The table
+          size may be changed by modifying the
+          <literal role="sysvar">performance_schema_events_waits_history_long_size</literal>
+          system variable at server startup. As new events are added to
+          the table, older events are discarded if the table is full.
+          Events are not added to the table until they have ended.
         </para>
 
         <para>


Thread
svn commit - mysqldoc@oter02: r26113 - in trunk: . refman-5.5 refman-5.6 refman-6.0paul.dubois3 May