Replication and Binary Logging Options and Variables
1464
System variables used on replication slaves.
The following list describes system variables
for controlling replication slave servers. They can be set at server startup and some of them can be
changed at runtime using
SET
. Server options used with replication slaves are listed earlier in this
section.
•
init_slave
[1464]
Command-Line Format
--init-slave=name
Option-File Format
init_slave
Option Sets Variable
Yes,
init_slave
[1464]
Variable Name
init_slave
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
string
This variable is similar to
init_connect
[456]
, but is a string to be executed by a slave server each
time the SQL thread starts. The format of the string is the same as for the
init_connect
[456]
variable.
Note
The SQL thread sends an acknowledgment to the client before it
executes
init_slave
[1464]
. Therefore, it is not guaranteed that
init_slave
[1464]
has been executed when
START SLAVE
returns. See
Section 13.4.2.7, “
START SLAVE
Syntax”
, for more information.
•
relay_log
[1464]
Command-Line Format
--relay-log=name
Option-File Format
relay-log
Option Sets Variable
Yes,
relay_log
[1464]
Variable Name
relay-log
Variable Scope
Global
Dynamic Variable
No
Permitted Values
Type
file name
The name of the relay log file.
•
relay_log_index
[1464]
Command-Line Format
--relay-log-index
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
string
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...