sajithgsm

Well-Known Member
Jun 9, 2020
48
10
83
Sri Lanka
cPanel Access Level
Root Administrator
Hello,

My WHM's server status and server information page's showing different values for the RAM usage.

What is the true RAM usage?
Screenshot 2021-09-04 at 7.38.36 PM.jpg
Screenshot 2021-09-04 at 7.38.47 PM.jpgScreenshot 2021-09-04 at 7.40.00 PM.jpg

Can you please tell me what is the TRUE usage of RAM?

Do I need to upgrade the RAM?
 
Last edited by a moderator:

ankeshanand

Well-Known Member
Mar 29, 2021
203
61
103
India
cPanel Access Level
Root Administrator
No, You don't need to upgrade your RAM because you still have 42GB RAM available for Usage! RAM actually used is just 11GB and the Rest is Temprorary Cache used in order to increase performance but in case Free RAM is not there, System will Clear Cache and Create Space!
SWAP is not technically RAM but Hard disk which is used by Machine when RAM goes Full!
 
  • Love
Reactions: sajithgsm

sajithgsm

Well-Known Member
Jun 9, 2020
48
10
83
Sri Lanka
cPanel Access Level
Root Administrator
My All other servers are showing RAM as:
Service Status Page > RAM Usage = True Usage
Server Information Page > RAM usage = True Usage


But this server only showing:
Services Status Page > RAM Usage = True Usage + Cache
Server Information Page > RAM Usage = True Usage Only.

Is there any way to fix this as same as other servers?
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,028
313
cPanel Access Level
Root Administrator
The data in WHM >> Server Information is pulled directly from the "free" command on the system, so that will always be an accurate representation.

The data in WHM >> Service Status applies some math to show the percentage. Are you saying the pages are showing different values?
 

sajithgsm

Well-Known Member
Jun 9, 2020
48
10
83
Sri Lanka
cPanel Access Level
Root Administrator
Is this type of high memory usages for the MySQL is normal?
My other servers are not like this. only one server has this problem.
when run mysql server reboot, the ram usage will be clean but increment will not end.
Screenshot 2021-10-03 at 12.02.17 PM.jpg

Here is the Services Status.

Screenshot 2021-10-03 at 12.14.36 PM.jpg


Here is the Server information page.

Screenshot 2021-10-03 at 12.14.16 PM.jpg

And,

when I reboot the mysql server , top -c showing mysql ram usage is dropped but the server actual usages are never change.

Any Idea?
 

Vs Nu

Well-Known Member
Jul 17, 2015
137
9
68
India
cPanel Access Level
Root Administrator
Is this MySQL usage are normal?
this was previously 30% and now it is 60%.
MySQL Governor also running there.

Is there any way to get the high MySQL usage accounts?View attachment 73961
You can consider installing mytop to find out the MySQL process which is running for longtime or which are sleeping for long time.
Mysql Sleep may create such issues (Mysql Overloads)
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,028
313
cPanel Access Level
Root Administrator
That usage definitely does not seem normal to me. I would recommend running the following command to see what MySQL is doing in real-time on that system, which will hopefully provide you with more details about why the RAM usage is so high:

Code:
mysqladmin proc status
 
  • Like
Reactions: sajithgsm

sajithgsm

Well-Known Member
Jun 9, 2020
48
10
83
Sri Lanka
cPanel Access Level
Root Administrator
That usage definitely does not seem normal to me. I would recommend running the following command to see what MySQL is doing in real-time on that system, which will hopefully provide you with more details about why the RAM usage is so high:

Code:
mysqladmin proc status

[[email protected] ~]# mysqladmin proc status
+---------+----------------------+-----------------------+----------------------+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+---------+----------------------+-----------------------+----------------------+---------+------+--------------------------+------------------+----------+
| 1 | system user | | | Daemon | | InnoDB purge coordinator | | 0.000 |
| 2 | system user | | | Daemon | | InnoDB purge worker | | 0.000 |
| 3 | system user | | | Daemon | | InnoDB purge worker | | 0.000 |
| 4 | system user | | | Daemon | | InnoDB purge worker | | 0.000 |
| 5 | system user | | | Daemon | | InnoDB shutdown handler | | 0.000 |
| 34 | root | localhost | information_schema | Sleep | 7 | | | 0.000 |
| 3693806 | capitalw_capital | 212.104.237.210:51557 | | Sleep | 5257 | | | 0.000 |
| 3693881 | capitalw_capital | 212.104.237.210:51558 | capitalw_ceylaninc | Sleep | 5146 | | | 0.000 |
| 3694009 | capitalw_capital | 212.104.237.210:51559 | capitalw_ceylaninc | Sleep | 5244 | | | 0.000 |
| 3695201 | capitalw_capital | 212.104.237.210:51560 | capitalw_ceylaninc | Sleep | 5166 | | | 0.000 |
| 3695543 | capitalw_capital | 212.104.237.210:51561 | capitalw_ceylaninc | Sleep | 5138 | | | 0.000 |
| 3701359 | capitalw_capital | 212.104.237.210:51562 | capitalw_inout | Sleep | 4727 | | | 0.000 |
| 3701806 | capitalw_capital | 212.104.237.210:51565 | capitalw_inout | Sleep | 4626 | | | 0.000 |
| 3726073 | capitalw_capital | 212.104.237.210:51567 | capitalw_ceylaninc | Sleep | 2662 | | | 0.000 |
| 3728370 | capitalw_capital | 212.104.237.210:51568 | capitalw_ceylaninc | Sleep | 3030 | | | 0.000 |
| 3744731 | hyperfle_smsapi | 112.134.158.253:48387 | hyperfle_sms_gateway | Sleep | 15 | | | 0.000 |
| 3788142 | root | localhost | information_schema | Sleep | 24 | | | 0.000 |
| 3788614 | homepla3_wp76 | localhost | homepla3_wp76 | Sleep | 4 | | | 0.000 |
| 3788636 | vegboxlk_wp584 | localhost | vegboxlk_wp584 | Sleep | 0 | | | 0.000 |
| 3788681 | yklibrar_wp738 | localhost | yklibrar_wp738 | Sleep | 0 | | | 0.000 |
| 3788719 | srilan21_wp188 | localhost | srilan21_wp188 | Sleep | 0 | | | 0.000 |
| 3788720 | srilan21_wp188 | localhost | srilan21_wp188 | Sleep | 0 | | | 0.000 |
| 3788723 | animeslc_wp772 | localhost | animeslc_wp772 | Sleep | 0 | | | 0.000 |
| 3788731 | lmsthusharapriya_630 | localhost | lmsthusharapriya_630 | Sleep | 0 | | | 0.000 |
| 3788732 | nowonsup_root | localhost | nowonsup_pharmacy | Sleep | 0 | | | 0.000 |
| 3788733 | root | localhost | | Query | 0 | Init | show processlist | 0.000 |
+---------+----------------------+-----------------------+----------------------+---------+------+--------------------------+------------------+----------+
Uptime: 256762 Threads: 50 Questions: 185815130 Slow queries: 31 Opens: 3552941 Flush tables: 1 Open tables: 4096 Queries per second avg: 723.686
[[email protected] ~]#

this is the result. Thank you so much.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,028
313
cPanel Access Level
Root Administrator
That definitely looks like it could be an issue. There are over 700 queries per second happening and it seems many of those are falling into a sleep state. It might be best to work with a MySQL administrator to see why those specific queries are not completing, and to optimize the server to better handle the amount of MySQL queries.