From nobody Sat Nov 13 13:27:29 2021 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 D964B184C018 for ; Sat, 13 Nov 2021 13:27:29 +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 4Hrx8K5jBKz4sps for ; Sat, 13 Nov 2021 13:27:29 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) 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 96A51140E9 for ; Sat, 13 Nov 2021 13:27:29 +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 1ADDRT2t094702 for ; Sat, 13 Nov 2021 13:27:29 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 1ADDRT2P094701 for ports-bugs@FreeBSD.org; Sat, 13 Nov 2021 13:27:29 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 259816] databases/mysql80-server: 8.0.26 seems to leaks memory compared to 8.0.25 Date: Sat, 13 Nov 2021 13:27:29 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: pete@twisted.org.uk X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: joneum@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name attachments.created Message-ID: 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: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D259816 Bug ID: 259816 Summary: databases/mysql80-server: 8.0.26 seems to leaks memory compared to 8.0.25 Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: joneum@FreeBSD.org Reporter: pete@twisted.org.uk Flags: maintainer-feedback?(joneum@FreeBSD.org) Assignee: joneum@FreeBSD.org Created attachment 229468 --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=3D229468&action= =3Dedit the my.cnf file from one of the affected servers Upgraded to 8.0.26 from packages a week ago. Since then the server gradually increases memory usage until it consumes all of swap. This looks like a classic memory leak, except for one thing - when swap is filled then mysql releases all the extra memory. So it does know there is memory to be released somehow, it just isnt doing it until it runs out of space. The rate of memory growth is related to the rate of new connections establi= shed to the server. Recoding the application to sue less simultaneous connections has mitigated the problem, but it still exists. As mysql 8 will not run over earlier versions of its files then a downgrade back to 8.0.25 is not feasible as a workaround either. I have attached my my.conf file in case I am doing anything odd with the co= nfig to trigger this. But even if so, this is a problem which has appeared with 8.0.26 as this config worked fine before. thanks! -pete. --=20 You are receiving this mail because: You are the assignee for the bug.=