Date: Sat, 29 Oct 2022 15:08:28 GMT From: Jochen Neumeister <joneum@FreeBSD.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org Subject: git: 1bc699507cae - main - databases/mysql80-server: Update my.cnf.sample Message-ID: <202210291508.29TF8SUb049316@gitrepo.freebsd.org>
next in thread | raw e-mail | index | archive | help
The branch main has been updated by joneum: URL: https://cgit.FreeBSD.org/ports/commit/?id=1bc699507caeb6807ec13443074567da4c847596 commit 1bc699507caeb6807ec13443074567da4c847596 Author: Jochen Neumeister <joneum@FreeBSD.org> AuthorDate: 2022-10-29 15:07:07 +0000 Commit: Jochen Neumeister <joneum@FreeBSD.org> CommitDate: 2022-10-29 15:08:22 +0000 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 --- databases/mysql80-server/files/my.cnf.sample.in | 9 +++------ 1 file 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202210291508.29TF8SUb049316>