The binlog_size of mysql is growing rapidly. What is the reason?
滿天的星座2017-05-18 10:51:03
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
我想大声告诉你2017-05-18 10:51:03
If you use
load data to import data, it will also cause the binlog to be too large.
You can refresh the binlog manually
黄舟2017-05-18 10:51:03
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