From nobody Sun Jun 2 21:44:47 2024 X-Original-To: ports-bugs@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 4Vsr400tTVz5LJ7X for ; Sun, 02 Jun 2024 21:44:48 +0000 (UTC) (envelope-from bugzilla-noreply@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 4Vsr3z6xCXz3xDh for ; Sun, 2 Jun 2024 21:44:47 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1717364688; a=rsa-sha256; cv=none; b=JAL1GqN5crzMnPwnYc0+C7KVt8GT7aVrvgjgUb1yBk8Y7w4TvXW9hVTtzMGEscY/u6NT1Q Un4nMzIuaVaV7A+3PfjLqrd1oHRwYbSgcgTm3J/KbCMbU1jY8nwTPmGMUC7UfenCN7Vi9W mcbDmOnVYJcX5MU0VG7J6bq/UI7atoD4t/i7shyvqVkAW9eo4wJi4LBws2mAnH953zhkgX rpMEHZ+i9jzhIUwOIctA9DecBLEK2Z9n62Ekg8+aaKN4MahQDjXnwUf51DTMH5858PTZ/T cAFa8DWJxkOPEGQTLA0nEqWAON6vxwRmUYFNra8Z4tT7qtCPU9TaeeCJGbrjOA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1717364688; 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: in-reply-to:in-reply-to:references:references; bh=7ASQX3hL8xgLkA8XrHEorftFXoPzrq9h4ISQl2tHg94=; b=MEz0bqh57AhiEmCXECGhp9DpEpTsvJy7X6RGMEyUq42syBHjStnBoczE7kPjVuk1UqqRG6 NHO2klTUWExd10W+ViKUTDSTc1ZKp8JAKNcp0nNcRCTD+NGwyFhHZJr0BK+wHIW7rXmyTY ljc5dk+jpyuPkTljKv1Np2zBq7GhcK/anODSBSVyBiz7QXl04kbJg3AtDGCtRf9PyIgk6i NBWHFWlC1EsskHxmLT97F9m2izz6icI9lxtIfEYuFQ52zUWMgVcbQFZvN5lSFlitDGdGO/ cWThUpobkIqCdK7u5YPtIepHcYqrIsM+tMqDRG23uPRZd2GkoHyyLRnrMgGRWA== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (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 4Vsr3z6WPXz17Tg for ; Sun, 2 Jun 2024 21:44:47 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 452Lil3G098758 for ; Sun, 2 Jun 2024 21:44:47 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 452LilKK098757 for ports-bugs@FreeBSD.org; Sun, 2 Jun 2024 21:44:47 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 277922] Mk/bsd.default-versions.mk: Change default version of MySQL to MariaDB 10.11 (mysql=10.11m) Date: Sun, 02 Jun 2024 21:44:47 +0000 X-Bugzilla-Reason: CC X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Ports Framework X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: chris@cretaforce.gr X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: portmgr@FreeBSD.org X-Bugzilla-Flags: exp-run? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-ports-bugs@freebsd.org Sender: owner-freebsd-ports-bugs@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D277922 --- Comment #29 from Christos Chatzaras --- Migrating from MySQL 8.0 to MariaDB 10.11 involves more than simply uninstalling MySQL and installing MariaDB using the same /var/db/mysql data directory. There are numerous incompatibilities between the two systems. For instance, MySQL 8.0 supports collations like utf8mb4_0900_ai_ci, which are = not available in MariaDB. As a result, exporting databases in .sql format and importing them into MariaDB is impractical on a large scale. Additionally, there are differences in storage engines, authentication plugins, and optimizers, as well as query planners, all of which can lead to varying que= ry performance and behavior. --=20 You are receiving this mail because: You are on the CC list for the bug.=