Dreaday 2023-05

바이너리 보관 기관 관련은 global variable 변경하면되지 않나요 ?

binlog_expire_logs_seconds
Description: If non-zero, binary logs will be purged after binlog_expire_logs_seconds seconds. Possible purges happen at startup and at binary log rotation. From MariaDB 10.6.1, binlog_expire_logs_seconds and expire_logs_days are forms of aliases, such that changes to one automatically reflect in the other.
Commandline: --binlog-expire-logs-seconds=#
Scope: Global, Session
Dynamic: Yes
Data Type: numeric
Default Value: 0
Range: 0 to 4294967295
Introduced: MariaDB 10.6.1

사내들 2023-05

10.6.0 이하 버전이면 아래 변수이며, Default  값은 0이므로 현재 시스템 global 설정 값을 확인해 보기 바랍니다.

expire_logs_days¶
Description: Number of days after which the binary log can be automatically removed. By default 0, or no automatic removal. When using replication, should always be set higher than the maximum lag by any replica. Removals take place when the server starts up, when the binary log is flushed, when the next binary log is created after the previous one reaches the maximum size, or when running PURGE BINARY LOGS. Units are whole days (integer) until MariaDB 10.6.0, or 1/1000000 precision (double) from MariaDB 10.6.1.
Starting from MariaDB 10.6.1, expire_logs_days and binlog_expire_logs_seconds are forms of aliases, such that changes to one automatically reflect in the other.
Commandline: --expire-logs-days=#
Scope: Global
Dynamic: Yes
Data Type: numeric
Default Value: 0.000000 (>= MariaDB 10.6.1), 0 (<= MariaDB 10.6.0)
Range: 0 to 99

제온프로 2023-05

원본 백업후 작업하세요.

DB 복사본을 옆에 만들고 작업하세요.