Author: paul
Date: 2007-12-17 18:39:52 +0100 (Mon, 17 Dec 2007)
New Revision: 9355
Log:
r28213@frost: paul | 2007-12-17 11:35:33 -0600
The general query log and slow query low now *can* be renamed while the
server has them open on Windows. (Bug#29750)
Modified:
trunk/dynamic-docs/changelog/mysqld.xml
trunk/refman-5.0/dba-core.xml
trunk/refman-5.1/dba-core-new-tmp.xml
trunk/refman-5.1/dba-core.xml
trunk/refman-6.0/dba-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34357
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28209
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:22582
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34357
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28213
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:22582
Modified: trunk/dynamic-docs/changelog/mysqld.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld.xml 2007-12-17 17:39:42 UTC (rev 9354)
+++ trunk/dynamic-docs/changelog/mysqld.xml 2007-12-17 17:39:52 UTC (rev 9355)
Changed blocks: 4, Lines Added: 10, Lines Deleted: 7; 2105 bytes
@@ -56689,13 +56689,17 @@
<versions>
<version ver="5.0.17"/>
+ <version ver="5.1.3"/>
</versions>
<message>
<para>
<literal>RESET MASTER</literal> failed to delete log files on
- Windows.
+ Windows. One consequence of this change is that server opens the
+ general query and slow log files in shared mode, so now they can
+ be renamed while the server has them open (something not true in
+ previous versions).
</para>
</message>
@@ -84305,8 +84309,8 @@
<para>
Fixed a bug which caused the server to crash on attempt to
execute a prepared statement with
- <function role="sqlop" condition="between">BETWEEN ?
- AND ?</function> and a datetime column.
+ <function role="sqlop" condition="between">BETWEEN ? AND
+ ?</function> and a datetime column.
</para>
</message>
@@ -110060,8 +110064,8 @@
<function role="sql">CHAR()</function> can return
<literal>NULL</literal>, but did not signal that to the query
processor, causing incorrect results for
- <function role="sqlop" condition="is-null">IS
- NULL</function> operations.
+ <function role="sqlop" condition="is-null">IS NULL</function>
+ operations.
</para>
</message>
@@ -139986,8 +139990,7 @@
<para>
Comparison results for <function role="sqlop">BETWEEN</function>
were different from those for operators like
- <function role="sqlop" condition="less-than"><</function>
- and
+ <function role="sqlop" condition="less-than"><</function> and
<function role="sqlop" condition="greater-than">></function>
for <literal>DATETIME</literal>-like values with trailing extra
characters such as <literal>'2007-10-01 00:00:00
Modified: trunk/refman-5.0/dba-core.xml
===================================================================
--- trunk/refman-5.0/dba-core.xml 2007-12-17 17:39:42 UTC (rev 9354)
+++ trunk/refman-5.0/dba-core.xml 2007-12-17 17:39:52 UTC (rev 9355)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 6; 1785 bytes
@@ -11547,9 +11547,14 @@
</programlisting>
<para>
- On Windows, you cannot rename the 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.
+ 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>FLUSH
+ LOGS</literal>, which causes the server to rename the error log
+ with an <filename>-old</filename> suffix and open a new error
+ log.
</para>
</section>
@@ -12391,9 +12396,14 @@
</para>
<para>
- On Windows, you cannot rename log files while the server has
- them open. You must stop the server and rename them, and then
- restart the server to create new logs.
+ 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>FLUSH
+ LOGS</literal>, which causes the server to rename the error log
+ with an <filename>-old</filename> suffix and open a new error
+ log.
</para>
<para>
Modified: trunk/refman-5.1/dba-core-new-tmp.xml
===================================================================
--- trunk/refman-5.1/dba-core-new-tmp.xml 2007-12-17 17:39:42 UTC (rev 9354)
+++ trunk/refman-5.1/dba-core-new-tmp.xml 2007-12-17 17:39:52 UTC (rev 9355)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 6; 1803 bytes
@@ -12595,9 +12595,14 @@
</programlisting>
<para>
- On Windows, you cannot rename the 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.
+ 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>FLUSH
+ LOGS</literal>, which causes the server to rename the error log
+ with an <filename>-old</filename> suffix and open a new error
+ log.
</para>
<para>
@@ -14311,9 +14316,14 @@
</para>
<para>
- On Windows, you cannot rename log files while the server has
- them open. You must stop the server and rename them, and then
- restart the server to create new logs.
+ 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>FLUSH
+ LOGS</literal>, which causes the server to rename the error log
+ with an <filename>-old</filename> suffix and open a new error
+ log.
</para>
<para>
Modified: trunk/refman-5.1/dba-core.xml
===================================================================
--- trunk/refman-5.1/dba-core.xml 2007-12-17 17:39:42 UTC (rev 9354)
+++ trunk/refman-5.1/dba-core.xml 2007-12-17 17:39:52 UTC (rev 9355)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 6; 1779 bytes
@@ -12595,9 +12595,14 @@
</programlisting>
<para>
- On Windows, you cannot rename the 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.
+ 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>FLUSH
+ LOGS</literal>, which causes the server to rename the error log
+ with an <filename>-old</filename> suffix and open a new error
+ log.
</para>
<para>
@@ -14311,9 +14316,14 @@
</para>
<para>
- On Windows, you cannot rename log files while the server has
- them open. You must stop the server and rename them, and then
- restart the server to create new logs.
+ 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>FLUSH
+ LOGS</literal>, which causes the server to rename the error log
+ with an <filename>-old</filename> suffix and open a new error
+ log.
</para>
<para>
Modified: trunk/refman-6.0/dba-core.xml
===================================================================
--- trunk/refman-6.0/dba-core.xml 2007-12-17 17:39:42 UTC (rev 9354)
+++ trunk/refman-6.0/dba-core.xml 2007-12-17 17:39:52 UTC (rev 9355)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 6; 1841 bytes
@@ -12188,9 +12188,14 @@
</programlisting>
<para>
- On Windows, you cannot rename the 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.
+ 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>FLUSH LOGS</literal>, which causes the server to rename
+ the error log with an <filename>-old</filename> suffix and open
+ a new error log.
</para>
<para>
@@ -13862,9 +13867,14 @@
</para>
<para>
- On Windows, you cannot rename log files while the server has
- them open. You must stop the server and rename them, and then
- restart the server to create new logs.
+ 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>FLUSH LOGS</literal>, which causes the server to rename
+ the error log with an <filename>-old</filename> suffix and open
+ a new error log.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9355 - in trunk: . dynamic-docs/changelog refman-5.0 refman-5.1 refman-6.0 | paul | 17 Dec |
