Lack of free Swap Space

MySQL & MariaDB Other MySQL® Questions
1

HI,

I’m having in 2 servers some problems with swap space. I’ve added more swap space, but it seems that mysql percona server is using it all.

If I restart mysql , everything goes ok again.

How can I solve this ?

Thanks.

2

Hi sience;

It sounds like your MySQL instance is using up more memory than you have available, so you need to update your configuration to allocate / allow less memory (i.e. innodb_buffer_pool_size likely is the bulk of it if you use InnoDB). It gets “fixed” when you restart MySQL, because that frees up the memory.

-Scott

3

I’m going back to this “situation” , the innodb_buffer_pool_size configuration update doesn’t solve this problem (?) . What more can be done?