CODEWITHSUNDEEP
mysqlfilesizebinlog
DBA
DBA

Reputation: 7

MySQL Binlog increases beyond normal specified

i have binlog enabled for mysql 5.7 and i am seeing that some files are created twice for the same time (one is 100 mb other is 2.3GB) they were not being done previously the bin log size is 100 mb as can be seen from other files(please see attachment with this post).the last file is being written .are the highlighted files wrong or ? please can anyone explain ,thanksbinlog files yellow marked are increases

enabled General query log

Upvotes: 0

Views: 235

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562260

https://dev.mysql.com/doc/refman/8.0/en/binary-log.html says:

A binary log file may become larger than max_binlog_size if you are using large transactions because a transaction is written to the file in one piece, never split between files.

This means if you change many rows in a single transaction, or the rows contain very large data values (e.g. long BLOB or TEXT content), a single binary log could grow far past the supposed limit on the size.

Upvotes: 1

Related Questions