Author: jstephens
Date: 2007-05-05 16:45:30 +0200 (Sat, 05 May 2007)
New Revision: 6349
Log:
Changes in 5.1.18 to I_S.EVENTS and SHOW EVENTS (part of documentation
of WL#3629)
Modified:
trunk/refman-5.1/information-schema.xml
trunk/refman-5.1/sql-syntax.xml
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2007-05-05 14:13:34 UTC (rev 6348)
+++ trunk/refman-5.1/information-schema.xml 2007-05-05 14:45:30 UTC (rev 6349)
Changed blocks: 4, Lines Added: 31, Lines Deleted: 2; 2133 bytes
@@ -4080,6 +4080,11 @@
<entry/>
<entry>MySQL extension</entry>
</row>
+ <row>
+ <entry><literal>ORIGINATOR</literal></entry>
+ <entry>Originator</entry>
+ <entry>MySQL extension</entry>
+ </row>
</tbody>
</tgroup>
</informaltable>
@@ -4277,9 +4282,19 @@
<listitem>
<para>
- <literal>STATUS</literal>: One of the two values
- <literal>ENABLED</literal> or <literal>DISABLED</literal>.
+ <literal>STATUS</literal>: One of the three values
+ <literal>ENABLED</literal>, <literal>DISABLED</literal>, or
+ <literal>SLAVESIDE_DISABLED</literal>.
</para>
+
+ <para>
+ <literal>SLAVESIDE_DISABLED</literal> was added to the list of
+ possible values for this column in MySQL 5.1.18. This value
+ indicates that the creation of the event occurred on another
+ MySQL server acting as a replication master and was replicated
+ to the current MySQL server which is acting as a slave, but
+ the event is not presently being executed on the slave.
+ </para>
</listitem>
<listitem>
@@ -4323,6 +4338,18 @@
column is an empty string.
</para>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>ORIGINATOR</literal>: The server ID of the MySQL
+ server on which the event was created; used in replication.
+ The default value is 0.
+ </para>
+
+ <para>
+ This column was added in MySQL 5.1.18.
+ </para>
+ </listitem>
</itemizedlist>
@@ -4396,6 +4423,8 @@
LAST_EXECUTED: NULL
EVENT_COMMENT: Saves total number of sessions and
clears the table once per day.
+ ORIGINATOR: 0
+
1 row in set (0.50 sec)
</programlisting>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-05-05 14:13:34 UTC (rev 6348)
+++ trunk/refman-5.1/sql-syntax.xml 2007-05-05 14:45:30 UTC (rev 6349)
Changed blocks: 2, Lines Added: 23, Lines Deleted: 1; 1613 bytes
@@ -19744,6 +19744,7 @@
Starts: 2006-02-09 10:41:23
Ends: 0000-00-00 00:00:00
Status: ENABLED
+ Originator: 0
1 row in set (0.01 sec)
</programlisting>
@@ -19875,9 +19876,30 @@
<listitem>
<para>
<literal>Status</literal>: The event status. One of
- <literal>ENABLED</literal> or <literal>DISABLED</literal>.
+ <literal>ENABLED</literal>, <literal>DISABLED</literal>,
+ or <literal>SLAVESIDE_DISABLED</literal>.
</para>
+
+ <para>
+ <literal>SLAVESIDE_DISABLED</literal> was added in MySQL
+ 5.1.18. This value indicates that the creation of the
+ event occurred on another MySQL server acting as a
+ replication master and replicated to the current MySQL
+ server which is acting as a slave, but the event is not
+ presently being executed on the slave.
+ </para>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>Originator</literal>: The server ID of the MySQL
+ server on which the event was created. Defaults to 0.
+ </para>
+
+ <para>
+ This column was added in MySQL 5.1.18.
+ </para>
+ </listitem>
</itemizedlist>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6349 - trunk/refman-5.1 | jon | 5 May |
