What is binlog in mysql

1. Binlog is a general archive log of the MySQLServer layer.

All storage engines in the Engine layer can use binlog.

2. Binlog is a logical log. Sequential recording of DDL and DML statements in the database.

3. Binlog logs can be added. When the binlog file reaches a certain size, it will automatically switch to the next file.

The original binlog file will not be overwritten. The above is the understanding of binlog in mysql, I hope it will be helpful to everyone.

Example

SET GLOBAL binlog_format = 'STATEMENT';
SET GLOBAL binlog_format = 'ROW';
SET GLOBAL binlog_format = 'MIXED';

The above is the detailed content of What is binlog in mysql. For more information, please follow other related articles on the PHP Chinese website!