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

This article mainly explains the "Mysql binlog log which several formats", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "Mysql binlog log which formats" it!

There are three formats of Mysql binlog log, which are ROW, Statement and Mixed.

Mixed is recorded in statement format by default, but is converted to row format in the following six cases:

The first case: NDB engine, the DML operations of table additions, deletions and modifications will be recorded in row format.

The second case: the SQL statement contains the UUID () function

The third case: user-defined functions (UDF) are used in the SQL statement

The fourth case: contains the insert delayed statement

The sixth case: temporary tables are used

The fifth case: the self-increasing field is updated

Thank you for your reading, these are the contents of "what are the formats of the Mysql binlog log?" after the study of this article, I believe you have a deeper understanding of the question of which format the Mysql binlog log has, 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.