The consumption of my memory is high because

Posted August 28, 2020 269 views
MySQLPHPDigitalOceanLinux Commands

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.

Submit an Answer
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:

Hope that this helps!