Author: paul
Date: 2010-09-10 22:42:33 +0200 (Fri, 10 Sep 2010)
New Revision: 22686
Log:
r63179@frost: paul | 2010-09-10 15:42:15 -0500
Revise log maintenance material some more
Modified:
trunk/refman-4.1/dba-log-files.xml
trunk/refman-5.0/dba-log-files.xml
trunk/refman-5.1/dba-log-files.xml
trunk/refman-5.5/dba-log-files.xml
trunk/refman-5.6/dba-log-files.xml
trunk/refman-6.0/dba-log-files.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:42410
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:63178
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:42410
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:63179
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/refman-4.1/dba-log-files.xml
===================================================================
--- trunk/refman-4.1/dba-log-files.xml 2010-09-10 20:42:27 UTC (rev 22685)
+++ trunk/refman-4.1/dba-log-files.xml 2010-09-10 20:42:33 UTC (rev 22686)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 6; 1613 bytes
@@ -966,17 +966,18 @@
If update logging
(<option role="mysqld">--log-update</option>) or binary
logging (<option role="mysqld">--log-bin</option>) is used,
- closes the log and opens a new log file with a higher sequence
- number.
+ the server closes the log and opens a new log file with a
+ higher sequence number.
</para>
</listitem>
<listitem>
<para>
- If the server was given an error log file name with the
- <option role="mysqld">--log-error</option> option, it renames
- the current log file with the suffix <literal>-old</literal>
- and creates a new empty error log file.
+ If the server was started with the
+ <option role="mysqld">--log-error</option> option to cause the
+ error log to be written to a file, it renames the current log
+ file with the suffix <literal>-old</literal> and creates a new
+ empty error log file.
</para>
</listitem>
@@ -1001,6 +1002,11 @@
</programlisting>
<para>
+ On Windows, use <command>rename</command> rather than
+ <command>mv</command>.
+ </para>
+
+ <para>
At this point, you can make a backup of
<filename>mysql.old</filename> and
<filename>mysql-slow.old</filename> and then remove them from
Modified: trunk/refman-5.0/dba-log-files.xml
===================================================================
--- trunk/refman-5.0/dba-log-files.xml 2010-09-10 20:42:27 UTC (rev 22685)
+++ trunk/refman-5.0/dba-log-files.xml 2010-09-10 20:42:33 UTC (rev 22686)
Changed blocks: 3, Lines Added: 19, Lines Deleted: 12; 2402 bytes
@@ -924,10 +924,11 @@
<listitem>
<para>
- If the server was given an error log file name with the
- <option role="mysqld">--log-error</option> option, it renames
- the current log file with the suffix <literal>-old</literal>
- and creates a new empty error log file.
+ If the server was started with the
+ <option role="mysqld">--log-error</option> option to cause the
+ error log to be written to a file, it renames the current log
+ file with the suffix <literal>-old</literal> and creates a new
+ empty error log file.
</para>
</listitem>
@@ -952,6 +953,11 @@
</programlisting>
<para>
+ On Windows, use <command>rename</command> rather than
+ <command>mv</command>.
+ </para>
+
+ <para>
At this point, you can make a backup of
<filename>mysql.old</filename> and
<filename>mysql-slow.old</filename> and then remove them from
@@ -959,14 +965,15 @@
</para>
<para>
- Before 5.0.17, you cannot rename a log file on Windows while the
- server has it open. You must stop the server and rename the file,
- and then restart the server to create a new log file. As of
- 5.0.17, this applies only to the error log. However, a stop and
- restart can be avoided by using
- <literal role="stmt" condition="flush">FLUSH LOGS</literal>, which
- causes the server to rename the error log with an
- <filename>-old</filename> suffix and open a new error log.
+ For older versions of MySQL, you cannot rename certain log files
+ on Windows while the server has them open. Before MySQL 5.0.17,
+ this restriction applies to all log files. You must stop the
+ server, rename the file, then restart the server to create a new
+ log file. From 5.0.18 on, the restriction applies only to the
+ error log file. To rename the error log file, a stop and restart
+ can be avoided by flushing the logs to cause the server to rename
+ the current log file with the suffix <literal>-old</literal> and
+ create a new empty error log file.
</para>
<para>
Modified: trunk/refman-5.1/dba-log-files.xml
===================================================================
--- trunk/refman-5.1/dba-log-files.xml 2010-09-10 20:42:27 UTC (rev 22685)
+++ trunk/refman-5.1/dba-log-files.xml 2010-09-10 20:42:33 UTC (rev 22686)
Changed blocks: 4, Lines Added: 24, Lines Deleted: 17; 2826 bytes
@@ -2625,10 +2625,11 @@
<listitem>
<para>
- If the server was given an error log file name with the
- <option role="mysqld">--log-error</option> option, it renames
- the current log file with the suffix <literal>-old</literal>
- and creates a new empty error log file.
+ If the server was started with the
+ <option role="mysqld">--log-error</option> option to cause the
+ error log to be written to a file, it renames the current log
+ file with the suffix <literal>-old</literal> and creates a new
+ empty error log file.
</para>
</listitem>
@@ -2653,6 +2654,11 @@
</programlisting>
<para>
+ On Windows, use <command>rename</command> rather than
+ <command>mv</command>.
+ </para>
+
+ <para>
At this point, you can make a backup of
<filename>mysql.old</filename> and
<filename>mysql-slow.old</filename> and then remove them from
@@ -2660,21 +2666,10 @@
</para>
<para>
- Before 5.1.3, you cannot rename a log file on Windows while the
- server has it open. You must stop the server and rename the file,
- and then restart the server to create a new log file. As of 5.1.3,
- this applies only to the error log. However, a stop and restart
- can be avoided by using
- <literal role="stmt" condition="flush">FLUSH LOGS</literal>, which
- causes the server to rename the error log with an
- <filename>-old</filename> suffix and open a new error log.
+ As of MySQL 5.1.12, you can rename the general query log or slow
+ query log at runtime by disabling the log:
</para>
- <para>
- As of MySQL 5.1.2, you can disable the general query log or slow
- query log at runtime:
- </para>
-
<programlisting>
SET GLOBAL general_log = 'OFF';
SET GLOBAL slow_query_log = 'OFF';
@@ -2695,6 +2690,18 @@
restart.
</para>
+ <para>
+ For older versions of MySQL, you cannot rename certain log files
+ on Windows while the server has them open. Before MySQL 5.1.3,
+ this restriction applies to all log files. You must stop the
+ server, rename the file, then restart the server to create a new
+ log file. From 5.1.4 to 5.1.50, the restriction applies only to
+ the error log file. To rename the error log file, a stop and
+ restart can be avoided by flushing the logs to cause the server to
+ rename the current log file with the suffix
+ <literal>-old</literal> and create a new empty error log file.
+ </para>
+
</section>
</section>
Modified: trunk/refman-5.5/dba-log-files.xml
===================================================================
--- trunk/refman-5.5/dba-log-files.xml 2010-09-10 20:42:27 UTC (rev 22685)
+++ trunk/refman-5.5/dba-log-files.xml 2010-09-10 20:42:33 UTC (rev 22686)
Changed blocks: 4, Lines Added: 20, Lines Deleted: 17; 2565 bytes
@@ -2695,10 +2695,11 @@
<listitem>
<para>
- If the server was given an error log file name with the
- <option role="mysqld">--log-error</option> option, it renames
- the current log file with the suffix <literal>-old</literal>
- and creates a new empty error log file.
+ If the server was started with the
+ <option role="mysqld">--log-error</option> option to cause the
+ error log to be written to a file, it renames the current log
+ file with the suffix <literal>-old</literal> and creates a new
+ empty error log file.
</para>
</listitem>
@@ -2723,6 +2724,11 @@
</programlisting>
<para>
+ On Windows, use <command>rename</command> rather than
+ <command>mv</command>.
+ </para>
+
+ <para>
At this point, you can make a backup of
<filename>mysql.old</filename> and
<filename>mysql-slow.old</filename> and then remove them from
@@ -2730,21 +2736,10 @@
</para>
<para>
- On Windows, you can rename the general query log or slow query log
- while the server has it open. You cannot rename the error log file
- while the server has it open. You must stop the server and rename
- the file, and then restart the server to create a new log file.
- However, a stop and restart can be avoided by using
- <literal role="stmt" condition="flush">FLUSH LOGS</literal>, which
- causes the server to rename the error log with an
- <filename>-old</filename> suffix and open a new error log.
+ You can rename the general query log or slow query log at runtime
+ by disabling the log:
</para>
- <para>
- You can disable the general query log or slow query log at
- runtime:
- </para>
-
<programlisting>
SET GLOBAL general_log = 'OFF';
SET GLOBAL slow_query_log = 'OFF';
@@ -2765,6 +2760,14 @@
restart.
</para>
+ <para>
+ On Windows, you cannot rename the error log file on Windows while
+ the server has it open before MySQL 5.5.7. To rename the error log
+ file, a stop and restart can be avoided by flushing the logs to
+ cause the server to rename the current log file with the suffix
+ <literal>-old</literal> and create a new empty error log file.
+ </para>
+
</section>
</section>
Modified: trunk/refman-5.6/dba-log-files.xml
===================================================================
--- trunk/refman-5.6/dba-log-files.xml 2010-09-10 20:42:27 UTC (rev 22685)
+++ trunk/refman-5.6/dba-log-files.xml 2010-09-10 20:42:33 UTC (rev 22686)
Changed blocks: 4, Lines Added: 20, Lines Deleted: 17; 2546 bytes
@@ -2667,10 +2667,11 @@
<listitem>
<para>
- If the server was given an error log file name with the
- <option role="mysqld">--log-error</option> option, it renames
- the current log file with the suffix <literal>-old</literal>
- and creates a new empty error log file.
+ If the server was started with the
+ <option role="mysqld">--log-error</option> option to cause the
+ error log to be written to a file, it renames the current log
+ file with the suffix <literal>-old</literal> and creates a new
+ empty error log file.
</para>
</listitem>
@@ -2695,6 +2696,11 @@
</programlisting>
<para>
+ On Windows, use <command>rename</command> rather than
+ <command>mv</command>.
+ </para>
+
+ <para>
At this point, you can make a backup of
<filename>mysql.old</filename> and
<filename>mysql-slow.old</filename> and then remove them from
@@ -2702,21 +2708,10 @@
</para>
<para>
- On Windows, you can rename the general query log or slow query log
- while the server has it open. You cannot rename the error log file
- while the server has it open. You must stop the server and rename
- the file, and then restart the server to create a new log file.
- However, a stop and restart can be avoided by using
- <literal role="stmt" condition="flush">FLUSH LOGS</literal>, which
- causes the server to rename the error log with an
- <filename>-old</filename> suffix and open a new error log.
+ You can rename the general query log or slow query log at runtime
+ by disabling the log:
</para>
- <para>
- You can disable the general query log or slow query log at
- runtime:
- </para>
-
<programlisting>
SET GLOBAL general_log = 'OFF';
SET GLOBAL slow_query_log = 'OFF';
@@ -2737,6 +2732,14 @@
restart.
</para>
+ <para>
+ On Windows, you cannot rename the error log file on Windows while
+ the server has it open. To rename the error log file, a stop and
+ restart can be avoided by flushing the logs to cause the server to
+ rename the current log file with the suffix
+ <literal>-old</literal> and create a new empty error log file.
+ </para>
+
</section>
</section>
Modified: trunk/refman-6.0/dba-log-files.xml
===================================================================
--- trunk/refman-6.0/dba-log-files.xml 2010-09-10 20:42:27 UTC (rev 22685)
+++ trunk/refman-6.0/dba-log-files.xml 2010-09-10 20:42:33 UTC (rev 22686)
Changed blocks: 4, Lines Added: 20, Lines Deleted: 17; 2546 bytes
@@ -2770,10 +2770,11 @@
<listitem>
<para>
- If the server was given an error log file name with the
- <option role="mysqld">--log-error</option> option, it renames
- the current log file with the suffix <literal>-old</literal>
- and creates a new empty error log file.
+ If the server was started with the
+ <option role="mysqld">--log-error</option> option to cause the
+ error log to be written to a file, it renames the current log
+ file with the suffix <literal>-old</literal> and creates a new
+ empty error log file.
</para>
</listitem>
@@ -2798,6 +2799,11 @@
</programlisting>
<para>
+ On Windows, use <command>rename</command> rather than
+ <command>mv</command>.
+ </para>
+
+ <para>
At this point, you can make a backup of
<filename>mysql.old</filename> and
<filename>mysql-slow.old</filename> and then remove them from
@@ -2805,21 +2811,10 @@
</para>
<para>
- On Windows, you can rename the general query log or slow query log
- while the server has it open. You cannot rename the error log file
- while the server has it open. You must stop the server and rename
- the file, and then restart the server to create a new log file.
- However, a stop and restart can be avoided by using
- <literal role="stmt" condition="flush">FLUSH LOGS</literal>, which
- causes the server to rename the error log with an
- <filename>-old</filename> suffix and open a new error log.
+ You can rename the general query log or slow query log at runtime
+ by disabling the log:
</para>
- <para>
- You can disable the general query log or slow query log at
- runtime:
- </para>
-
<programlisting>
SET GLOBAL general_log = 'OFF';
SET GLOBAL slow_query_log = 'OFF';
@@ -2840,6 +2835,14 @@
restart.
</para>
+ <para>
+ On Windows, you cannot rename the error log file on Windows while
+ the server has it open. To rename the error log file, a stop and
+ restart can be avoided by flushing the logs to cause the server to
+ rename the current log file with the suffix
+ <literal>-old</literal> and create a new empty error log file.
+ </para>
+
</section>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r22686 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.5 refman-5.6 refman-6.0 | paul.dubois | 10 Sep |
