Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of what binlog is in mysql, the content is detailed and easy to understand, the operation is simple and fast, and has a certain reference value, I believe you will gain something after reading this mysql binlog article, let's take a look at it.

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

All storage engines in the Engine tier can use binlog.

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

3. The binlog log can be added. When the binlog file is written to a certain size, it will automatically switch to the next file.

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

Example

SET GLOBAL binlog_format = 'STATEMENT';SET GLOBAL binlog_format =' ROW';SET GLOBAL binlog_format = 'MIXED';' this is the end of the article on "what is binlog in mysql?" Thank you for reading! I believe you all have a certain understanding of "what is binlog in mysql". If you want to learn more, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.