Skip to main content

What is the true RAM usage?

sajithgsm
Hello, My WHM's server status and server information page's showing different values for the RAM usage. What is the true RAM usage? -09-04 at 7.38.36 PM.jpg">73453 -09-04 at 7.38.47 PM.jpg">73457-09-04 at 7.40.00 PM.jpg">73461 Can you please tell me what is the TRUE usage of RAM? Do I need to upgrade the RAM?

Comments

12 comments

Date Votes
  • ankeshanand
    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!
    0
  • sajithgsm
    Thank you Ankesh, the problem is, this server is not showing actual memory usage on the Services Status page. it is different than FREE -H results. is there any problem?
    0
  • ankeshanand
    Consider the Service Status Page as Correct!;) (Caching is included in Free Space)
    0
  • sajithgsm
    Consider the Service Status Page as Correct!;) (Caching is included in Free Space)

    Perfect. then no need to worry about it. Thanks Ankesh :D
    0
  • sajithgsm
    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?
    0
  • cPRex Jurassic Moderator
    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?
    0
  • sajithgsm
    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. Here is the Services Status. Here is the Server information page. 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?
    0
  • sajithgsm
    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?
    0
  • Vs Nu
    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?-10-03 at 1.14.40 PM.jpg">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)
    0
  • cPRex Jurassic Moderator
    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: mysqladmin proc status
    0
  • sajithgsm
    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: mysqladmin proc status

    [root@thor ~]# 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 [root@thor ~]# this is the result. Thank you so much.
    0
  • cPRex Jurassic Moderator
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post