Author: paul
Date: 2006-02-18 19:20:53 +0100 (Sat, 18 Feb 2006)
New Revision: 1383
Log:
r7813@frost: paul | 2006-02-18 12:20:21 -0600
Mark non-standard I_S columns as "MySQL extension".
Add PROCESSLIST table.
Modified:
trunk/
trunk/refman-5.0/information-schema.xml
trunk/refman-5.1/information-schema.xml
trunk/refman-common/news-5.1.xml
trunk/refman-common/titles.en.ent
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7812
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3223
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7813
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3223
Modified: trunk/refman-5.0/information-schema.xml
===================================================================
--- trunk/refman-5.0/information-schema.xml 2006-02-18 18:20:36 UTC (rev 1382)
+++ trunk/refman-5.0/information-schema.xml 2006-02-18 18:20:53 UTC (rev 1383)
@@ -307,7 +307,7 @@
</row>
<row>
<entry><literal>CATALOG_NAME</literal></entry>
- <entry>-</entry>
+ <entry/>
<entry><literal>NULL</literal></entry>
</row>
<row>
@@ -1354,22 +1354,22 @@
<entry><literal>GRANTEE</literal></entry>
<entry/>
<entry><literal>'<replaceable>user_name</replaceable>'@'<replaceable>host_name</replaceable>'</literal>
- value</entry>
+ value, MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_CATALOG</literal></entry>
<entry/>
- <entry><literal>NULL</literal></entry>
+ <entry><literal>NULL</literal>, MySQL extension</entry>
</row>
<row>
<entry><literal>PRIVILEGE_TYPE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>IS_GRANTABLE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -1423,27 +1423,27 @@
<entry><literal>GRANTEE</literal></entry>
<entry/>
<entry><literal>'<replaceable>user_name</replaceable>'@'<replaceable>host_name</replaceable>'</literal>
- value</entry>
+ value, MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_CATALOG</literal></entry>
<entry/>
- <entry><literal>NULL</literal></entry>
+ <entry><literal>NULL</literal>, MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_SCHEMA</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PRIVILEGE_TYPE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>IS_GRANTABLE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -1551,6 +1551,25 @@
</informaltable>
<para>
+ Notes:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>PRIVILEGE_TYPE</literal> can contain one (and only
+ one) of these values: <literal>SELECT</literal>,
+ <literal>INSERT</literal>, <literal>UPDATE</literal>,
+ <literal>REFERENCES</literal>, <literal>ALTER</literal>,
+ <literal>INDEX</literal>, <literal>DROP</literal>,
+ <literal>CREATE VIEW</literal>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
The following statements are <emphasis>not</emphasis> equivalent:
</para>
@@ -1560,15 +1579,6 @@
SHOW GRANTS ...
</programlisting>
- <para>
- <literal>PRIVILEGE_TYPE</literal> can contain one (and only one)
- of these values: <literal>SELECT</literal>,
- <literal>INSERT</literal>, <literal>UPDATE</literal>,
- <literal>REFERENCES</literal>, <literal>ALTER</literal>,
- <literal>INDEX</literal>, <literal>DROP</literal>, <literal>CREATE
- VIEW</literal>.
- </para>
-
</section>
<section id="column-privileges-table">
@@ -1827,23 +1837,6 @@
</informaltable>
<para>
- Notes:
- </para>
-
- <itemizedlist>
-
- <listitem>
- <para>
- We have added two non-standard columns corresponding to the
- <literal>Description</literal> and <literal>Maxlen</literal>
- columns in the output from <literal>SHOW CHARACTER
- SET</literal>.
- </para>
- </listitem>
-
- </itemizedlist>
-
- <para>
The following statements are equivalent:
</para>
@@ -1954,84 +1947,36 @@
</entry>
</row>
-->
-<!--
- <row>
- <entry>
- <literal>CHARACTER_SET_NAME</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>ID</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>IS_DEFAULT</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>IS_COMPILED</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>SORTLEN</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
+ <row>
+ <entry><literal>CHARACTER_SET_NAME</literal></entry>
+ <entry><literal>Charset</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>ID</literal></entry>
+ <entry><literal>Id</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>IS_DEFAULT</literal></entry>
+ <entry><literal>Default</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>IS_COMPILED</literal></entry>
+ <entry><literal>Compiled</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>SORTLEN</literal></entry>
+ <entry><literal>Sortlen</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
</tbody>
</tgroup>
</informaltable>
<para>
- Notes:
- </para>
-
- <itemizedlist>
-
- <listitem>
- <para>
- We have added five non-standard columns corresponding to the
- <literal>Charset</literal>, <literal>Id</literal>,
- <literal>Default</literal>, <literal>Compiled</literal>, and
- <literal>Sortlen</literal> columns in the output from
- <literal>SHOW COLLATION</literal>.
- </para>
- </listitem>
-
- </itemizedlist>
-
- <para>
The following statements are equivalent:
</para>
@@ -3179,8 +3124,8 @@
<para>
The <literal>TRIGGER_SCHEMA</literal> and
<literal>TRIGGER_NAME</literal> columns contain the name of
- the database in which the trigger occurs, and the trigger
- name, respectively.
+ the database in which the trigger occurs and the trigger name,
+ respectively.
</para>
</listitem>
@@ -3410,7 +3355,7 @@
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
-16 rows in set (0.02 sec)
+16 rows in set (0.00 sec)
</programlisting>
<para>
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2006-02-18 18:20:36 UTC (rev 1382)
+++ trunk/refman-5.1/information-schema.xml 2006-02-18 18:20:53 UTC (rev 1383)
@@ -307,7 +307,7 @@
</row>
<row>
<entry><literal>CATALOG_NAME</literal></entry>
- <entry>-</entry>
+ <entry/>
<entry><literal>NULL</literal></entry>
</row>
<row>
@@ -1339,22 +1339,22 @@
<entry><literal>GRANTEE</literal></entry>
<entry/>
<entry><literal>'<replaceable>user_name</replaceable>'@'<replaceable>host_name</replaceable>'</literal>
- value</entry>
+ value, MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_CATALOG</literal></entry>
<entry/>
- <entry><literal>NULL</literal></entry>
+ <entry><literal>NULL</literal>, MySQL extension</entry>
</row>
<row>
<entry><literal>PRIVILEGE_TYPE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>IS_GRANTABLE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -1408,27 +1408,27 @@
<entry><literal>GRANTEE</literal></entry>
<entry/>
<entry><literal>'<replaceable>user_name</replaceable>'@'<replaceable>host_name</replaceable>'</literal>
- value</entry>
+ value, MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_CATALOG</literal></entry>
<entry/>
- <entry><literal>NULL</literal></entry>
+ <entry><literal>NULL</literal>, MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_SCHEMA</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PRIVILEGE_TYPE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>IS_GRANTABLE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -1536,6 +1536,25 @@
</informaltable>
<para>
+ Notes:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>PRIVILEGE_TYPE</literal> can contain one (and only
+ one) of these values: <literal>SELECT</literal>,
+ <literal>INSERT</literal>, <literal>UPDATE</literal>,
+ <literal>REFERENCES</literal>, <literal>ALTER</literal>,
+ <literal>INDEX</literal>, <literal>DROP</literal>,
+ <literal>CREATE VIEW</literal>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
The following statements are <emphasis>not</emphasis> equivalent:
</para>
@@ -1545,15 +1564,6 @@
SHOW GRANTS ...
</programlisting>
- <para>
- <literal>PRIVILEGE_TYPE</literal> can contain one (and only one)
- of these values: <literal>SELECT</literal>,
- <literal>INSERT</literal>, <literal>UPDATE</literal>,
- <literal>REFERENCES</literal>, <literal>ALTER</literal>,
- <literal>INDEX</literal>, <literal>DROP</literal>, <literal>CREATE
- VIEW</literal>.
- </para>
-
</section>
<section id="column-privileges-table">
@@ -1812,23 +1822,6 @@
</informaltable>
<para>
- Notes:
- </para>
-
- <itemizedlist>
-
- <listitem>
- <para>
- We have added two non-standard columns corresponding to the
- <literal>Description</literal> and <literal>Maxlen</literal>
- columns in the output from <literal>SHOW CHARACTER
- SET</literal>.
- </para>
- </listitem>
-
- </itemizedlist>
-
- <para>
The following statements are equivalent:
</para>
@@ -1939,84 +1932,36 @@
</entry>
</row>
-->
-<!--
- <row>
- <entry>
- <literal>CHARACTER_SET_NAME</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>ID</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>IS_DEFAULT</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>IS_COMPILED</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
-<!--
- <row>
- <entry>
- <literal>SORTLEN</literal>
- </entry>
- <entry/>
- <entry>
- omit MySQL extension
- </entry>
- </row>
- -->
+ <row>
+ <entry><literal>CHARACTER_SET_NAME</literal></entry>
+ <entry><literal>Charset</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>ID</literal></entry>
+ <entry><literal>Id</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>IS_DEFAULT</literal></entry>
+ <entry><literal>Default</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>IS_COMPILED</literal></entry>
+ <entry><literal>Compiled</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>SORTLEN</literal></entry>
+ <entry><literal>Sortlen</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
</tbody>
</tgroup>
</informaltable>
<para>
- Notes:
- </para>
-
- <itemizedlist>
-
- <listitem>
- <para>
- We have added five non-standard columns corresponding to the
- <literal>Charset</literal>, <literal>Id</literal>,
- <literal>Default</literal>, <literal>Compiled</literal>, and
- <literal>Sortlen</literal> columns in the output from
- <literal>SHOW COLLATION</literal>.
- </para>
- </listitem>
-
- </itemizedlist>
-
- <para>
The following statements are equivalent:
</para>
@@ -3146,8 +3091,8 @@
<para>
The <literal>TRIGGER_SCHEMA</literal> and
<literal>TRIGGER_NAME</literal> columns contain the name of
- the database in which the trigger occurs, and the trigger
- name, respectively.
+ the database in which the trigger occurs and the trigger name,
+ respectively.
</para>
</listitem>
@@ -3317,48 +3262,48 @@
</row>
<row>
<entry><literal>PLUGIN_NAME</literal></entry>
- <entry/>
- <entry/>
+ <entry><literal>Name</literal></entry>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_VERSION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_STATUS</literal></entry>
- <entry/>
- <entry/>
+ <entry><literal>Status</literal></entry>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_TYPE</literal></entry>
- <entry/>
- <entry/>
+ <entry><literal>Type</literal></entry>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_TYPE_VERSION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_LIBRARY</literal></entry>
- <entry/>
- <entry/>
+ <entry><literal>Library</literal></entry>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_LIBRARY_VERSION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_AUTHOR</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PLUGIN_DESCRIPTION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -3372,6 +3317,12 @@
<listitem>
<para>
+ This is a non-standard table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
The <literal>PLUGINS</literal> table was added in MySQL 5.1.5.
</para>
</listitem>
@@ -3413,32 +3364,32 @@
<row>
<entry><literal>ENGINE</literal></entry>
<entry><literal>Engine</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SUPPORT</literal></entry>
<entry><literal>Support</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>COMMENT</literal></entry>
<entry><literal>Comment</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TRANSACTIONS</literal></entry>
<entry><literal>Transactions</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>XA</literal></entry>
<entry><literal>XA</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SAVEPOINTS</literal></entry>
<entry><literal>Savepoints</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -3452,6 +3403,12 @@
<listitem>
<para>
+ This is a non-standard table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
The <literal>ENGINES</literal> table was added in MySQL 5.1.5.
</para>
</listitem>
@@ -3803,7 +3760,7 @@
<para>
<literal>DEFINER</literal>: The user who created the event.
Always displayed in
- <literal><replaceable>username</replaceable>@<replaceable>hostname</replaceable></literal>
+ <literal>'<replaceable>user_name</replaceable>'@'<replaceable>host_name</replaceable>'</literal>
format.
</para>
</listitem>
@@ -3835,15 +3792,15 @@
event's <literal>AT</literal> clause. For example, if an event
is created using <literal>ON SCHEDULE AT CURRENT_TIMESTAMP +
'1:6' DAY_HOUR</literal>, and the event was created at
- 2006-02-09 14:05:30, then the value shown in this column would
- be <literal>'2006-02-10 20:05:30'</literal>.
+ 2006-02-09 14:05:30, the value shown in this column would be
+ <literal>'2006-02-10 20:05:30'</literal>.
</para>
<para>
If the event's timing is determined by an
<literal>EVERY</literal> clause instead of an
<literal>AT</literal> clause (that is, if the event is
- recurring), then the value of this column is
+ recurring), the value of this column is
<literal>NULL</literal>.
</para>
</listitem>
@@ -3899,7 +3856,7 @@
<para>
If there is no <literal>STARTS</literal> clause affecting the
- timing of the event, then this column contains
+ timing of the event, this column contains
<literal>NULL</literal>.
</para>
</listitem>
@@ -3915,7 +3872,7 @@
<para>
If there is no <literal>ENDS</literal> clause affecting the
- timing of the event, then this column contains
+ timing of the event, this column contains
<literal>NULL</literal>.
</para>
</listitem>
@@ -3947,7 +3904,7 @@
<literal>LAST_ALTERED</literal>: The date and time when the
event was last modified. This is a <literal>DATETIME</literal>
value. If the event has not been modified since its creation,
- ten this column holds the same value as the
+ this column holds the same value as the
<literal>CREATED</literal> column.
</para>
</listitem>
@@ -3956,7 +3913,7 @@
<para>
<literal>LAST_EXECUTED</literal>: The date and time when the
event last executed. A <literal>DATETIME</literal> value. If
- the event has never executed, then this column's value is
+ the event has never executed, this column's value is
<literal>NULL</literal>.
</para>
</listitem>
@@ -3964,8 +3921,8 @@
<listitem>
<para>
<literal>EVENT_COMMENT</literal>: The text of a comment, if
- the event has one. If there is no comment, then the value of
- this column is an empty string.
+ the event has one. If there is no comment, the value of this
+ column is an empty string.
</para>
</listitem>
@@ -3974,8 +3931,9 @@
<para>
<emphasis role="bold">Example</emphasis>: Suppose the user
<literal>jon@ghidora</literal> creates an event named
- <literal>e_daily</literal>, then modifies it a few minutes later
- using an <literal>ALTER EVENT</literal> statement, as shown here:
+ <literal>e_daily</literal>, and then modifies it a few minutes
+ later using an <literal>ALTER EVENT</literal> statement, as shown
+ here:
</para>
<programlisting>
@@ -4060,7 +4018,7 @@
<para>
The <literal>FILES</literal> table provides information about the
- files in which MySQL NDB tables are stored.
+ files in which MySQL <literal>NDB</literal> tables are stored.
</para>
<informaltable>
@@ -4289,6 +4247,103 @@
</section>
+ <section id="processlist-table">
+
+ <title>&title-processlist-table;</title>
+
+ <indexterm type="function">
+ <primary>PROCESSLIST</primary>
+ <secondary>INFORMATION_SCHEMA table</secondary>
+ </indexterm>
+
+ <para>
+ The <literal>PROCESSLIST</literal> table provides information
+ about which threads are running.
+ </para>
+
+ <informaltable>
+ <tgroup cols="3">
+ <colspec colwidth="40*"/>
+ <colspec colwidth="30*"/>
+ <colspec colwidth="30*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
+ <entry><emphasis role="bold">Remarks</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ID</literal></entry>
+ <entry><literal>Id</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>USER</literal></entry>
+ <entry><literal>User</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>HOST</literal></entry>
+ <entry><literal>Host</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>DB</literal></entry>
+ <entry><literal>db</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>COMMAND</literal></entry>
+ <entry><literal>Command</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>TIME</literal></entry>
+ <entry><literal>Time</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>STATE</literal></entry>
+ <entry><literal>State</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ <row>
+ <entry><literal>INFO</literal></entry>
+ <entry><literal>Info</literal></entry>
+ <entry>MySQL extension</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ <para>
+ <emphasis role="bold">Notes</emphasis>:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>PROCESSLIST</literal> table was added in MySQL
+ 5.1.7.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The following statements are equivalent:
+ </para>
+
+<programlisting>
+SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
+
+SHOW PROCESSLIST
+</programlisting>
+
+ </section>
+
<section id="other-information-schema-tables">
<title>&title-other-information-schema-tables;</title>
@@ -4367,6 +4422,7 @@
| KEY_COLUMN_USAGE |
| PARTITIONS |
| PLUGINS |
+| PROCESSLIST |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
@@ -4378,7 +4434,7 @@
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
-19 rows in set (0.03 sec)
+22 rows in set (0.04 sec)
</programlisting>
<para>
Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml 2006-02-18 18:20:36 UTC (rev 1382)
+++ trunk/refman-common/news-5.1.xml 2006-02-18 18:20:53 UTC (rev 1383)
@@ -114,6 +114,13 @@
<listitem>
<para>
+ Added the <literal>PROCESSLIST</literal> table to
+ <literal>INFORMATION_SCHEMA</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Attempting to read pre-5.1.6 partitioned tables with a MySQL
5.1.7 (or later) server now generates a suitable warning
message. (Bug #16695)
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2006-02-18 18:20:36 UTC (rev 1382)
+++ trunk/refman-common/titles.en.ent 2006-02-18 18:20:53 UTC (rev 1383)
@@ -1401,6 +1401,7 @@
<!ENTITY title-problems-with-mysql-sock "How to Protect or Change the MySQL Unix Socket File">
<!ENTITY title-problems-with-null "Problems with <literal>NULL</literal> Values">
<!ENTITY title-procedure-analyse "Procedure Analyse">
+<!ENTITY title-processlist-table "The <literal>INFORMATION_SCHEMA PROCESSLIST</literal> Table">
<!ENTITY title-program-options "Specifying Program Options">
<!ENTITY title-program-overview "Overview of MySQL Programs">
<!ENTITY title-program-variables "Using Options to Set Program Variables">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1383 - in trunk: . refman-5.0 refman-5.1 refman-common | paul | 18 Feb |
