search

Home  >  Q&A  >  body text

What operations will cause mysql's binlog_size to quickly increase?

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

高洛峰高洛峰2864 days ago889

reply all(3)I'll reply

  • 滿天的星座

    滿天的星座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

    reply
    0
  • 我想大声告诉你

    我想大声告诉你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

    reply
    0
  • 黄舟

    黄舟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

    reply
    0
  • Cancelreply