Author: paul
Date: 2008-10-23 20:54:07 +0200 (Thu, 23 Oct 2008)
New Revision: 12139
Log:
r34937@frost: paul | 2008-10-23 13:54:05 -0500
Add entries for backup logging options and variables
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-6.0/backup.xml
trunk/refman-6.0/dba-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34936
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33695
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34937
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33695
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-10-23 18:53:59 UTC (rev 12138)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-10-23 18:54:07 UTC (rev 12139)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 6; 1685 bytes
@@ -30021,14 +30021,36 @@
<message>
<para>
- The names of the MySQL Backup tables in the
- <literal>mysql</literal> database have been changed from
- <literal>online_backup</literal> and
- <literal>online_backup_progress</literal> to
- <literal>backup_history</literal> and
- <literal>backup_progress</literal>.
+ The tables for MySQL Backup logging have been renamed, and the
+ logging capabilities now are more flexible, similar to the
+ capabilities provided for the general query log and slow query
+ log.
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The names of the MySQL Backup log tables in the
+ <literal>mysql</literal> database have been changed from
+ <literal>online_backup</literal> and
+ <literal>online_backup_progress</literal> to
+ <literal>backup_history</literal> and
+ <literal>backup_progress</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Logging now can be enabled or disabled, it is possible to
+ log to tables or to files, and the names of the log files
+ can be changed. For details, see
+ <xref linkend="backup-database-restore-log-control"/>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
</message>
</logentry>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2008-10-23 18:53:59 UTC (rev 12138)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2008-10-23 18:54:07 UTC (rev 12139)
Changed blocks: 2, Lines Added: 146, Lines Deleted: 0; 4122 bytes
@@ -5302,6 +5302,118 @@
</mysqloption>
+ <mysqloption section="server" id="backup_history_log">
+
+ <xrefto id="option_mysqld_backup_history_log"/>
+
+ <name>backup_history_log</name>
+
+ <shortdescription lang="en">
+ Enable or disable MySQL Backup history log
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" format="--backup_history_log" setvar="backup_history_log"/>
+ <optype class="mycnf"/>
+ <vartype isdynamic="yes" class="system" scope="global" format="backup_history_log"/>
+ </types>
+
+ <values vartype="boolean" platform="all">
+
+ <value default="ON"/>
+
+ </values>
+
+ <versions>
+ <manual version="6.0"/>
+ <introduced version="6.0.8"/>
+ </versions>
+
+ </mysqloption>
+
+ <mysqloption section="server" id="backup_history_log_file">
+
+ <xrefto id="option_mysqld_backup_history_log_file"/>
+
+ <name>backup_history_log_file</name>
+
+ <shortdescription lang="en">
+ Name of the MySQL Backup history log file
+ </shortdescription>
+
+ <types>
+ <vartype isdynamic="yes" class="system" scope="global" format="backup_history_log_file"/>
+ </types>
+
+ <values vartype="filename" platform="all">
+
+ <value default="backup_history.log"/>
+
+ </values>
+
+ <versions>
+ <manual version="6.0"/>
+ <introduced version="6.0.8"/>
+ </versions>
+
+ </mysqloption>
+
+ <mysqloption section="server" id="backup_progress_log">
+
+ <xrefto id="option_mysqld_backup_progress_log"/>
+
+ <name>backup_progress_log</name>
+
+ <shortdescription lang="en">
+ Enable or disable MySQL Backup progress log
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" format="--backup_progress_log" setvar="backup_progress_log"/>
+ <optype class="mycnf"/>
+ <vartype isdynamic="yes" class="system" scope="global" format="backup_progress_log"/>
+ </types>
+
+ <values vartype="boolean" platform="all">
+
+ <value default="ON"/>
+
+ </values>
+
+ <versions>
+ <manual version="6.0"/>
+ <introduced version="6.0.8"/>
+ </versions>
+
+ </mysqloption>
+
+ <mysqloption section="server" id="backup_progress_log_file">
+
+ <xrefto id="option_mysqld_backup_progress_log_file"/>
+
+ <name>backup_progress_log_file</name>
+
+ <shortdescription lang="en">
+ Name of the MySQL Backup progress log file
+ </shortdescription>
+
+ <types>
+ <vartype isdynamic="yes" class="system" scope="global" format="backup_progress_log_file"/>
+ </types>
+
+ <values vartype="filename" platform="all">
+
+ <value default="backup_progress.log"/>
+
+ </values>
+
+ <versions>
+ <manual version="6.0"/>
+ <introduced version="6.0.8"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption section="server" id="back_log">
<xrefto id="option_mysqld_back_log"/>
@@ -11121,6 +11233,40 @@
</mysqloption-->
+ <mysqloption section="server" id="log-backup-output">
+
+ <xrefto id="option_mysqld_log-backup-output"/>
+
+ <name>log-backup-output</name>
+
+ <shortdescription lang="en">
+ The destination for MySQL Backup history and progress log output.
+ Syntax: log-backup-output[=value[,value...]], where "value" could be
+ TABLE, FILE, or NONE
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" format="--log-backup-output[=name]" setvar="log_backup_output"/>
+ <optype class="mycnf"/>
+ <vartype isdynamic="yes" class="system" format="log_backup_output" scope="global"/>
+ </types>
+
+ <values vartype="enumeration" platform="all">
+
+ <value default="TABLE"/>
+ <choice value="TABLE"/>
+ <choice value="FILE"/>
+ <choice value="NONE"/>
+
+ </values>
+
+ <versions>
+ <manual version="6.0"/>
+ <introduced version="6.0.8"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption section="server" id="log-bin">
<xrefto id="option_mysqld_log-bin"/>
Modified: trunk/refman-6.0/backup.xml
===================================================================
--- trunk/refman-6.0/backup.xml 2008-10-23 18:53:59 UTC (rev 12138)
+++ trunk/refman-6.0/backup.xml 2008-10-23 18:54:07 UTC (rev 12139)
Changed blocks: 2, Lines Added: 4, Lines Deleted: 4; 1475 bytes
@@ -1978,9 +1978,9 @@
<literal>backup_history</literal> and
<literal>backup_progress</literal> tables in the
<literal>mysql</literal> database. For logging to files, MySQL
- Backup uses the <literal>backup_history.log</literal> and
- <literal>backup_progress.log</literal> files in the MySQL data
- directory by default. The log filenames can be changed by
+ Backup uses the <filename>backup_history.log</filename> and
+ <filename>backup_progress.log</filename> files in the MySQL
+ data directory by default. The log filenames can be changed by
setting the global <literal>backup_history_log_file</literal>
and <literal>backup_progress_log_file</literal> system
variables. For information about selecting log destinations,
@@ -1988,7 +1988,7 @@
</para>
<para>
- The contents of the the log table is discussed following. For
+ The contents of the log tables are discussed following. For
logging to files, the server writes lines with a field for
each column in the corresponding log table. The server also
writes an initial line to the file at startup to indicate the
Modified: trunk/refman-6.0/dba-core.xml
===================================================================
--- trunk/refman-6.0/dba-core.xml 2008-10-23 18:53:59 UTC (rev 12138)
+++ trunk/refman-6.0/dba-core.xml 2008-10-23 18:54:07 UTC (rev 12139)
Changed blocks: 2, Lines Added: 121, Lines Deleted: 0; 5644 bytes
@@ -1486,6 +1486,61 @@
</listitem>
<listitem>
+ <para id="option_mysqld_log-backup-output">
+ <indexterm>
+ <primary>mysqld</primary>
+ <secondary>log-backup-output option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>log-backup-output option</primary>
+ <secondary>mysqld</secondary>
+ </indexterm>
+
+ <option>--log-backup-output[=<replaceable>value</replaceable>,...]</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:log-backup-output"/>
+
+ <para>
+ This option determines the destination for MySQL Backup
+ history and progress log output. The option value can be
+ given as one or more of the words <literal>TABLE</literal>,
+ <literal>FILE</literal>, or <literal>NONE</literal>. If the
+ option is given without a value, the default is
+ <literal>TABLE</literal>. <literal>TABLE</literal> selects
+ logging to the <literal>backup_history</literal> and
+ <literal>backup_progress</literal> log tables in the
+ <literal>mysql</literal> database as a destination.
+ <literal>FILE</literal> selects logging to log files as a
+ destination. <literal>NONE</literal> disables logging. If
+ <literal>NONE</literal> is present in the option value, it
+ takes precedence over any other words that are present.
+ <literal>TABLE</literal> and <literal>FILE</literal> can
+ both be given to select to both log output destinations.
+ </para>
+
+ <para>
+ This option selects log output destinations, but does not
+ enable log output. To do that, use the
+ <option>--backup_history_log</option> and
+ <option>--backup_progress_log</option> options. For
+ <literal>FILE</literal> logging, the default log files are
+ <filename>backup_history.log</filename> and
+ <literal>backup_progress.log</literal> in the data
+ directory. To change the names, set the global
+ <literal>backup_history_log_file</literal> and
+ <literal>backup_progress_log_file</literal> system
+ variables. For more information, see
+ <xref linkend="backup-database-restore-log-control"/>.
+ </para>
+
+ <para>
+ This option was added in MySQL 6.0.8.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="option_mysqld_log-bin">
<indexterm>
<primary>mysqld</primary>
@@ -3855,6 +3910,72 @@
</listitem>
<listitem>
+ <para id="option_mysqld_backup_history_log">
+ <literal>backup_history_log</literal>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:backup_history_log"/>
+
+ <para>
+ Whether the MySQL Backup history log is enabled. The value
+ can be 0 (or <literal>OFF</literal>) to disable the log or 1
+ (or <literal>ON</literal>) to enable the log. The
+ destination for log output is controlled by the
+ <literal>log_backup_output</literal> system variable; if
+ that value is <literal>NONE</literal>, no log entries are
+ written even if the log is enabled. This variable was added
+ in MySQL 6.0.8.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para id="option_mysqld_backup_history_log_file">
+ <literal>backup_history_log_file</literal>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:backup_history_log_file"/>
+
+ <para>
+ The name of the MySQL Backup history log file. The default
+ value is <filename>backup_history.log</filename>. This
+ variable was added in MySQL 6.0.8.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para id="option_mysqld_backup_progress_log">
+ <literal>backup_progress_log</literal>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:backup_progress_log"/>
+
+ <para>
+ Whether the MySQL Backup progress log is enabled. The value
+ can be 0 (or <literal>OFF</literal>) to disable the log or 1
+ (or <literal>ON</literal>) to enable the log. The
+ destination for log output is controlled by the
+ <literal>log_backup_output</literal> system variable; if
+ that value is <literal>NONE</literal>, no log entries are
+ written even if the log is enabled. This variable was added
+ in MySQL 6.0.8.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para id="option_mysqld_backup_progress_log_file">
+ <literal>backup_progress_log_file</literal>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:backup_progress_log_file"/>
+
+ <para>
+ The name of the MySQL Backup progress log file. The default
+ value is <filename>backup_progress.log</filename>. This
+ variable was added in MySQL 6.0.8.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="option_mysqld_back_log">
<literal>back_log</literal>
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r12139 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-6.0 | paul.dubois | 23 Oct |
