How to make the most of the RAM on a VPS server?

Question

Server optimization

There is a hosting server.
RAM is used constantly within these limits: 2.5 GB out of 5.00 GB (test 100 days).
I would like to bring the use to 4 / 4.5 in order to increase performance.
What configs are better to edit or install something?
I use mariadb + PHP-FPM + php7.3
Is it somehow possible to put the entire database into the RAM and put frequently used files + memcache and attach it to loaded sites ...

Answer 1

I think you first need to figure out what your problem is. If the problem is that not all memory is utilized, well, write a script that will write from / dev / random to memory. Are you also trying to eat up all the memory on your home PC?)
And if you still want to increase the speed of the sites, then determine why it is low and optimize this place. If there is a bug in the database, well, optimize the database, but not so that it requires 20G of memory in the load and the server falls by oom. If the problem is in scripts, then optimize them, opcache, code, sql, etc. If you want to install memcached, install it, put it in one command, only you need to connect it correctly to the site, determine what is worth caching and what is not.
Configs are better to edit those that are responsible for setting up the service you are configuring.
In general, contact the administrator or your tech. they will do everything for you, optimization is an integrated approach, there is no settings file in which you can set one parameter and everything will be fast and good.

Answer 2

Rewrite your code to use memory instead of cpu