List:Commits« Previous MessageNext Message »
From:paul.dubois Date:September 10 2010 8:42pm
Subject: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
View as plain text  
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.0paul.dubois10 Sep