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.