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.0 | paul.dubois | 3 May |
