svn commit - mysqldoc@docsrva: r1682 - trunk/refman-5.1

[stefan]

Author: shinz
Date: 2006-03-27 15:15:07 +0200 (Mon, 27 Mar 2006)
New Revision: 1682

Log:
Add some more information to the I_S.PROCESSLIST section (closing WL#3148)

Modified:
   trunk/refman-5.1/information-schema.xml

Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml	2006-03-27 12:48:56 UTC (rev 1681)
+++ trunk/refman-5.1/information-schema.xml	2006-03-27 13:15:07 UTC (rev 1682)
@@ -4643,6 +4643,11 @@
     </informaltable>
 
     <para>
+      For an extensive description of the table columns, see 
+      <xref linkend="show-processlist"/>.
+    </para>
+    
+    <para>
       <emphasis role="bold">Notes</emphasis>:
     </para>
 
@@ -4654,6 +4659,26 @@
           table. It was added in MySQL 5.1.7.
         </para>
       </listitem>
+      
+      <listitem>
+        <para>
+          Like the output from the corresponding <literal>SHOW</literal> statement,
+          the <literal>PROCESSLIST</literal> table will only show
+          information about your own threads, unless you have the
+          <literal>PROCESS</literal> privilege, in which case you will see information about other threads, too. As an anonymous user, you cannot see any rows at all.
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          If an SQL statement refers to 
+          <literal>INFORMATION_SCHEMA.PROCESSLIST</literal>,  
+          then MySQL will populate the entire table once, when statement  
+          execution begins, so there is read consistency during the  
+          statement. There is no read consistency for a multi-statement  
+          transaction, though.
+        </para>
+      </listitem>
 
     </itemizedlist>
 
@@ -4666,7 +4691,7 @@
 
 SHOW PROCESSLIST
 </programlisting>
-
+    
   </section>
 
   <section id="other-information-schema-tables">