MySQL Lists are EOL. Please join:

List:Internals« Previous MessageNext Message »
From:paul Date:November 3 2005 1:11am
Subject:svn commit - mysqldoc@docsrva: r231 - in trunk: . refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2005-11-03 02:11:50 +0100 (Thu, 03 Nov 2005)
New Revision: 231

Log:
 r3331@frost:  paul | 2005-11-02 18:59:23 -0600
 For InnoDB, TABLE_ROWS is approximate. (Bug#13709)


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


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:3330
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:269
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:3331
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:269

Modified: trunk/refman-5.0/information-schema.xml
===================================================================
--- trunk/refman-5.0/information-schema.xml	2005-11-03 01:11:38 UTC (rev 230)
+++ trunk/refman-5.0/information-schema.xml	2005-11-03 01:11:50 UTC (rev 231)
@@ -391,9 +391,9 @@
         <listitem>
           <para>
             <emphasis role="bold">Note</emphasis>: In MySQL
-            &current-series;, the value of the 
-            <literal>SQL_PATH</literal> column is always 
-            <literal>NULL</literal>. 
+            &current-series;, the value of the
+            <literal>SQL_PATH</literal> column is always
+            <literal>NULL</literal>.
           </para>
         </listitem>
 
@@ -650,7 +650,9 @@
           <para>
             The <literal>TABLE_ROWS</literal> column is
             <literal>NULL</literal> if the table is in the
-            <literal>INFORMATION_SCHEMA</literal> database.
+            <literal>INFORMATION_SCHEMA</literal> database. For
+            <literal>InnoDB</literal> tables, the row count is only a
+            rough estimate used in SQL optimization.
           </para>
 
           <remark role="todo">
@@ -3252,17 +3254,18 @@
             the value <literal>'NEW'</literal>.
           </para>
         </listitem>
-        
+
         <listitem>
           <para>
             The <literal>SQL_MODE</literal> column shows the server SQL
             mode that was in effect at the time when the trigger was
             created (and thus which remains in effect for this trigger
             whenever it is invoked, <emphasis>regardless of the current
-              server SQL mode</emphasis>). The possible range of values
+            server SQL mode</emphasis>). The possible range of values
             for this column is the same as that of the
-            <literal>sql_mode</literal> system  variable. See <xref
-              linkend="server-sql-mode"/>. 
+            <literal>sql_mode</literal> system variable. See
+            <xref
+              linkend="server-sql-mode"/>.
           </para>
         </listitem>
 

Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml	2005-11-03 01:11:38 UTC (rev 230)
+++ trunk/refman-5.1/information-schema.xml	2005-11-03 01:11:50 UTC (rev 231)
@@ -385,9 +385,9 @@
       <para>
         <emphasis role="bold">Note</emphasis>: In MySQL
         &current-series;, the value of the <literal>SQL_PATH</literal>
-        column is always <literal>NULL</literal>. 
+        column is always <literal>NULL</literal>.
       </para>
-      
+
       <para>
         The following statements are equivalent:
       </para>
@@ -632,7 +632,9 @@
           <para>
             The <literal>TABLE_ROWS</literal> column is
             <literal>NULL</literal> if the table is in the
-            <literal>INFORMATION_SCHEMA</literal> database.
+            <literal>INFORMATION_SCHEMA</literal> database. For
+            <literal>InnoDB</literal> tables, the row count is only a
+            rough estimate used in SQL optimization.
           </para>
 
           <remark role="todo">
@@ -3219,17 +3221,18 @@
             the value <literal>'NEW'</literal>.
           </para>
         </listitem>
-        
+
         <listitem>
           <para>
             The <literal>SQL_MODE</literal> column shows the server SQL
             mode that was in effect at the time when the trigger was
             created (and thus which remains in effect for this trigger
             whenever it is invoked, <emphasis>regardless of the current
-              server SQL mode</emphasis>). The possible range of values
+            server SQL mode</emphasis>). The possible range of values
             for this column is the same as that of the
-            <literal>sql_mode</literal> system  variable. See <xref
-              linkend="server-sql-mode"/>. 
+            <literal>sql_mode</literal> system variable. See
+            <xref
+              linkend="server-sql-mode"/>.
           </para>
         </listitem>
 

Thread
svn commit - mysqldoc@docsrva: r231 - in trunk: . refman-5.0 refman-5.1paul3 Nov