I have a backend server with 1G RAM for my HTTP server and my MariaDB.
I noticed the database keeps getting killed by OOM once or twice a day. Most of the time the OOM is triggered by the HTTP server, but not always.
I tried limiting innodb_buffer_pool_size lower and lower, it is at 64M at this moment, but the process is still taking 40% to 70% of the server's memory.
How do I find the reason of this memory usage? It appears to be some kind of memory leak, because it keeps increasing throughout the day and not releasing much of it.
The database usually starts consuming about 7% to 9% of memory usage.
MariaDB version 10.5