Author: paul
Date: 2007-03-09 18:11:43 +0100 (Fri, 09 Mar 2007)
New Revision: 5283
Log:
r17453@frost: paul | 2007-03-09 11:01:26 -0600
Describe entries in INFORMATION_SCHEMA.PROFILING table.
In SET section, add entries for profiling, profiling_history_size
variables.
Modified:
trunk/mysqld-optvars/options.xml
trunk/refman-5.0/information-schema.xml
trunk/refman-5.0/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:21154
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:17415
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:21154
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:17453
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/mysqld-optvars/options.xml
===================================================================
--- trunk/mysqld-optvars/options.xml 2007-03-09 17:10:32 UTC (rev 5282)
+++ trunk/mysqld-optvars/options.xml 2007-03-09 17:11:43 UTC (rev 5283)
Changed blocks: 1, Lines Added: 38, Lines Deleted: 0; 1677 bytes
@@ -8192,6 +8192,44 @@
<manual version="5.1"/>
</versions>
</mysqloption>
+ <mysqloption id="profiling">
+ <name>profiling</name>
+ <shortdescription lang="en">Enable or disable statement profiling</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms applies="all"/>
+ <types>
+ <vartype class="server" isdynamic="yes" scope="session"/>
+ </types>
+ <values vartype="boolean" platform="all"/>
+ <values vartype="boolean" platform="all">
+ <value default="OFF"/>
+ </values>
+ <versions>
+ <manual version="5.0"/>
+ <introduced version="5.0.37"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="profiling_history_size">
+ <name>profiling_history_size</name>
+ <shortdescription lang="en">How many statements to maintain profiling
+information for</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms applies="all"/>
+ <types>
+ <vartype class="server" isdynamic="yes" scope="session"/>
+ </types>
+ <values vartype="numeric" platform="all">
+ <value default="15"/>
+ </values>
+ <versions>
+ <manual version="5.0"/>
+ <introduced version="5.0.37"/>
+ </versions>
+ </mysqloption>
<mysqloption id="query_alloc_block_size">
<xrefto id="optvar_query_alloc_block_size"/>
<name>query_alloc_block_size</name>
Modified: trunk/refman-5.0/information-schema.xml
===================================================================
--- trunk/refman-5.0/information-schema.xml 2007-03-09 17:10:32 UTC (rev 5282)
+++ trunk/refman-5.0/information-schema.xml 2007-03-09 17:11:43 UTC (rev 5283)
Changed blocks: 1, Lines Added: 82, Lines Deleted: 0; 2660 bytes
@@ -3422,6 +3422,88 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ <literal>QUERY_ID</literal> is a numeric statement identifier.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SEQ</literal> is a sequence number indicating the
+ display order for rows with the same
+ <literal>QUERY_ID</literal> value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>STATE</literal> is the profiling state to which the
+ row measurements apply.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>DURATION</literal> indicates how long statement
+ execution remained in the given state, in seconds.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>CPU_USER</literal> and <literal>CPU_SYSTEM</literal>
+ indicate user and system CPU use, in seconds.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>CONTEXT_VOLUNTARY</literal> and
+ <literal>CONTEXT_INVOLUNTARY</literal> indicate how many
+ voluntary and involuntary context switches occurred.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>BLOCK_OPS_IN</literal> and
+ <literal>BLOCK_OPS_OUT</literal> indicate the number of block
+ input and output operations.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>MESSAGES_SENT</literal> and
+ <literal>MESSAGES_RECEIVED</literal> indicate the number of
+ communication messages sent and received.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PAGE_FAULTS_MAJOR</literal> and
+ <literal>PAGE_FAULTS_MINOR</literal> indicate the number of
+ major and minor page faults.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SWAPS</literal> indicates how many swaps occurred.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SOURCE_FUNCTION</literal>,
+ <literal>SOURCE_FILE</literal>, and
+ <literal>SOURCE_LINE</literal> provide information indicating
+ where in the source code the profiled state executes.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-03-09 17:10:32 UTC (rev 5282)
+++ trunk/refman-5.0/sql-syntax.xml 2007-03-09 17:11:43 UTC (rev 5283)
Changed blocks: 2, Lines Added: 41, Lines Deleted: 0; 2001 bytes
@@ -15001,6 +15001,16 @@
<indexterm>
<primary><literal>SET</literal></primary>
+ <secondary><literal>PROFILING</literal></secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary><literal>SET</literal></primary>
+ <secondary><literal>PROFILING_HISTORY_SIZE</literal></secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary><literal>SET</literal></primary>
<secondary><literal>SQL_AUTO_IS_NULL</literal></secondary>
</indexterm>
@@ -15653,6 +15663,37 @@
<listitem>
<para>
+ <literal>PROFILING = {0 | 1}</literal>
+ </para>
+
+ <para>
+ If set to 0 (the default), statement profiling is disabled.
+ If set to 1, statement profiling is enabled and the
+ <literal>SHOW PROFILES</literal> and <literal>SHOW
+ PROFILE</literal> statements provide access to profiling
+ information. See <xref linkend="show-profiles"/>. This
+ variable was added in MySQL 5.0.37.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>PROFILING_HISTORY_SIZE =
+ <replaceable>value</replaceable></literal>
+ </para>
+
+ <para>
+ The number of statements for which to maintain profiling
+ information if <literal>PROFILING</literal> is enabled. The
+ default value is 15. The maximum value is 100. Setting the
+ value to 0 effectively disables profiling. See
+ <xref linkend="show-profiles"/>. This variable was added in
+ MySQL 5.0.37.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>SQL_AUTO_IS_NULL = {0 | 1}</literal>
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5283 - in trunk: . mysqld-optvars refman-5.0 | paul | 9 Mar |
