HiveBrain v1.2.0
Get Started
← Back to all entries
gotchasqlMinor

what's difference between sql_log_bin and log_bin in MySQL?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
whatanddifferencemysqlbetweensql_log_binlog_bin

Problem

can anybody tell me what is the difference between them ?

Solution

log_bin is a global variable that is set at runtime. It determines if binary logging should take place, and (if set) the basename of the binary logs. It cannot be changed without restarting the database.

http://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html#option_mysqld_log-bin

sql_log_bin is a global OR session variable that can be set after the server is running. It's main use is as a SESSION variable to prevent statements from the current session being written to the binary log. Use as a GLOBAL variable is not recomended.

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_sql_log_bin

Context

StackExchange Database Administrators Q#130402, answer score: 6

Revisions (0)

No revisions yet.