Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What are the differences between binlog and redo log in mysql

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >

Share

Shulou(Shulou.com)06/03 Report--

This article mainly explains "what is the difference between binlog and redo log in mysql". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the difference between binlog and redo log in mysql".

1. Binlog is a logical log implemented in the MySQL Server layer, which can be used by all engines.

Redo log is a physical log unique to the InoDB engine.

2. Binlog is a logical log and redo log is a physical log.

Binlog records the raw logic of all DDL and DML statements.

Edo log records changes to a data page.

3. Binlog is unlimited, while redo log limits the size of space.

Binlog can add writes.

Redo log can only be replicated in a loop.

Example

Mysql > show variables like 'innodb%log%' +-- +-+ | Variable_name | Value | +-- +-+. | Innodb_log_file_size | 2147483648 | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir |. / |. +-- +-+ 15 rows in set (0.00 sec) Thank you for your reading The above is the content of "what is the difference between binlog and redo log in mysql". After the study of this article, I believe you have a deeper understanding of the difference between binlog and redo log in mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Development

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report