PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Changing the session binlog_format value requires privileges sufficient to set restricted session system variables. Each MySQL Server can set its own and only its own binary logging format (true whether binlog_format is set with global or session ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. Type, binlog_format, SLC, and RLC columns outline the conditions, and Error / Warning and Logged as columns represent the corresponding actions. Type ... When ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
You should keep in mind that the format used to log a given statement may not necessarily be the same as that indicated by the value of binlog_format. You should keep in mind that the format used to log a given statement may not necessarily be the ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
A statement is treated differently depending on whether the statement is considered safe, and with respect to the binary logging format (that is, the current value of binlog_format). LOAD DATA is treated as unsafe and when binlog_format=mixed the ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
Note that if row-based replication is in use (binlog_format=ROW), log_slow_slave_statements has no effect. Queries are only added to the replica's slow query log when they are logged in statement format in the binary log, that is, when ... The slow ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you need to guarantee that your replication filters operate consistently regardless of the binary logging format, particularly if you are using mixed binary logging format (binlog_format=MIXED), use only table-level replication filtering options, ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
Note that if row-based replication is in use (binlog_format=ROW), log_slow_slave_statements has no effect. Queries are only added to the replica's slow query log when they are logged in statement format in the binary log, that is, when ... This ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. A warning is logged if you use this function when binlog_format is set to STATEMENT. A warning is logged if you use this function when binlog_format is set to ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
Statements that affect mysql database tables are written to the binary log using the following rules: Data manipulation statements that change data in mysql database tables directly are logged according to the setting of the binlog_format system ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
When binlog_format=STATEMENT is set, a warning is issued for DML statements inside XA transactions. When binlog_format=MIXED or binlog_format=ROW is set, DML statements inside XA transactions are logged using row-based replication, and the potential ... XA transaction support is limited to the InnoDB storage ...