List:Commits« Previous MessageNext Message »
From:paul Date:January 19 2006 2:09am
Subject:svn commit - mysqldoc@docsrva: r915 - in trunk: . refman-5.1 refman-common
View as plain text  
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-commonpaul19 Jan