Difference between revisions of "MariaDB Binary Log Formats"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
https://mariadb.com/kb/en/binary-log-formats/ | https://mariadb.com/kb/en/binary-log-formats/ | ||
| + | * Mixed Logging: <code>[[MIXED]]</code>(default) | ||
* Statement-Based Logging: <code>[[STATEMENT]]</code> (Default until [[MariaDB 10.2.3]], [https://mariadb.org/download/?t=mariadb&o=true&p=mariadb&r=10.2.3 2016]) | * Statement-Based Logging: <code>[[STATEMENT]]</code> (Default until [[MariaDB 10.2.3]], [https://mariadb.org/download/?t=mariadb&o=true&p=mariadb&r=10.2.3 2016]) | ||
| − | * Row-Based Logging: <code>[[ROW]]</code> | + | * Row-Based Logging: <code>[[ROW]]</code> <code>[[SET GLOBAL binlog_format]]='ROW';</code> or [[binlog_format=ROW]] in config file |
| − | * | + | |
| + | Configuration: | ||
| + | * <code>[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code> | ||
| + | |||
| + | |||
== Related == | == Related == | ||
* [[MariaDB binary log]] | * [[MariaDB binary log]] | ||
| − | * | + | * <code>[[binlog_format]]</code> |
| − | |||
* mysql -e "SHOW VARIABLES;" | grep [[binlog_format]] | * mysql -e "SHOW VARIABLES;" | grep [[binlog_format]] | ||
* <code>(Warning) Unsafe statement written to the binary log using statement format since BINLOG FORMAT = STATEMENT</code> | * <code>(Warning) Unsafe statement written to the binary log using statement format since BINLOG FORMAT = STATEMENT</code> | ||
| + | * [[mariadb --version]] | ||
== See also == | == See also == | ||
Latest revision as of 09:36, 18 December 2024
https://mariadb.com/kb/en/binary-log-formats/
- Mixed Logging:
MIXED(default) - Statement-Based Logging:
STATEMENT(Default until MariaDB 10.2.3, 2016) - Row-Based Logging:
ROWSET GLOBAL binlog_format='ROW';or binlog_format=ROW in config file
Configuration:
Related[edit]
- MariaDB binary log
binlog_format- mysql -e "SHOW VARIABLES;" | grep binlog_format
(Warning) Unsafe statement written to the binary log using statement format since BINLOG FORMAT = STATEMENT- mariadb --version
See also[edit]
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306,/etc/mysql/
Advertising:
