1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

NodeQuery - High Resource Consumption

Discussion in 'Server Configuration and Hosting' started by tajhay, Apr 14, 2016.

  1. tajhay

    tajhay Well-Known Member

    Not related to Xenforo, so please more to the appropriate area if seemed unsuitable for this section.

    So i have recently been getting nodequery email alerts saying I have high resource consumption.

    Example is as below:
    Server: website.com
    Last Update: 2016-04-14 14:57:16
    Alert Trigger: 2016-04-14 14:59:01

    Average: 0.26 0.28 0.27

    System Load: 1%
    Ram Usage: 82%
    Disk Usage: 64%

    httpd 17.7% 393.01 MB nobody (11)
    mysqld 3.3% 3.2 GB mysql (1)
    memcached 0.2% 81.89 MB memcached (1)
    spamd child 0% 27.75 MB root (1)
    cpsrvd (SSL) - 0% 21.65 MB root (1)
    lfd - sleeping 0% 20.4 MB root (1)
    httpd 0% 17.61 MB root (1)
    named 0% 13.89 MB named (1)
    sshd 0% 12.93 MB root (7)
    tailwatchd 0% 10.73 MB root (1)

    I have only 189 people online and my Ram is 6GB on my VPS. Is there a reason why mySQL is taking up 3.2GB?

    Any ideas?

    Do i need to bump up my RAM as this is not even a busy period, and are there any processes that can be deactivated that are not needed? For example i do use memcached, but not sure about the others (Sorry im not a hardware/network literate person).

    @MattW Any ideas?
     
  2. RoldanLT

    RoldanLT Well-Known Member

    Try to lower your innodb_buffer_pool to 1gb.
     
    DeMelo likes this.

Share This Page