Oracle 5.0, Справочное руководство

Страница: 1476 / 3232

Replication and Binary Logging Options and Variables
1456
Command-Line Format
--relay-log-index=name
Option-File Format
relay-log-index
Option Sets Variable Yes,
relay_log_index
[1464]
Variable Name
relay-log-index
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
file name
The name to use for the relay log index file. The default name is
host_name-relay-bin.index
in
the data directory, where
host_name
is the name of the slave server.
Due to the manner in which MySQL parses server options, if you specify this option, you must supply
a value; the default basename is used only if the option is not actually specified. If you use the
--
relay-log-index
[1455] option without specifying a value, unexpected behavior is likely to result;
this behavior depends on the other options used, the order in which they are specified, and whether
they are specified on the command line or in an option file. For more information about how MySQL
handles server options, see
Section 4.2.3, “Specifying Program Options” .
If you specify this option, the value specified is also used as the basename for the relay logs. You
can override this behavior by specifying a different relay log file basename using the
--relay-
log
[1455] option.
•
--relay-log-info-file=file_name
[1456]
Command-Line Format
--relay-log-info-file=file_name
Option-File Format
relay-log-info-file
Option Sets Variable Yes,
relay_log_info_file
[1465]
Permitted Values
Type
file name
Default
relay-log.info
The name to use for the file in which the slave records information about the relay logs. The default
name is
relay-log.info
in the data directory. For information about the format of this file, see
Section 16.2.2.2, “Slave Status Logs” .
•
--relay-log-purge={0|1}
[1456]
Disable or enable automatic purging of relay logs as soon as they are no longer needed. The default
value is 1 (enabled). This is a global variable that can be changed dynamically with
SET GLOBAL
relay_log_purge = N
.
•
--relay-log-space-limit=size
[1456]
This option places an upper limit on the total size in bytes of all relay logs on the slave. A value
of 0 means “no limit.” This is useful for a slave server host that has limited disk space. When the
limit is reached, the I/O thread stops reading binary log events from the master server until the
SQL thread has caught up and deleted some unused relay logs. Note that this limit is not absolute:
There are cases where the SQL thread needs more events before it can delete relay logs. In that
case, the I/O thread exceeds the limit until it becomes possible for the SQL thread to delete some
relay logs because not doing so would cause a deadlock. You should not set
--relay-log-
space-limit
[1456] to less than twice the value of
--max-relay-log-size
[1455] (or
--max-
binlog-size
[1472] if
--max-relay-log-size
[1455] is 0). In that case, there is a chance that
the I/O thread waits for free space because
--relay-log-space-limit
[1456] is exceeded, but