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"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6712 - in trunk: refman-5.0 refman-5.1 | stefan | 8 Jun |
