From nobody Sat Oct 29 15:08:28 2022 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4N02qJ6G9wz4g3yv; Sat, 29 Oct 2022 15:08:28 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4N02qJ5nxTz3l8b; Sat, 29 Oct 2022 15:08:28 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1667056108; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=41EINRYasmY2hnvT3suliz7WpOGB2kCkQO05JyvGBJc=; b=cmtsUStaxcqJaSsnlPE3GH/QonuUNsQu6t1mFV63z8BBsS4jE1rLI16ec0t5Zcm4CxWj2P R/rI4keh3+6fZW3Q0C5sPitMMXUzPizwl9oidUu9gduhGAIjX4sEUmqVP8iqm1I/U0IONa sMjMELXxuITg1aYdCCaW9uMgtljx6wbSv66aTejXVZubcyFAKZ5ocY51V+xiT3/Pa+jVIa 98oU3c8tk/eYNnTPhnPWjoEBawvdQjTlHTHyGcP9RCxCRiM4362exTp4OJ1HGUGFNocn41 7sGWStqQ7adNBYFot5nBK20z8m6GLEN8r77D+cmudJR/1k7b5oaTFukIa+fN5w== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4N02qJ4tMmzM18; Sat, 29 Oct 2022 15:08:28 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 29TF8Sa7049317; Sat, 29 Oct 2022 15:08:28 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 29TF8SUb049316; Sat, 29 Oct 2022 15:08:28 GMT (envelope-from git) Date: Sat, 29 Oct 2022 15:08:28 GMT Message-Id: <202210291508.29TF8SUb049316@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Jochen Neumeister Subject: git: 1bc699507cae - main - databases/mysql80-server: Update my.cnf.sample List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: joneum X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 1bc699507caeb6807ec13443074567da4c847596 Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1667056108; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=41EINRYasmY2hnvT3suliz7WpOGB2kCkQO05JyvGBJc=; b=m7mKUWvi5fM/66W0Lgh9+usl8Y6Kyjdl4FHyk23IRE6Yfb2t9efk0tVRJ9IvN7sb2XtCyQ IGn2yCGGlVl6Pezgc+Bftek7kYrS9uIhEFHg3F8OzJQSH3V2BxY99CgCvuJY8pvl1zkPCI vjHlwU3QonRt1B44odV5EcVVEXdPYDnZIAYpcgyVlfymXcOwxrOKijmeB0nVMcSTn+WXCL uVvmJt+CZxc8J8qggc9VsNY3PBhEDxzmwygJoswxL0HeMEEBJ5xUOjVt9YpEdA6HU0ddgj Q/V/ieHNhdNVExqy82d0aoskpmzx7mLwriksoPWZgopAKaYg4CsjxManTot5Ow== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1667056108; a=rsa-sha256; cv=none; b=tYBicszZlvpEoNpUApsRvhWwImsQZ0aa9Ibvhgz+4KrCLPnAmbz4qD1E0oIXNdXNo/LISi YCwvMC1TvSzqKffyAgNn4FqaQi1Kc1A4e5xSQdHIpvHucGA2GQ8iq8n/tTRTI9d1Jl9AGV 3w6DNERjwdGYhiuK7sMwTlW8uZR6ICmkyxKv5vkvRcS2mJjk+tKi65LpcuyK+6cANNVPb/ 01wkP7g+rGWncUlxPXzxVzSZlTGKmJuHzihQg2N5xphRtStcJe8KJ9kQVY3r33PHIP1mb6 aDsMT0uNbCtOk3xoVvVI18FPXMVt9zuVU5eFJAJX2BK+ESi5aBi4X31L+K6CZg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by joneum: URL: https://cgit.FreeBSD.org/ports/commit/?id=1bc699507caeb6807ec13443074567da4c847596 commit 1bc699507caeb6807ec13443074567da4c847596 Author: Jochen Neumeister AuthorDate: 2022-10-29 15:07:07 +0000 Commit: Jochen Neumeister 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