Check your my.cnf, is it binlog_format=ROW At this time, many records with the same conditions in alter table and update will cause the log to skyrocket
Binlog records changes that affect the database table, such as additions, deletions, modifications, etc., so check if there are a large number of statements that insert or modify the data table
Check your my.cnf, is it
binlog_format=ROW
At this time, many records with the same conditions in alter table and update will cause the log to skyrocket
If you use
load data to import data, it will also cause the binlog to be too large.
You can refresh the binlog manually
Binlog records changes that affect the database table, such as additions, deletions, modifications, etc., so check if there are a large number of statements that insert or modify the data table