Author: js221926
Date: 2011-04-02 13:02:16 +0200 (Sat, 02 Apr 2011)
New Revision: 25709
Log:
Documentation for replication WL#5465
log_bin_basename and relay_log_basename system variables
Modified:
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-5.6/introduction.xml
trunk/refman-5.6/replication-options-core.xml
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2011-04-02 10:08:10 UTC (rev 25708)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2011-04-02 11:02:16 UTC (rev 25709)
Changed blocks: 1, Lines Added: 38, Lines Deleted: 0; 1426 bytes
@@ -6,6 +6,44 @@
]>
<changelog>
+ <logentry entrytype="feature">
+
+ <tags>
+ <highlight type="replication"/>
+ <manual type="log-bin"/>
+ <manual type="log_bin_basename"/>
+ <manual type="relay_log_basename"/>
+ </tags>
+
+ <bugs>
+ <fixes wlid="5465"/>
+ <seealsobug bugid="19614"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.6.2"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Added the <literal role="sysvar">log_bin_basename</literal>
+ system variable, which contains the complete filename and path
+ to the binary log file. (The
+ <literal role="sysvar">log_bin</literal> system variable shows
+ only whether or not binary logging is enabled;
+ <literal role="sysvar">log_bin_basename</literal>, however,
+ reflects the name set with the
+ <option role="mysqld">--log-bin</option> server option.) Also
+ added <literal role="sysvar">relay_log_basename</literal> system
+ variable, which shows the filename and complete path to the
+ relay log file.
+ </para>
+
+ </message>
+
+ </logentry>
+
<logentry entrytype="bug">
<tags>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2011-04-02 10:08:10 UTC (rev 25708)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2011-04-02 11:02:16 UTC (rev 25709)
Changed blocks: 2, Lines Added: 50, Lines Deleted: 0; 1743 bytes
@@ -15058,6 +15058,31 @@
</mysqloption>
+ <mysqloption section="binlog" id="log_bin_basename">
+
+ <xrefto id="sysvar_log_bin_basename"/>
+
+ <name>log_bin_basename</name>
+
+ <shortdescription>
+ Complete path to the binary log, including the filename
+ </shortdescription>
+
+ <types>
+ <vartype scope="global" class="system" isdynamic="no"/>
+ </types>
+
+ <values vartype="filename" platform="all">
+ <value default="datadir + '/' + hostname + '-bin'"/>
+ </values>
+
+ <versions>
+ <manual version="5.6"/>
+ <introduced version="5.6.2"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption section="server" id="log-bin-index">
<xrefto id="option_mysqld_log-bin-index"/>
@@ -21148,6 +21173,31 @@
</mysqloption>
+ <mysqloption section="replication" id="relay_log_basename">
+
+ <xrefto id="sysvar_relay_log_basename"/>
+
+ <name>relay_log_basename</name>
+
+ <shortdescription>
+ Complete path to the relay log, including the filename
+ </shortdescription>
+
+ <types>
+ <vartype scope="global" class="system" isdynamic="no"/>
+ </types>
+
+ <values vartype="filename" platform="all">
+ <value default="datadir + '/' + hostname + '-relay-bin'"/>
+ </values>
+
+ <versions>
+ <manual version="5.6"/>
+ <introduced version="5.6.2"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption section="replication" id="relay-log-index">
<xrefto id="option_mysqld_relay-log-index"/>
Modified: trunk/refman-5.6/introduction.xml
===================================================================
--- trunk/refman-5.6/introduction.xml 2011-04-02 10:08:10 UTC (rev 25708)
+++ trunk/refman-5.6/introduction.xml 2011-04-02 11:02:16 UTC (rev 25709)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 0; 1134 bytes
@@ -619,6 +619,26 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ The <literal role="sysvar">log_bin_basename</literal> system
+ variable has been added. This variable contains the complete
+ filename and path to the binary log file. Whereas the
+ <literal role="sysvar">log_bin</literal> system variable shows
+ only whether or not binary logging is enabled,
+ <literal role="sysvar">log_bin_basename</literal> reflects the
+ name set with the <option role="mysqld">--log-bin</option>
+ server option.
+ </para>
+
+ <para>
+ Similarly, the
+ <literal role="sysvar">relay_log_basename</literal> system
+ variable shows the filename and complete path to the relay log
+ file.
+ </para>
+ </listitem>
+
</itemizedlist>
<bridgehead>
Modified: trunk/refman-5.6/replication-options-core.xml
===================================================================
--- trunk/refman-5.6/replication-options-core.xml 2011-04-02 10:08:10 UTC (rev 25708)
+++ trunk/refman-5.6/replication-options-core.xml 2011-04-02 11:02:16 UTC (rev 25709)
Changed blocks: 4, Lines Added: 67, Lines Deleted: 2; 3295 bytes
@@ -1001,6 +1001,13 @@
</listitem>
</itemizedlist>
+
+ <para>
+ Beginning with MySQL 5.6.2, you can obtain the relay log
+ filename (and path) from the
+ <literal role="sysvar">relay_log_basename</literal> system
+ variable.
+ </para>
</listitem>
<listitem>
@@ -2245,6 +2252,32 @@
</listitem>
<listitem>
+ <para id="sysvar_relay_log_basename">
+ <indexterm>
+ <primary>relay_log_basename system variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>system variable</primary>
+ <secondary>relay_log_basename</secondary>
+ </indexterm>
+
+ <literal role="sysvar">relay_log_basename</literal>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="5.6:mysqld:relay_log_basename"/>
+
+ <para>
+ Holds the name and complete path to the relay log file.
+ </para>
+
+ <para>
+ The <literal role="sysvar">relay_log_basename</literal> system
+ variable was added in MySQL 5.6.2.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="sysvar_relay_log_index">
<indexterm>
<primary>relay_log_index system variable</primary>
@@ -2767,8 +2800,10 @@
Setting this option causes the
<literal role="sysvar">log_bin</literal> system variable to be
set to <literal>ON</literal> (or <literal>1</literal>), and
- not to the basename. This is a known issue; see Bug#19614 for
- more information.
+ not to the basename. Beginning with MySQL 5.6.2, the binary
+ log filename (with path) is available as the
+ <literal role="sysvar">log_bin_basename</literal> system
+ variable.
</para>
</listitem>
@@ -3448,6 +3483,36 @@
<itemizedlist>
<listitem>
+ <para id="sysvar_log_bin_basename">
+ <indexterm>
+ <primary>log_bin_basename system variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>system variable</primary>
+ <secondary>log_bin_basename</secondary>
+ </indexterm>
+
+ <literal role="sysvar">log_bin_basename</literal>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="5.6:mysqld:log_bin_basename"/>
+
+ <para>
+ Holds the name and complete path to the binary log file.
+ Unlike the <literal role="sysvar">log_bin</literal> system
+ variable, <literal role="sysvar">log_bin_basename</literal>
+ reflects the name set with the
+ <option role="mysqld">--log-bin</option> server option.
+ </para>
+
+ <para>
+ The <literal role="sysvar">log_bin_basename</literal> system
+ variable was added in MySQL 5.6.2.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="sysvar_binlog_cache_size">
<indexterm>
<primary>binlog_cache_size system variable</primary>
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r25709 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.6 | jon.stephens | 2 Apr |