What are the formats of Mysql binlog logs
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!