What operations will cause mysql's binlog_size to quickly increase?
高洛峰
高洛峰 2017-05-18 10:49:03
0
3
803

The binlog_size of mysql is growing rapidly. What is the reason?

高洛峰
高洛峰

拥有18年软件开发和IT教学经验。曾任多家上市公司技术总监、架构师、项目经理、高级软件工程师等职务。 网络人气名人讲师,...

reply all(3)
滿天的星座

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

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!