Replication and Binary Logging Options and Variables
1462
Type
boolean
Default
FALSE
Display slave user names and passwords in the output of
SHOW SLAVE HOSTS
on the master server
for slaves started with the
--report-user
[1461]
and
--report-password
[1460]
options.
•
--skip-slave-start
[1462]
Command-Line Format
--skip-slave-start
Option-File Format
skip-slave-start
Permitted Values
Type
boolean
Default
FALSE
Tells the slave server not to start the slave threads when the server starts. To start the threads later,
use a
START SLAVE
statement.
•
--slave_compressed_protocol={0|1}
[1465]
Command-Line Format
--slave_compressed_protocol
Option-File Format
slave_compressed_protocol
Option Sets Variable
Yes,
slave_compressed_protocol
[1465]
Variable Name
slave_compressed_protocol
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
boolean
Default
OFF
If this option is set to 1, use compression for the slave/master protocol if both the slave and the
master support it. The default is 0 (no compression).
•
--slave-load-tmpdir=file_name
[1462]
The name of the directory where the slave creates temporary files. This option is by default equal to
the value of the
tmpdir
[502]
system variable. When the slave SQL thread replicates a
LOAD DATA
INFILE
statement, it extracts the file to be loaded from the relay log into temporary files, and then
loads these into the table. If the file loaded on the master is huge, the temporary files on the slave
are huge, too. Therefore, it might be advisable to use this option to tell the slave to put temporary
files in a directory located in some file system that has a lot of available space. In that case, the relay
logs are huge as well, so you might also want to use the
--relay-log
[1455]
option to place the
relay logs in that file system.
The directory specified by this option should be located in a disk-based file system (not a memory-
based file system) because the temporary files used to replicate
LOAD DATA INFILE
must survive
machine restarts. The directory also should not be one that is cleared by the operating system during
the system startup process.
•
--slave-net-timeout=seconds
[1462]
Command-Line Format
--slave-net-timeout=#
Option-File Format
slave-net-timeout
Option Sets Variable
Yes,
slave_net_timeout
[1466]
Содержание 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 ...