The consumption of my memory is high because

Question

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

Answer 1

bobbyiliev September 1, 2020

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:

mysql -u your_user -p

SHOW FULL PROCESSLIST;

Hope that this helps!
Regards,
Bobby

Reply Report

Related