diff options
| author | Jochen Neumeister <joneum@FreeBSD.org> | 2022-10-29 17:07:07 +0200 |
|---|---|---|
| committer | Jochen Neumeister <joneum@FreeBSD.org> | 2022-10-29 17:08:22 +0200 |
| commit | 1bc699507caeb6807ec13443074567da4c847596 (patch) | |
| tree | 5edbbcb8a3e6c0c3b85120ddc264cae675b397f6 /databases | |
| parent | security/tor: Fix build with libressl 3.5 (diff) | |
databases/mysql80-server: Update my.cnf.sample
Update deprecated configs in my.cnf.sample
Some configs in my.cnf.sample are now deprecated. These should be replaced with their replacement, or removed if there is no replacement.
- Replace deprecated slave-load-tmpdir with replica-load-tmpdir
- Remove deprecated master-info-repository (it was set to the default)
- Remove deprecated relay-log-info-repository (it was set to the default)
- Replace deprecated expire_logs_days with binlog_expire_logs_seconds (multiply 30 days by 24 * 60 * 60)
- Replace deprecated innodb_log_file_size with innodb_redo_log_capacity (preserving the same configured capacity, which was set to 256M * 2 log files)
- Remove deprecated skip-symbolic-links (it is the default)
PR: 266511
Sponsored by: Netzkommune GmbH
Diffstat (limited to 'databases')
| -rw-r--r-- | databases/mysql80-server/files/my.cnf.sample.in | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/databases/mysql80-server/files/my.cnf.sample.in b/databases/mysql80-server/files/my.cnf.sample.in index 7fa72451dec3..3d1264c1bd61 100644 --- a/databases/mysql80-server/files/my.cnf.sample.in +++ b/databases/mysql80-server/files/my.cnf.sample.in @@ -14,19 +14,17 @@ bind-address = 127.0.0.1 basedir = %%PREFIX%% datadir = %%MY_DBDIR%% tmpdir = %%MY_TMPDIR%% -slave-load-tmpdir = %%MY_TMPDIR%% +replica-load-tmpdir = %%MY_TMPDIR%% secure-file-priv = %%MY_SECDIR%% log-bin = mysql-bin log-output = TABLE -master-info-repository = TABLE -relay-log-info-repository = TABLE relay-log-recovery = 1 slow-query-log = 1 server-id = 1 sync_binlog = 1 sync_relay_log = 1 binlog_cache_size = 16M -expire_logs_days = 30 +binlog_expire_logs_seconds = 2592000 default_password_lifetime = 0 enforce-gtid-consistency = 1 gtid-mode = ON @@ -47,12 +45,11 @@ innodb_log_group_home_dir = %%MY_DBDIR%% innodb_data_file_path = ibdata1:128M:autoextend innodb_temp_data_file_path = ibtmp1:128M:autoextend innodb_flush_method = O_DIRECT -innodb_log_file_size = 256M +innodb_redo_log_capacity = 512M innodb_log_buffer_size = 16M innodb_write_io_threads = 8 innodb_read_io_threads = 8 innodb_autoinc_lock_mode = 2 -skip-symbolic-links [mysqldump] max_allowed_packet = 256M |