Date: Wed, 30 Sep 2020 14:03:52 -0700 From: "Jack L." <xxjack12xx@gmail.com> To: Cristian Cardoso <cristian.cardoso11@gmail.com> Cc: freebsd-database@freebsd.org Subject: Re: Mysql Swap Message-ID: <CALeGphyZcE_NU6hzJDRhSXVdvmCuKNy7kMZoCBSrS-O-VagpqA@mail.gmail.com> In-Reply-To: <CAKeEC-K85OhocVnBZdHE1fpeGjN1XT8O1m3GBuBxm7GDWd8L8w@mail.gmail.com> References: <CAKeEC-K85OhocVnBZdHE1fpeGjN1XT8O1m3GBuBxm7GDWd8L8w@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CALeGphyZcE_NU6hzJDRhSXVdvmCuKNy7kMZoCBSrS-O-VagpqA>