Date: Thu, 1 Oct 2020 08:48:24 +0200 From: Ruben <mail@osfux.nl> To: freebsd-database@freebsd.org Subject: Re: Mysql Swap Message-ID: <eb8fe7a6-e2d4-588d-23b5-a01296633366@osfux.nl> In-Reply-To: <CALeGphyZcE_NU6hzJDRhSXVdvmCuKNy7kMZoCBSrS-O-VagpqA@mail.gmail.com> References: <CAKeEC-K85OhocVnBZdHE1fpeGjN1XT8O1m3GBuBxm7GDWd8L8w@mail.gmail.com> <CALeGphyZcE_NU6hzJDRhSXVdvmCuKNy7kMZoCBSrS-O-VagpqA@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 > <cristian.cardoso11@gmail.com> 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" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?eb8fe7a6-e2d4-588d-23b5-a01296633366>