Difference between revisions of "Binlog format"
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
* https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#binlog_format | * https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#binlog_format | ||
| − | [[SET GLOBAL]] binlog_format=' | + | [[SET GLOBAL]] binlog_format='[[MIXED]]'; |
| + | binlog_format=MIXED | ||
| + | [[mysql -e "SHOW VARIABLES"]] | grep -w binlog_format | ||
| + | binlog_format MIXED | ||
| − | + | ||
| + | [[show variables like]] 'binlog_format'; | ||
* [[MariaDB Binary Log Formats]] | * [[MariaDB Binary Log Formats]] | ||
| Line 14: | Line 18: | ||
== See also == | == See also == | ||
* {{MariaDB binary log}} | * {{MariaDB binary log}} | ||
| + | * {{MariaDB logs}} | ||
Latest revision as of 09:35, 18 December 2024
SET GLOBAL binlog_format='MIXED'; binlog_format=MIXED
mysql -e "SHOW VARIABLES" | grep -w binlog_format binlog_format MIXED
show variables like 'binlog_format';
See also[edit]
Advertising:
