Difference between revisions of "MariaDB binary log"
Jump to navigation
Jump to search
(→Format) |
|||
| Line 19: | Line 19: | ||
* <code>[[SET sql_log_bin = 0;]]</code> | * <code>[[SET sql_log_bin = 0;]]</code> | ||
* <code>[[mysqlbinlog]]</code> | * <code>[[mysqlbinlog]]</code> | ||
| + | * <code>[[mariabackup]]</code> | ||
| + | * <code>[[--delete-master-logs]]</code> | ||
== Activities == | == Activities == | ||
Revision as of 12:55, 19 February 2023
--log-bin=your-log-binname --log_bin_compress
Contents
Format
SET GLOBAL binlog_format='ROW';
Slave
STOP SLAVE; SET GLOBAL slave_parallel_threads=0; SET GLOBAL binlog_format='ROW'; SET GLOBAL slave_parallel_threads=4; START SLAVE
Related
Activities
See also
mariabackup, mariabackup --help, mysqlbinlog, MariaDB binary log,max_binlog_size, PITR- Database backups:
mariabackup, mysqldump,mongodump,mariabackup, pg_dump - 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:
