From: Date: March 12 2010 8:24pm Subject: svn commit - mysqldoc@docsrva: r19528 - in trunk: . dynamic-docs/changelog refman-5.5 refman-6.0 List-Archive: http://lists.mysql.org/commits/103119 Message-Id: <201003121924.o2CJO36F009887@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 @@ + + + + + + + + + + + + + + + + + + + FLUSH LOGS now + takes an optional log_type value so + that FLUSH + log_type LOGS can be used + to flush only a specified log type. These + log_type options are allowed: + + + + + + + BINARY closes and reopens the binary log + files. + + + + + + ENGINE closes and reopens any flushable + logs for installed storage engines. + + + + + + ERROR closes and reopens the error log + file. + + + + + + GENERAL closes and reopens the general + query log file. + + + + + + RELAY closes and reopens the relay log + files. + + + + + + + + + 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 @@ - LOGS + [log_type] + LOGS - Closes and reopens all log files. If binary logging is + With no log_type option, + FLUSH LOGS + 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). + + + With a log_type option, only the + specified log type is flushed. These + log_type options are allowed: + + + + + + + BINARY closes and reopens the binary + log files. + + + + + + ENGINE closes and reopens any + flushable logs for installed storage engines. + + + + + + ERROR closes and reopens the error + log file. + + + + + + GENERAL closes and reopens the + general query log file. + + + + + + RELAY closes and reopens the relay + log files. + + + + + + + These options were added in MySQL 5.5.3. + 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 @@ - BACKUP LOGS - - - - Closes and reopens the backup log files. This option was - added in MySQL 6.0.8. - - - - - DES_KEY_FILE @@ -10204,11 +10193,14 @@ - LOGS + [log_type] + LOGS - Closes and reopens all log files. If binary logging is + With no log_type option, + FLUSH LOGS + 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). + + + With a log_type option, only the + specified log type is flushed. These + log_type options are allowed: + + + + + + + BACKUP closes and reopens the backup + log files. + + + + + + BINARY closes and reopens the binary + log files. + + + + + + ENGINE closes and reopens any + flushable logs for installed storage engines. + + + + + + ERROR closes and reopens the error + log file. + + + + + + GENERAL closes and reopens the + general query log file. + + + + + + RELAY closes and reopens the relay + log files. + + + + + + + The BACKUP option was added in MySQL + 6.0.8. The others were added in MySQL 6.0.14. +