Need help with optimizing

[staberas]

Need help with optimization:
Current VPS is a 4Core with 4GB ram (3.8 free)
Currently hosting many sites wordpress but only one is heavy (15K posts + couple plugins)
Need help in optimising speed & stability

Currently the heavy site uses very big amount of memory php (version 7) & sql (MariaDB)
i have managed to keep it about 50% (various mysql-php configs i found) but it seems it wont last when new users enter or ask a different website.

Im kinda desperate and sleepless this few days need help..

 

[cPanelMichael]

Hello,

You may find the following thread helpful if you want to tune your MySQL configuration:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

However, you may also want to consult with a qualified system administrator if you don't receive additional user-feedback. You can see a list of system administration services at:

System Administration Services | cPanel Forums

Thank you.