Issue Constantly increasing Mysql memory usage problem

[orcunaras]

Server operating system version

Ubuntu 22.04

Plesk version and microupdate number

18.0.69

I have 2 ubuntu servers over IONOS. One of them is 6 y.o and two of my wordpress sites use near 270 mb mysql memory.

But my new server alarmed 6 months ago and i discovered mysql memory usage increased over 7 GB. I reset it many times and check these:

*Php configuration
*Nginx conf.
*Php version and php.ini
*Ubuntu/Alma
*InnoDB conf
*migrated a good copy of site (from my old server) to my new server and increased same as old scenario.

What is wrong with me? There is one wordpress/wocoommerce site on 12vcpu 24gb server. I tested on 4vcpu 8 gb and it was same.
No matter what I do, even though memory seems to remain stable for 1-2 days, it reaches serious levels by the end of the week.

I decided to start everything from scratch, but who knows if this problem will not reoccur?

On my new server, behaviour


On my old server, behaviour:

 

[Raul A.]

What MariaDB version are you using? Older versions are known to allocate RAM and never release it.

 

[orcunaras]

I'm using 10.11.11 .

Also on my old server its 10.1.48 with no problem.

 

[Bitpalast]

MariaDB will occupy up to so many GB as you grant it in my.cnf for the innodb_buffer_pool_size variable. Once it comes close to the limit, it will clear some RAM to reuse it for new data. So if you lower the value to for example 2 GB you should see usage limited to no more than 2 GB. However, some docs recommend to give it two thirds of your total RAM. By my own experience I can recommend to grant lush amounts of buffer RAM. While it will decrease the speed at which MariaDB starts and stops (it can take several minutes for it), it will greatly enhance the performance while it is running.

 

[orcunaras]

I completely understand what you said and put it into logic.

I just don't understand this, I run 'innodb_buffer_pool_size' on phpmyadmin and it says buffer pool size is 128MB. So how come RAM usage is still increasing in this case?

Anyway, I setted at 4g on my cnf file (server has 8gb), and waiting for usage behaviour.

Thank you so much