Percona server 5.5.57 generating lots of small mysql-bin.xxxx files

MySQL & MariaDB Other MySQL® Questions
1

Hi Community,

I’ve been using Percona server for a while now without any trouble at all ever :slight_smile:
Now I’m running into my first issue so I thought I’d join the community to seek some advice.

Recently I replaced a percona server 5.5 instance running on CentOS 6.9 with a Percona 5.5 on CentOS 7.3.

I copied over the full mysql data directory and set permissions over to the new system.

The MySQL seems to be working fine (Other than users reporting intermittent disconnects).

My problem here is really, that I seem to get a new mysql-bin.xxxxx file every 10 minutes?

No entries in the error log. I’m at a loss :frowning:

Anyone ever come across this issue?

Thanks in advance for any help, much appreciated!

Regards,

K Faber

2

Can you share the following outputs:
SHOW BINARY LOGS;
SELECT @@global.max_binlog_size;

3

Also, check in the filesystem if the size is the same for all those files. If they are all different, maybe you are having crashes in the service. So please, check what Jericho asked and then also the file sizes.