Author: paul
Date: 2010-03-12 20:24:03 +0100 (Fri, 12 Mar 2010)
New Revision: 19528
Log:
r56846@frost: paul | 2010-03-12 13:17:31 -0500
New FLUSH log_type LOGS syntax.
Bug#14104: FLUSH LOGS should take optional arguments for which log(s) to flush
WL#5142: FLUSH LOGS should take optional arguments for which log(s) to flush
Modified:
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/refman-5.5/sql-syntax-server-administration.xml
trunk/refman-6.0/sql-syntax-server-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:37390
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:56844
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:37390
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:56846
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2010-03-12 18:02:53 UTC (rev 19527)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2010-03-12 19:24:03 UTC (rev 19528)
Changed blocks: 1, Lines Added: 69, Lines Deleted: 0; 1929 bytes
@@ -8136,4 +8136,73 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="FLUSH LOGS"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="14104"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.3"/>
+ <version ver="6.0.14"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <literal role="stmt" condition="flush">FLUSH LOGS</literal> now
+ takes an optional <replaceable>log_type</replaceable> value so
+ that <literal role="stmt" condition="flush">FLUSH
+ <replaceable>log_type</replaceable> LOGS</literal> can be used
+ to flush only a specified log type. These
+ <replaceable>log_type</replaceable> options are allowed:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>BINARY</literal> closes and reopens the binary log
+ files.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ENGINE</literal> closes and reopens any flushable
+ logs for installed storage engines.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ERROR</literal> closes and reopens the error log
+ file.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>GENERAL</literal> closes and reopens the general
+ query log file.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>RELAY</literal> closes and reopens the relay log
+ files.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/refman-5.5/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.5/sql-syntax-server-administration.xml 2010-03-12 18:02:53 UTC (rev 19527)
+++ trunk/refman-5.5/sql-syntax-server-administration.xml 2010-03-12 19:24:03 UTC (rev 19528)
Changed blocks: 2, Lines Added: 54, Lines Deleted: 2; 2561 bytes
@@ -9637,11 +9637,14 @@
<listitem>
<para>
- <literal>LOGS</literal>
+ <literal>[<replaceable>log_type</replaceable>]
+ LOGS</literal>
</para>
<para>
- Closes and reopens all log files. If binary logging is
+ With no <replaceable>log_type</replaceable> option,
+ <literal role="stmt" condition="flush">FLUSH LOGS</literal>
+ closes and reopens all log files. If binary logging is
enabled, the sequence number of the binary log file is
incremented by one relative to the previous file. On Unix,
this is the same thing as sending a
@@ -9661,6 +9664,55 @@
No renaming occurs if the server is not writing to a named
file (for example, if it is writing errors to the console).
</para>
+
+ <para>
+ With a <replaceable>log_type</replaceable> option, only the
+ specified log type is flushed. These
+ <replaceable>log_type</replaceable> options are allowed:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>BINARY</literal> closes and reopens the binary
+ log files.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ENGINE</literal> closes and reopens any
+ flushable logs for installed storage engines.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ERROR</literal> closes and reopens the error
+ log file.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>GENERAL</literal> closes and reopens the
+ general query log file.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>RELAY</literal> closes and reopens the relay
+ log files.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ These options were added in MySQL 5.5.3.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml 2010-03-12 18:02:53 UTC (rev 19527)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml 2010-03-12 19:24:03 UTC (rev 19528)
Changed blocks: 3, Lines Added: 62, Lines Deleted: 13; 3209 bytes
@@ -10158,17 +10158,6 @@
<listitem>
<para>
- <literal>BACKUP LOGS</literal>
- </para>
-
- <para>
- Closes and reopens the backup log files. This option was
- added in MySQL 6.0.8.
- </para>
- </listitem>
-
- <listitem>
- <para>
<literal>DES_KEY_FILE</literal>
</para>
@@ -10204,11 +10193,14 @@
<listitem>
<para>
- <literal>LOGS</literal>
+ <literal>[<replaceable>log_type</replaceable>]
+ LOGS</literal>
</para>
<para>
- Closes and reopens all log files. If binary logging is
+ With no <replaceable>log_type</replaceable> option,
+ <literal role="stmt" condition="flush">FLUSH LOGS</literal>
+ closes and reopens all log files. If binary logging is
enabled, the sequence number of the binary log file is
incremented by one relative to the previous file. On Unix,
this is the same thing as sending a
@@ -10228,6 +10220,63 @@
No renaming occurs if the server is not writing to a named
file (for example, if it is writing errors to the console).
</para>
+
+ <para>
+ With a <replaceable>log_type</replaceable> option, only the
+ specified log type is flushed. These
+ <replaceable>log_type</replaceable> options are allowed:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>BACKUP</literal> closes and reopens the backup
+ log files.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>BINARY</literal> closes and reopens the binary
+ log files.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ENGINE</literal> closes and reopens any
+ flushable logs for installed storage engines.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>ERROR</literal> closes and reopens the error
+ log file.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>GENERAL</literal> closes and reopens the
+ general query log file.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>RELAY</literal> closes and reopens the relay
+ log files.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The <literal>BACKUP</literal> option was added in MySQL
+ 6.0.8. The others were added in MySQL 6.0.14.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r19528 - in trunk: . dynamic-docs/changelog refman-5.5 refman-6.0 | paul.dubois | 12 Mar 2010 |
