From: stefan
Date: June 8 2007 9:07am
Subject: svn commit - mysqldoc@docsrva: r6712 - in trunk: refman-5.0 refman-5.1
List-Archive: http://lists.mysql.com/commits/28383
Message-Id: <200706080907.l5897vvC017824@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: shinz
Date: 2007-06-08 11:07:55 +0200 (Fri, 08 Jun 2007)
New Revision: 6712

Log:
Clarify that ANALYZE TABLE might be needed to update index cardinality information after an ALTER TABLE statement (Bug #28747)

Modified:
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2007-06-08 08:56:20 UTC (rev 6711)
+++ trunk/refman-5.0/sql-syntax.xml	2007-06-08 09:07:55 UTC (rev 6712)
Changed blocks: 8, Lines Added: 60, Lines Deleted: 52; 6450 bytes

@@ -621,6 +621,15 @@
 
         <listitem>
           <para>
+            After an <literal>ALTER TABLE</literal> statement, it may be
+            necessary to run <literal>ANALYZE TABLE</literal> to update
+            index cardinality information. See
+            <xref linkend="show-index"/>.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             <indexterm>
               <primary>ORDER BY</primary>
             </indexterm>

@@ -1314,19 +1323,19 @@
         column in a <literal>UNIQUE</literal> index, the column values
         must be unique within the prefix.
       </para>
-      
+
       <formalpara role="mnmas">
-        
+
         <title>MySQL Enterprise</title>
-        
+
         <para>
           Lack of proper indexes can greatly reduce performance.
           Subscribe to the MySQL Network Monitoring and Advisory Service
-          for notification of inefficient use of indexes.
-          For more information see
+          for notification of inefficient use of indexes. For more
+          information see
           <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
-        
+
       </formalpara>
 
       <para>

@@ -12998,18 +13007,18 @@
           administrators to remove account privileges. See
           <xref linkend="revoke"/>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            For automated notification of users with inappropriate privileges,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            For automated notification of users with inappropriate
+            privileges, subscribe to the MySQL Network Monitoring and
+            Advisory Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <para>

@@ -14302,18 +14311,18 @@
           You can see which account the server authenticated you as by
           executing <literal>SELECT CURRENT_USER()</literal>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
             For automated notification of users without passwords,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            subscribe to the MySQL Network Monitoring and Advisory
+            Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
       </section>

@@ -14365,18 +14374,18 @@
           within<literal>InnoDB</literal>, see
           <xref linkend="innodb-restrictions"/>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            For expert advice on optimizing tables
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            For expert advice on optimizing tables subscribe to the
+            MySQL Network Monitoring and Advisory Service. For more
+            information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <para>

@@ -15647,18 +15656,18 @@
         </listitem>
 
       </itemizedlist>
-      
+
       <formalpara role="mnmas">
-        
+
         <title>MySQL Enterprise</title>
-        
+
         <para>
-          The MySQL Network Monitoring and Advisory Service
-          makes extensive use of system variables to determine
-          the state of your server. For more information see
+          The MySQL Network Monitoring and Advisory Service makes
+          extensive use of system variables to determine the state of
+          your server. For more information see
           <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
-        
+
       </formalpara>
 
       <para>

@@ -17376,21 +17385,21 @@
           <literal>SHOW ENGINE NDBCLUSTER STATUS</literal> is a synonym
           for <literal>SHOW ENGINE NDB STATUS</literal>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            The <literal>SHOW ENGINE <replaceable>engine_name</replaceable> 
-             STATUS</literal> statement
-            provides valuable information about the state of your server.
-            For expert interpretation of this information,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            The <literal>SHOW ENGINE
+            <replaceable>engine_name</replaceable> STATUS</literal>
+            statement provides valuable information about the state of
+            your server. For expert interpretation of this information,
+            subscribe to the MySQL Network Monitoring and Advisory
+            Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
       </section>

@@ -19680,20 +19689,19 @@
           get the same value for both <literal>GLOBAL</literal> and
           <literal>SESSION</literal>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            Status variables provide valuable clues to the state
-            of your servers. For expert interpretation of the
-            information provided by status variables,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            Status variables provide valuable clues to the state of your
+            servers. For expert interpretation of the information
+            provided by status variables, subscribe to the MySQL Network
+            Monitoring and Advisory Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <para>


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-06-08 08:56:20 UTC (rev 6711)
+++ trunk/refman-5.1/sql-syntax.xml	2007-06-08 09:07:55 UTC (rev 6712)
Changed blocks: 8, Lines Added: 63, Lines Deleted: 55; 6937 bytes

@@ -662,6 +662,15 @@
 
         <listitem>
           <para>
+            After an <literal>ALTER TABLE</literal> statement, it may be
+            necessary to run <literal>ANALYZE TABLE</literal> to update
+            index cardinality information. See
+            <xref linkend="show-index"/>.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             <indexterm>
               <primary>ORDER BY</primary>
             </indexterm>

@@ -1880,19 +1889,19 @@
         for a column in a <literal>UNIQUE</literal> index, the column
         values must be unique within the prefix.
       </para>
-      
+
       <formalpara role="mnmas">
-        
+
         <title>MySQL Enterprise</title>
-        
+
         <para>
           Lack of proper indexes can greatly reduce performance.
           Subscribe to the MySQL Network Monitoring and Advisory Service
-          for notification of inefficient use of indexes.
-          For more information see
+          for notification of inefficient use of indexes. For more
+          information see
           <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
-        
+
       </formalpara>
 
       <para>

@@ -14866,18 +14875,18 @@
           administrators to remove account privileges. See
           <xref linkend="revoke"/>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            For automated notification of users with inappropriate privileges,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            For automated notification of users with inappropriate
+            privileges, subscribe to the MySQL Network Monitoring and
+            Advisory Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <para>

@@ -16166,18 +16175,18 @@
           You can see which account the server authenticated you as by
           executing <literal>SELECT CURRENT_USER()</literal>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
             For automated notification of users without passwords,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            subscribe to the MySQL Network Monitoring and Advisory
+            Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
       </section>

@@ -16228,18 +16237,18 @@
           within<literal>InnoDB</literal>, see
           <xref linkend="innodb-restrictions"/>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            For expert advice on optimizing tables
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            For expert advice on optimizing tables subscribe to the
+            MySQL Network Monitoring and Advisory Service. For more
+            information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <para>

@@ -17499,28 +17508,28 @@
         </listitem>
 
       </itemizedlist>
-      
+
       <formalpara role="mnmas">
-        
+
         <title>MySQL Enterprise</title>
-        
+
         <para>
-          The MySQL Network Monitoring and Advisory Service
-          makes extensive use of system variables to determine
-          the state of your server. For more information see
+          The MySQL Network Monitoring and Advisory Service makes
+          extensive use of system variables to determine the state of
+          your server. For more information see
           <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
-        
-      </formalpara>      
 
+      </formalpara>
+
       <para>
         A <literal>SET</literal> statement can contain multiple variable
         assignments, separated by commas. If you set several system
         variables, the most recent <literal>GLOBAL</literal> or
         <literal>SESSION</literal> modifier in the statement is used for
         following variables that have no modifier specified.
-      </para>      
-     
+      </para>
+
       <para>
         Examples:
       </para>

@@ -19545,21 +19554,21 @@
           <literal>SHOW ENGINE NDBCLUSTER STATUS</literal> is a synonym
           for <literal>SHOW ENGINE NDB STATUS</literal>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            The <literal>SHOW ENGINE <replaceable>engine_name</replaceable> 
-              STATUS</literal> statement
-            provides valuable information about the state of your server.
-            For expert interpretation of this information,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            The <literal>SHOW ENGINE
+            <replaceable>engine_name</replaceable> STATUS</literal>
+            statement provides valuable information about the state of
+            your server. For expert interpretation of this information,
+            subscribe to the MySQL Network Monitoring and Advisory
+            Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <para>

@@ -21783,20 +21792,19 @@
           get the same value for both <literal>GLOBAL</literal> and
           <literal>SESSION</literal>.
         </para>
-        
+
         <formalpara role="mnmas">
-          
+
           <title>MySQL Enterprise</title>
-          
+
           <para>
-            Status variables provide valuable clues to the state
-            of your servers. For expert interpretation of the
-            information provided by status variables,
-            subscribe to the MySQL Network Monitoring and Advisory Service.
-            For more information see
+            Status variables provide valuable clues to the state of your
+            servers. For expert interpretation of the information
+            provided by status variables, subscribe to the MySQL Network
+            Monitoring and Advisory Service. For more information see
             <ulink url="&base-url-enterprise;advisors.html"/>.
           </para>
-          
+
         </formalpara>
 
         <remark role="help-description-end"/>