Ram Leak Problem: Ram usage is constantly over 80%

CyberPanel Project Bug Report
1

I have also installed untouched Cyberpanel on centos 7 many times.
I have done a zero Cyberpanel installation on all versions of ubuntu.
But the result did not change.
I only have 1 or 2 websites on my server. While there is no problem when the server is running for the first time, after a certain period of time, the ram usage rises to over 80% by itself. (And my disk usage is increasing day by day, I don’t understand why.)
I have been using Cyberpanel for many years, but now I am feeling nauseous.
Please help me.

My Server Specs:
Ryzen 9 3950x 4 core, 4 GB Ram, 30 GB NVME SSD

System: Ubuntu 20.04.3 LTS
Codename: focal
OLS or Enterprise?
OpenLiteSpeed
Installing from official server or mirror server?
official
Install Memcached extension for PHP?
no
Install LiteSpeed Memcached?
no

Install Memcached?
no

Install Redis extension for PHP?
no

Install Redis?
no

Screenshot of the problem:

261×776 16.2 KB

1 Like
2

261×776 16.2 KB

1 Like
3

can you give the output of htop command.

4

1890×981 102 KB

@usmannasir

5

Why do you have so many MySQL processes? what are you running there?

6

@usmannasir I did not do anything.
I installed the official Cyberpanel on the newly installed server.
This is the result I am experiencing.
I don’t know why there are so many Mysql processes.
I am also looking for a solution.
There is only 1 website on Cyberpanel.

2 Likes
7

I know it has been a long time but did you find any solution to this ? I’m experiencing the same thing with mysql and I have only 1 website on my server. Thanks!

1 Like
8

I’m also having this problem :frowning:

1 Like
9

You are not alone, I have also been having this issue, ever since I installed Cyberpanel – on a server that has nothing going on in terms of actual usage, just a couple of sites currently parked. I’ve just learned to ignore it, as far as I’m concerned it’s a bug or something, because the performance has been just fine.

1 Like
10

my website is not getting loaded because of this issue. its not bug its actually my memory is engaged

1 Like
11

Same here, Any solution found?
The main question, why it’s loaded directly even after restarting the mysql server with fixed 6.6% for each process? where I can modify such configuration?

Screen Shot 2024-01-03 at 0.12.00
Screen Shot 2024-01-03 at 0.12.00680×680 115 KB

12

I found a solution. I switched to another control panel.

13

I am experiencing the same problem. Too many MySQL processes. I have to manually restart litespeed every few hours to reduce the usage.

But even after that the ram usage slowly rises back to 90% from 30%.

Can anyone help?

14

can you share output of htop

15

Screenshot 2024-01-30 141710
Screenshot 2024-01-30 1417101572×1011 167 KB

Mysql and Redis are the only ones consuming 32GB Ram.

Our average was 30-40% earlier.

16

Upgrade CyberPanel and go to 8090/dataBases/MysqlManager

Do you see any slow queries?

17

Its a paid tool. Any free option?
Also,
Recently When I disabled Redis on one of the hosted sites. The RAM usage dropped to 30%.
However, It’s still rising as Redis is enabled on another site.
May be that action triggered Redis to restart

18

On google you can search how to find slow mysql queries.

From there you will get to know which mysql queries are creating problem then we can try to figure it out.

19

I have recorded all the DB queries for 1 hour using a WordPress Plugin.
Please check this CSV file - 01022024 ‹ Index WP MySQL For Speed ‹ Example — WordPress.csv - Google Drive

I have replaced my domain with example.com.

20

First query is taking almost 41 seconds ?

SELECT DISTINCT p1.post_id FROM wp_postmeta p1 WHERE p1.meta_value LIKE ?s? AND p1.meta_key IN (?s?,?s?,?s?,?s?,?s?,?s?,?s?)