Hello, good afternoon, I have two systems: web, Intranet installed on my VPS (4GB RAM AND 80 DISK)

But it surprises me because memory consumption is high and that only 5 users enter the intranet and the web will visit 30 people a day:

run htop to display what that I get:

Image Link

edited by bobbyiliev

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hi there @slira,

It looks like there are a lot of open MySQL connections.

What I could suggest is checking what queries are being executed and see if there are any sleeping ones or long-running ones.

During the next spike, you can do that by running the following:

  • First access MySQL
mysql -u your_user -p
  • Then check your process list:
SHOW FULL PROCESSLIST;

Hope that this helps!
Regards,
Bobby

Submit an Answer