Author: paul
Date: 2006-01-21 06:57:36 +0100 (Sat, 21 Jan 2006)
New Revision: 966
Log:
r6514@frost: paul | 2006-01-20 23:51:19 -0600
SHOW PLUGIN statement.
Modified:
trunk/
trunk/refman-5.1/extending-mysql.xml
trunk/refman-5.1/sql-syntax.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:6513
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2396
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6514
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2396
Modified: trunk/refman-5.1/extending-mysql.xml
===================================================================
--- trunk/refman-5.1/extending-mysql.xml 2006-01-21 05:57:21 UTC (rev 965)
+++ trunk/refman-5.1/extending-mysql.xml 2006-01-21 05:57:36 UTC (rev 966)
@@ -693,6 +693,15 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ <literal>SHOW PLUGIN</literal> displays information about
+ known plugins. The <literal>PLUGINS</literal> table in
+ <literal>INFORMATION_SCHEMA</literal> also contains plugin
+ information.
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -959,12 +968,17 @@
change to perform any final cleanup.
</para>
+ <remark role="help-description-end"/>
+
<para>
To remove a plugin entirely, use the <literal>UNINSTALL
PLUGIN</literal> statement:
</para>
- <remark role="help-description-end"/>
+ <para>
+ To see what plugins are installed, use the <literal>SHOW
+ PLUGIN</literal> statement.
+ </para>
<para>
If you recompile a plugin library and need to reinstall it, you
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-01-21 05:57:21 UTC (rev 965)
+++ trunk/refman-5.1/sql-syntax.xml 2006-01-21 05:57:36 UTC (rev 966)
@@ -14847,6 +14847,10 @@
</indexterm>
<indexterm type="function">
+ <primary>SHOW PLUGIN</primary>
+ </indexterm>
+
+ <indexterm type="function">
<primary>SHOW PRIVILEGES</primary>
</indexterm>
@@ -14892,7 +14896,7 @@
COLUMNS LIKE TABLES OPEN FROM INDEX INDEXES STATUS VARIABLES
DATABASE SCHEMA DATABASES SCHEMAS LOGS FULL PROCESSLIST FOR
GRANTS TABLE CREATE WARNINGS ERRORS TYPES FIELDS HOSTS KEYS
- ENGINE ENGINES INNODB
+ ENGINE ENGINES INNODB PLUGIN
</remark>
<remark role="help-description-begin"/>
@@ -14915,6 +14919,7 @@
SHOW INDEX FROM <replaceable>tbl_name</replaceable> [FROM <replaceable>db_name</replaceable>]
SHOW INNODB STATUS
SHOW [BDB] LOGS
+SHOW PLUGIN
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW [GLOBAL | SESSION] STATUS [LIKE '<replaceable>pattern</replaceable>']
@@ -15982,6 +15987,57 @@
</section>
+ <section id="show-plugin">
+
+ <title>&title-show-plugin;</title>
+
+ <indexterm type="function">
+ <primary>SHOW PLUGIN</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW PLUGIN"/>
+
+ <remark role="help-keywords">
+ SHOW PLUGIN
+ </remark>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW PLUGIN
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ <literal>SHOW PLUGIN</literal> displays information about
+ known plugins.
+ </para>
+
+<programlisting>
+mysql> <userinput>SHOW PLUGIN;</userinput>
++------------+--------+----------------+---------+
+| Name | Status | Type | Library |
++------------+--------+----------------+---------+
+| MEMORY | ACTIVE | STORAGE ENGINE | NULL |
+| MyISAM | ACTIVE | STORAGE ENGINE | NULL |
+| InnoDB | ACTIVE | STORAGE ENGINE | NULL |
+| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL |
+| CSV | ACTIVE | STORAGE ENGINE | NULL |
+| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL |
+| FEDERATED | ACTIVE | STORAGE ENGINE | NULL |
+| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL |
++------------+--------+----------------+---------+
+</programlisting>
+
+ <remark role="help-description-end"/>
+
+ <para>
+ <literal>SHOW PLUGIN</literal> was added in MySQL 5.1.5.
+ </para>
+
+ </section>
+
<section id="show-privileges">
<title>&title-show-privileges;</title>
@@ -18317,8 +18373,8 @@
<listitem>
<para>
If the thread is waiting for free disk space in a write
- call, the write is aborted with a <quote>disk full</quote> error
- message.
+ call, the write is aborted with a <quote>disk full</quote>
+ error message.
</para>
</listitem>
Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml 2006-01-21 05:57:21 UTC (rev 965)
+++ trunk/refman-common/news-5.1.xml 2006-01-21 05:57:36 UTC (rev 966)
@@ -371,7 +371,8 @@
<listitem>
<para>
- Added the <literal>INFORMATION_SCHEMA PLUGINS</literal> table.
+ Added the <literal>INFORMATION_SCHEMA PLUGINS</literal> table and
+the <literal>SHOW PLUGIN</literal> statement.
</para>
</listitem>
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2006-01-21 05:57:21 UTC (rev 965)
+++ trunk/refman-common/titles.en.ent 2006-01-21 05:57:36 UTC (rev 966)
@@ -1523,6 +1523,7 @@
<!ENTITY title-show-master-logs "<literal>SHOW MASTER LOGS</literal> Syntax">
<!ENTITY title-show-master-status "<literal>SHOW MASTER STATUS</literal> Syntax">
<!ENTITY title-show-open-tables "<literal>SHOW OPEN TABLES</literal> Syntax">
+<!ENTITY title-show-plugin "<literal>SHOW PLUGIN</literal> Syntax">
<!ENTITY title-show-privileges "<literal>SHOW PRIVILEGES</literal> Syntax">
<!ENTITY title-show-procedure-status "<literal>SHOW PROCEDURE STATUS</literal> and <literal>SHOW FUNCTION STATUS</literal> Syntax">
<!ENTITY title-show-processlist "<literal>SHOW PROCESSLIST</literal> Syntax">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r966 - in trunk: . refman-5.1 refman-common | paul | 21 Jan |
