# Binary log files growing extremely fast

**URL:** <https://forums.percona.com/t/binary-log-files-growing-extremely-fast/28460>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, new-release\
**Created:** [February 14, 2024, 9:59am UTC](https://forums.percona.com/t/binary-log-files-growing-extremely-fast/28460 "2024-02-14T09:59:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SujithGopalakrishnan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sujithgopalakrishnan/32/6734_2.png) [@SujithGopalakrishnan](https://forums.percona.com/u/SujithGopalakrishnan)\
**Post date:** [February 14, 2024, 9:59am UTC](https://forums.percona.com/t/binary-log-files-growing-extremely-fast/28460/1 "2024-02-14T09:59:58Z")

</div>

Hi Team,

We are using MySQL 8.0.36 in production servers. Can see in one of our master server’s binary logs are growing Fastly (2 to 3 binlogs are creating in between seconds).

Below the binary log config:  
max\_binlog\_size = 100M  
binlog\_format = ‘MIXED’

While checking the binlog file, we can see the below type of data is written and which is creating this scenario.

_==_  
_BINLOG ’_  
_lYXMZROxMPkClwAAAGr3BQAAAH07AAAAAAMAEnJldnJlbWl0X2VkaTVfcHJvZAAcb2NyX3JlY29y_  
_ZF9mb3JfZWRpdGVkX2ZpZWxkcwAZCAMKDw8DDw8PEhIPAQoPDw8PAw8DDw8PEh/8A/wD/AP8A/wD_  
_Bgb8A/wDeAD8A/wD/AOgAJABkAEG/vn/AQEBAAID/P8AphrqMw==_  
_lYXMZR+xMPkCfh8AAOgWBgAAAH07AAAAAAAAAgAZ//////////8ICQAAAQAAAAAAAAAqgWUAks8P_  
_EwBJbnN1cmFuY2VQYXltZW50RW9iTYnfABwAdG90YWxfcGF0aWVudF9yZXNwb25zaWJpbGl0eQQA_  
_NzUuMJmyawQqAoghmbJrBCoCiCEBks8PHQAzX0xBQy03NDE2NzlfMjAyMzEyMThfMjIwNzk3Mglv_  
_cmJvZ3JhcGgmAENBUkJPTiBIRUFMVEggTUVESUNBTCBHUk9VUCBPRiBGTE9SSURBJgBDQVJCT04g_  
_SEVBTFRIIE1FRElDQUwgR1JPVVAgT0YgRkxPUklEQSIkBgAMAExBS0VXT09EIElQQYwGAAARcmV2_  
_YXRoaS5uYWRhcmFqYW4RAFJldmF0aGkgTmFkYXJhamFuIAByZXZhdGhpLm5hZGFyYWphbkBndWlk_  
_ZWhvdXNlLmNvbZmyawQqAAAACAkAAAEAAAAAAAAAKoFlAJLPDxMASW5zdXJhbmNlUGF5bWVudEVv_  
_Yk2J3wAcAHRvdGFsX3BhdGllbnRfcmVzcG9uc2liaWxpdHkEADc1LjCZsmsEKgKIIZmyawQqAogh_  
_AZLPDx0AM19MQUMtNzQxNjc5XzIwMjMxMjE4XzIyMDc5NzIJb3Jib2dyYXBoJgBDQVJCT04gSEVB_  
_TFRIIE1FRElDQUwgR1JPVVAgT0YgRkxPUklEQSYAQ0FSQk9OIEhFQUxUSCBNRURJQ0FMIEdST1VQ_  
_IE9GIEZMT1JJREEiJAYADABMQUtFV09PRCBJUEGMBgAAEXJldmF0aGkubmFkYXJhamFuEQBSZXZh_  
_dGhpIE5hZGFyYWphbiAAcmV2YXRoaS5uYWRhcmFqYW5AZ3VpZGVob3VzZS5jb22ZsmsEGgAAAAgJ_  
_AAACAAAAAAAAACqBZQCSzw8TAEluc3VyYW5jZVBheW1lbnRFb2JNid8AEABwbGFjZV9vZl9zZXJ2_  
_aWNlAgAyMJmyawQqAoghmbJrBCoCiCEBks8PHQAzX0xBQy03NDE2NzlfMjAyMzEyMThfMjIwNzk3_  
_MglvcmJvZ3JhcGgmAENBUkJPTiBIRUFMVEggTUVESUNBTCBHUk9VUCBPRiBGTE9SSURBJgBDQVJC_  
_T04gSEVBTFRIIE1FRElDQUwgR1JPVVAgT0YgRkxPUklEQSIkBgAMAExBS0VXT09EIElQQYwGAAAR_  
_cmV2YXRoaS5uYWRhcmFqYW4RAFJldmF0aGkgTmFkYXJhamFuIAByZXZhdGhpLm5hZGFyYWphbkBn_  
_dWlkZWhvdXNlLmNvbZmyawQqAAAACAkAAAIAAAAAAAAAKoFlAJLPDxMASW5zdXJhbmNlUGF5bWVu_  
_dEVvYk2J3wAQAHBsYWNlX29mX3NlcnZpY2UCADIwmbJrBCoCiCGZsmsEKgKIIQGSzw8dADNfTEFD_  
_LTc0MTY3OV8yMDIzMTIxOF8yMjA3OTcyCW9yYm9ncmFwaCYAQ0FSQk9OIEhFQUxUSCBNRURJQ0FM_  
_IEdST1VQIE9GIEZMT1JJREEmAENBUkJPTiBIRUFMVEggTUVESUNBTCBHUk9VUCBPRiBGTE9SSURB_  
_IiQGAAwATEFLRVdPT0QgSVBBjAYAABFyZXZhdGhpLm5hZGFyYWphbhEAUmV2YXRoaSBOYWRhcmFq_  
_YW4gAHJldmF0aGkubmFkYXJhamFuQGd1aWRlaG91c2UuY29tmbJrBBoAAAAICAAAAwAAAAAAAAAq_  
_gWUAks8PEwBJbnN1cmFuY2VQYXltZW50RW9iTYnfABUAcHJvdmlkZXJfb3JnYW5pc2F0aW9uGwBD_  
_QVJCT04gSEVBTFRIIE1FRElDQUwgR1JPVVAmAENBUkJPTiBIRUFMVEggTUVESUNBTCBHUk9VUCBP_  
_RiBGTE9SSURBmbJrBCoCiCGZsmsEKgKIIQGSzw8dADNfTEFDLTc0MTY3OV8yMDIzMTIxOF8yMjA3_  
_OTcyCW9yYm9ncmFwaCYAQ0FSQk9OIEhFQUxUSCBNRURJQ0FMIEdST1VQIE9GIEZMT1JJREEmAENB_  
_UkJPTiBIRUFMVEggTUVESUNBTCBHUk9VUCBPRiBGTE9SSURBIiQGAAwATEFLRVdPT0QgSVBBjAYA_  
_ABFyZXZhdGhpLm5hZGFyYWphbhEAUmV2YXRoaSBOYWRhcmFqYW4gAHJldmF0aGkubmFkYXJhamFu_  
_QGd1aWRlaG91c2UuY29tmbJrBCoAAAAICAAAAwAAAAAAAAAqgWUAks8PEwBJbnN1cmFuY2VQYXlt_  
_ZW50RW9iTYnfABUAcHJvdmlkZXJfb3JnYW5pc2F0aW9uGwBDQVJCT04gSEVBTFRIIE1FRElDQUwg_  
_R1JPVVAmAENBUkJPTiBIRUFMVEggTUVESUNBTCBHUk9VUCBPRiBGTE9SSURBmbJrBCoCiCGZsmsE_  
_KgKIIQGSzw8dADNfTEFDLTc0MTY3OV8yMDIzMTIxOF8yMjA3OTcyCW9yYm9ncmFwaCYAQ0FSQk9O_  
_IEhFQUxUSCBNRURJQ0FMIEdST1VQIE9GIEZMT1JJREEmAENBUkJPTiBIRUFMVEggTUVESUNBTCBH_  
_Uk9VUCBPRiBGTE9SSURBIiQGAAwATEFLRVdPT0QgSVBBjAYAABFyZXZhdGhpLm5hZGFyYWphbhEA_  
_UmV2YXRoaSBOYWRhcmFqYW4gAHJldmF0aGkubmFkYXJhamFuQGd1aWRlaG91c2UuY29tmbJrBBoA_  
_AACICAAABAAAAAAAAAAqgWUAks8PEwBJbnN1cmFuY2VQYXltZW50RW9iTYnfAB0AcmVuZGVyaW5n_  
_X3Byb3ZpZGVyX2dyb3VwX25hbWUMAFVOSURFTlRJRklFRJmyawQqAoghmbJrBCoCiCEBks8PHQAz_  
_==_

Please note that we enabled the SSL between application and DB servers using MySQL certificate and key files.

Please help out to resolve this issue as which is impacting the server disk utilization.

Thanks,  
Sujith VG.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 14, 2024, 3:58pm UTC](https://forums.percona.com/t/binary-log-files-growing-extremely-fast/28460/2 "2024-02-14T15:58:20Z")

</div>

@SujithGopalakrishnan,  
`max_binlog_size = 100M` This is a big reason. Why is this set so small? Typically you see this as 1G to keep the number of binlogs low.

You can decode those contents using `mysqlbinlog -vv --base64-output=decode-rows` to determine what _exactly_ is using up so much space.