Author: paul
Date: 2006-01-19 03:09:10 +0100 (Thu, 19 Jan 2006)
New Revision: 915
Log:
r6390@frost: paul | 2006-01-18 20:08:31 -0600
Add ENGINES, PLUGINS, PARTITIONS tables to INFORMATION_SCHEMA chapter.
Modified:
trunk/
trunk/refman-5.1/information-schema.xml
trunk/refman-5.1/partitioning.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:6373
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2322
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6390
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2322
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2006-01-19 01:31:03 UTC (rev 914)
+++ trunk/refman-5.1/information-schema.xml 2006-01-19 02:09:10 UTC (rev 915)
@@ -3302,6 +3302,356 @@
</section>
+ <section id="plugins-table">
+
+ <title>&title-plugins-table;</title>
+
+ <indexterm type="function">
+ <primary>PLUGINS</primary>
+ <secondary>INFORMATION_SCHEMA table</secondary>
+ </indexterm>
+
+ <para>
+ The <literal>PLUGINS</literal> table provides information about
+ server plugins.
+ </para>
+
+ <informaltable>
+ <tgroup cols="3">
+ <colspec colwidth="40*"/>
+ <colspec colwidth="30*"/>
+ <colspec colwidth="30*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold">Remarks</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_NAME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_VERSION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_STATUS</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_TYPE</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_TYPE_VERSION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_LIBRARY</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_LIBRARY_VERSION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_AUTHOR</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PLUGIN_DESCRIPTION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ <para>
+ <emphasis role="bold">Notes</emphasis>:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>PLUGINS</literal> table was added in MySQL
+ 5.1.5.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <remark role="todo">
+ Add xref to SHOW PLUGINS when that is implemented.
+ </remark>
+
+ </section>
+
+ <section id="engines-table">
+
+ <title>&title-engines-table;</title>
+
+ <indexterm type="function">
+ <primary>ENGINES</primary>
+ <secondary>INFORMATION_SCHEMA table</secondary>
+ </indexterm>
+
+ <para>
+ The <literal>PLUGINS</literal> table provides information about
+ storage engines.
+ </para>
+
+ <informaltable>
+ <tgroup cols="3">
+ <colspec colwidth="40*"/>
+ <colspec colwidth="30*"/>
+ <colspec colwidth="30*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold">Remarks</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ENGINE</literal></entry>
+ <entry><literal>Engine</literal></entry>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SUPPORT</literal></entry>
+ <entry><literal>Support</literal></entry>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>COMMENT</literal></entry>
+ <entry><literal>Comment</literal></entry>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>TRANSACTIONS</literal></entry>
+ <entry><literal>Transactions</literal></entry>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>XA</literal></entry>
+ <entry><literal>XA</literal></entry>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SAVEPOINTS</literal></entry>
+ <entry><literal>Savepoints</literal></entry>
+ <entry/>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ <para>
+ <emphasis role="bold">Notes</emphasis>:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>ENGINES</literal> table was added in MySQL
+ 5.1.5.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ See also <xref linkend="show-engines"/>.
+ </para>
+
+ </section>
+
+ <section id="partitions-table">
+
+ <title>&title-partitions-table;</title>
+
+ <indexterm type="function">
+ <primary>PARTITIONS</primary>
+ <secondary>INFORMATION_SCHEMA table</secondary>
+ </indexterm>
+
+ <para>
+ The <literal>PARTITIONS</literal> table provides information
+ about table partitions.
+ </para>
+
+ <informaltable>
+ <tgroup cols="3">
+ <colspec colwidth="40*"/>
+ <colspec colwidth="30*"/>
+ <colspec colwidth="30*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold">Remarks</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>TABLE_CATALOG</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>TABLE_SCHEMA</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>TABLE_NAME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PARTITION_NAME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SUBPARTITION_NAME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PARTITION_ORDINAL_POSITION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SUBPARTITION_ORDINAL_POSITION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PARTITION_METHOD</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SUBPARTITION_METHOD</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PARTITION_EXPRESSION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SUBPARTITION_EXPRESSION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PARTITION_DESCRIPTION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>TABLE_ROWS</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>AVG_ROW_LENGTH</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>DATA_LENGTH</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>MAX_DATA_LENGTH</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>INDEX_LENGTH</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>DATA_FREE</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>CREATE_TIME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>UPDATE_TIME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>CHECK_TIME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>CHECKSUM</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>PARTITION_COMMENT</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>NODEGROUP</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>TABLESPACE_NAME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ <para>
+ <emphasis role="bold">Notes</emphasis>:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>PARTITIONS</literal> table was added in MySQL
+ 5.1.6.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <remark role="todo">
+ Add xref to SHOW PARTITIONS when that is implemented.
+ </remark>
+
+ </section>
+
<section id="other-information-schema-tables">
<title>&title-other-information-schema-tables;</title>
Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml 2006-01-19 01:31:03 UTC (rev 914)
+++ trunk/refman-5.1/partitioning.xml 2006-01-19 02:09:10 UTC (rev 915)
@@ -81,7 +81,7 @@
possible to filter this list according to a number of criteria,
or you may wish to start from the
<ulink url="http://bugs.mysql.com/">MySQL Bugs System Home
- Page</ulink> and search for bugs which are of particular
+ Page</ulink> and search for bugs which are of particular
interest to you.
</para>
</listitem>
@@ -119,8 +119,8 @@
</itemizedlist>
<para>
- MySQL 5.1 alpha binaries are now available from
- <ulink url="http://dev.mysql.com/downloads/mysql/5.1.html"/>.
+ MySQL 5.1 alpha binaries are now available from
+ <ulink url="http://dev.mysql.com/downloads/mysql/5.1.html"/>.
However, for the latest partitioning bugfixes and feature additions,
you can obtain the source from our BitKeeper repository. To enable
partitioning, you need to compile the server using the
@@ -3058,13 +3058,10 @@
</itemizedlist>
<para>
- Planning is also underway to augment the
- <literal>INFORMATION_SCHEMA</literal> database to provide
- information about partitioned tables and partitions. This
- planning is currently in a very early phase; we will update the
- relevant portions of the Manual as additional information
- becomes available and any new partitioning-related extensions to
- <literal>INFORMATION_SCHEMA</literal> are implemented.
+ You can also obtain information about partitions from
+ <literal>INFORMATION_SCHEMA</literal>, which contains a
+ <literal>PARTITIONS</literal> table. See
+ <xref linkend="partitions-table"/>.
</para>
</section>
Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml 2006-01-19 01:31:03 UTC (rev 914)
+++ trunk/refman-common/news-5.1.xml 2006-01-19 02:09:10 UTC (rev 915)
@@ -70,6 +70,13 @@
<listitem>
<para>
+ Added the <literal>INFORMATION_SCHEMA PARTITIONS</literal>
+ table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Subselect could return wrong results when records cache and
grouping was involved. (Bug #15347)
</para>
@@ -137,6 +144,18 @@
<listitem>
<para>
+ Added the <literal>INFORMATION_SCHEMA ENGINES</literal> table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Added the <literal>INFORMATION_SCHEMA PLUGINS</literal> table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Added the <literal>binlog_format</literal> system variable
that controls whether to use row-based or statement-based
binary logging. Added the <option>--binlog-format</option> and
@@ -260,14 +279,10 @@
<literal>LIST</literal> a value less than any specified in one
of the table's partition definitions resulted in a server
crash. In such cases, <command>mysqld</command> now returns
-
<errortext>ERROR 1500 (HY000): Table has no partition for
- value <replaceable>v</replaceable>
-
- </errortext>
-
- , where <replaceable>v</replaceable> is the out-of-range
- value. (Bug #15819)
+ value <replaceable>v</replaceable> </errortext> , where
+ <replaceable>v</replaceable> is the out-of-range value. (Bug
+ #15819)
</para>
</listitem>
@@ -406,11 +421,8 @@
<para>
Previously, attempting to do so would produce the error
-
<errortext>All partitions must have unique names in the
- table</errortext>
-
- . (Bug #15521)
+ table</errortext> . (Bug #15521)
</para>
</listitem>
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2006-01-19 01:31:03 UTC (rev 914)
+++ trunk/refman-common/titles.en.ent 2006-01-19 02:09:10 UTC (rev 915)
@@ -341,6 +341,7 @@
<!ENTITY title-dynamic-system-variables "Dynamic System Variables">
<!ENTITY title-eiffel "MySQL Eiffel Wrapper">
<!ENTITY title-encryption-functions "Encryption Functions">
+<!ENTITY title-engines-table "The <literal>INFORMATION_SCHEMA ENGINES</literal> Table">
<!ENTITY title-entering-queries "Entering Queries">
<!ENTITY title-enum "The <literal>ENUM</literal> Type">
<!ENTITY title-environment-variable-options "Using Environment Variables to Specify Options">
@@ -1319,6 +1320,7 @@
<!ENTITY title-partitioning-range "<literal>RANGE</literal> Partitioning">
<!ENTITY title-partitioning-subpartitions "Subpartitioning">
<!ENTITY title-partitioning-types "Partition Types">
+<!ENTITY title-partitions-table "The <literal>INFORMATION_SCHEMA PARTITIONS</literal> Table">
<!ENTITY title-password-hashing "Password Hashing as of MySQL 4.1">
<!ENTITY title-password-hashing-4-1-0 "Password Hashing in MySQL 4.1.0">
<!ENTITY title-password-security "Keeping Your Password Secure">
@@ -1352,6 +1354,7 @@
<!ENTITY title-plugin-creating "Creating a Plugin Library">
<!ENTITY title-plugin-full-text-plugins "Full-Text Parser Plugins">
<!ENTITY title-plugin-writing "Writing Plugins">
+<!ENTITY title-plugins-table "The <literal>INFORMATION_SCHEMA PLUGINS</literal> Table">
<!ENTITY title-point-in-time-recovery "Point-in-Time Recovery">
<!ENTITY title-point-in-time-recovery-positions "Specifying Positions for Recovery">
<!ENTITY title-point-in-time-recovery-times "Specifying Times for Recovery">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r915 - in trunk: . refman-5.1 refman-common | paul | 19 Jan |
