Hi. I set binlog_expire_logs_seconds=259200 (3 days) but bin log not

How many binlog files are there after the limit time? How many days or hours do binlog files remain after the limit time expires? For example, now 20240808 11:43, you didn't do anything, and on the server there are binlog files older than 20240805 11:43. How many of these binlog files are there? Are these binlog files numbered in order?

0

1 месяц назад

Alexander Автор вопроса

PavelDBA
How many binlog files are there after the limit ti...

Binlog are is order. After the limit time expires all binlog remain. Sometimes the service restarts and files cleaned, so how many days files remain i don't know. Longest storage period was 3 months.

0

1 месяц назад

PavelDBA

Alexander
Binlog are is order. After the limit time expires ...

You need to check file '/etc/mysql/my.cnf' and another '*.cnf' files maybe there is parameter duplicated somewhere.

0

1 месяц назад

Alexander Автор вопроса

PavelDBA
You need to check file '/etc/mysql/my.cnf' and ano...

Vary strange. Because execution 'SHOW GLOBAL VARIABLES...' show correct values.

0

1 месяц назад