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

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

Replication and Binary Logging Options and Variables
1468
Option-File Format
log-bin
Variable Name
log_bin
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
file name
Default
OFF
Enable binary logging. The server logs all statements that change data to the binary log, which is
used for backup and replication. See
Section 5.2.3, “The Binary Log” .
The option value, if given, is the basename for the log sequence. The server creates binary log files
in sequence by adding a numeric suffix to the basename. It is recommended that you specify a
basename (see
Section C.5.8, “Known Issues in MySQL” , for the reason). Otherwise, MySQL uses
host_name-bin
as the basename.
Setting this option causes the
log_bin
[1471] system variable to be set to
ON
(or
1
), and not to the
basename. This is a known issue; see Bug #19614 for more information.
•
--log-bin-index[=file_name]
[1468]
Command-Line Format
--log-bin-index=name
Option-File Format
log-bin-index
Permitted Values
Type
file name
Default
OFF
The index file for binary log file names. See Section 5.2.3, “The Binary Log” . If you omit the
file name, and if you did not specify one with
--log-bin
[1467] , MySQL uses
host_name-
bin.index
as the file name.
•
--log-bin-trust-function-creators[={0|1}]
[1468]
Version Introduced 5.0.16
Command-Line Format
--log-bin-trust-function-creators
Option-File Format
log-bin-trust-function-creators
Option Sets Variable Yes,
log_bin_trust_function_creators
[463]
Variable Name
log_bin_trust_function_creators
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type
boolean
Default
FALSE
This option sets the corresponding
log_bin_trust_function_creators
[463]
system variable. If no argument is given, the option sets the variable to 1.
log_bin_trust_function_creators
[463] affects how MySQL enforces restrictions on stored
function and trigger creation. See Section 18.6, “Binary Logging of Stored Programs” .
This option was added in MySQL 5.0.16.
•
--log-bin-trust-routine-creators[={0|1}]
[1468]