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

This article introduces the relevant knowledge of "the explanation and comparison of binlog and redo in mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Redo description

The format of redo:

2. Comparison of statement and row modes of binlog

(1)。 Safety comparison

(2)。 Performance comparison

How many binlog logs are recorded?

There is also a link that is easy to overlook, the process of generating each binlog in row mode.

Third, the comparison between binlog and redo

1. Different positions in the system

Binlog is in the Server layer of MySQL, so it doesn't distinguish which storage engine is used.

Redo is in the storage engine layer, and different storage engines have different conventions for data access formats, so the content of redo must be different.

two。 The polling writes for new and old files are different:

Write redo files in a loop

Monotone linear growth of binlog

3. The way files are written is different in time:

Redo is written continuously while the transaction is in progress

Binlog is written once after the transaction is committed

This is the end of the description and comparison of binlog and redo in mysql. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.