From owner-freebsd-database@freebsd.org Thu Oct 1 06:48:33 2020 Return-Path: Delivered-To: freebsd-database@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 7E25E3FD203 for ; Thu, 1 Oct 2020 06:48:33 +0000 (UTC) (envelope-from mail@osfux.nl) Received: from vm1982.osfux.nl (vm1982.osfux.nl [79.99.187.212]) (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 mx1.freebsd.org (Postfix) with ESMTPS id 4C23cJ305cz4sCF for ; Thu, 1 Oct 2020 06:48:32 +0000 (UTC) (envelope-from mail@osfux.nl) Received: from vm1982.osfux.nl (localhost [127.0.0.1]) by vm1982.osfux.nl (Postfix) with ESMTP id 00D412013A for ; Thu, 1 Oct 2020 08:48:24 +0200 (CEST) X-Spam-Status: No, score=0.0 required=5.0 tests=none shortcircuit=no X-Spam-Checker-Version: SpamAssassin 3.4.3 Received: from [192.168.9.195] (unknown [95.174.67.156]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by vm1982.osfux.nl (Postfix) with ESMTPSA for ; Thu, 1 Oct 2020 08:48:24 +0200 (CEST) Subject: Re: Mysql Swap To: freebsd-database@freebsd.org References: From: Ruben Message-ID: Date: Thu, 1 Oct 2020 08:48:24 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: 4C23cJ305cz4sCF X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.08 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; ARC_NA(0.00)[]; R_DKIM_ALLOW(-0.20)[osfux.nl:s=default]; NEURAL_HAM_MEDIUM(-1.01)[-1.009]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; R_SPF_ALLOW(-0.20)[+mx]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; TO_DN_NONE(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; NEURAL_HAM_LONG(-0.98)[-0.981]; RCVD_COUNT_THREE(0.00)[3]; DKIM_TRACE(0.00)[osfux.nl:+]; DMARC_POLICY_ALLOW(-0.50)[osfux.nl,reject]; NEURAL_HAM_SHORT(-1.09)[-1.092]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:8315, ipnet:79.99.184.0/21, country:NL]; MID_RHS_MATCH_FROM(0.00)[]; MAILMAN_DEST(0.00)[freebsd-database] X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Oct 2020 06:48:33 -0000 One way of ascertaining current connection settings and getting a summary of memory settings is by using port/pkg mysqltuner . Regards, Ruben On 9/30/20 11:03 PM, Jack L. wrote: > That shouldn't happen if mysql is tuned properly. Each connection uses > RAM configured in your buffer settings so if you have a lot of > connections with high buffer configs, it can use too much RAM. > > On Wed, Sep 30, 2020 at 11:19 AM Cristian Cardoso > wrote: >> >> Hi >> I would like to know if anyone happens to have problems with swap >> consumption with Mysql. >> Here I run Mysql 5.7.30 on a FreeBSD 12.1 and over time, even with >> memory left, Mysql consumes all the swap, this consumption is >> normalized after the service restart. >> I already ran the mysql-tuner to see if it solved, but without >> success, even analyzing queries, the service with 8G of ram left over, >> over time ends the swap. >> _______________________________________________ >> freebsd-database@freebsd.org mailing list >> https://lists.freebsd.org/mailman/listinfo/freebsd-database >> To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" > _______________________________________________ > freebsd-database@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" >