MySQL Binlog increases beyond normal specified

46 views Asked by At

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

1

There are 1 answers

3
Bill Karwin On

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.