Re: Mysql Swap

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
> <[email protected]> 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.
>> _______________________________________________
>> [email protected] mailing list
>> https://lists.freebsd.org/mailman/listinfo/freebsd-database
>> To unsubscribe, send any mail to "[email protected]"
> _______________________________________________
> [email protected] mailing list
> https://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "[email protected]"
> 
_______________________________________________
[email protected] mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[email protected]"