Difference between revisions of "Binlog format"
Jump to navigation
Jump to search
| (One intermediate revision 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='MIXED'; | + | [[SET GLOBAL]] binlog_format='[[MIXED]]'; |
binlog_format=MIXED | binlog_format=MIXED | ||
[[mysql -e "SHOW VARIABLES"]] | grep -w binlog_format | [[mysql -e "SHOW VARIABLES"]] | grep -w binlog_format | ||
binlog_format MIXED | binlog_format MIXED | ||
| + | |||
| + | |||
| + | [[show variables like]] 'binlog_format'; | ||
* [[MariaDB Binary Log Formats]] | * [[MariaDB Binary Log Formats]] | ||
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:
