search

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
254 stars 26 forks source link

Out of memory issue #205

Closed drupaladmin closed 10 months ago

drupaladmin commented 10 months ago

Experienced an out of memory issue today with a server that caused the server to halt this morning. I was a bit disappointed to experience this as I had not done the proper due diligence when applying configuration changes.

drupaladmin commented 10 months ago

To rollback recommended Releem configuration you could use this command: /opt/releem/mysqlconfigurer -r

You’re right you shouldn’t do the proper due diligence before apply.

We’re looking metrics from your server now to understand the root cause and prevent the issue in future.

Could you explain please are there any other applications except MariaDB on the server? I mean like a webserver which might use RAM sighnificantly.

drupaladmin commented 10 months ago

This server is an exception for us. It is a server hosted within our client's environment and includes both the app and database. Normally the app and databases are segmented into separate servers.

drupaladmin commented 10 months ago

In this case, you should set the memory_limit option for Releem Agent to prevent using the whole memory. This option means how much memory Releem could allocate for database (often, RAM minus [memory for the web server]). I suggest starting with the value 50% of RAM. If there will be a lot of free memory you could increase the limit.

To set this option, please follow this link https://releem.com/docs/getstarted#rec586933587