The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL needed on cPanel DNS-only?

Discussion in 'Database Discussions' started by JonTheWong, Jan 12, 2016.

  1. JonTheWong

    JonTheWong Active Member

    Joined:
    Oct 8, 2013
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Montreal, Quebec
    cPanel Access Level:
    Root Administrator
    Twitter:
    Can anyone confirm it is only needed for cPHulk on 11.54.00; i've noticed DNSOnly has been running sql with a higher load since 11.52

    mysql 530 0.0 11.6 1101420 460020 ? Sl Jan06 3:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dnsonly.domain.tld.err --pid-file=/var/lib/mysql/dnsonly.domain.tld.pid

    Tailwatch also seem to rely on sql; a list of services that currently rely on it would be ideal.
    Thank you.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    cPanel DNS-Only utilizes MySQL for:

    Exim Stats
    cPhulk
    MyDNS (Should you choose to use it instead of Bind)

    It will function as a name server should you choose to disable MySQL, but keep in mind certain cPanel functionality related to the list above may not work as intended, and you must use Bind as your name server.

    Thank you.
     
  3. JonTheWong

    JonTheWong Active Member

    Joined:
    Oct 8, 2013
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Montreal, Quebec
    cPanel Access Level:
    Root Administrator
    Twitter:
    Just wanted to follow up on this issue;

    The DNSOnly box does Not use any of the Services above.

    I've been looking at our system stats and its currently using 449MB concurrently. We have disabled mySQL from running and can't seem to find the reason for the increase in load.

    It seems to started after an update to 11.52 and as of now we are running 11.52.3.1 with the same problem, The DNS Server in question is a backup in Europe and has barely any activity.

    Any advise or reasoning; i've not properly followed the version numbers for mySQL on DNSOnly servers, so i'm not sure if an update to that process specifically was the cause.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you elaborate further on this? Are you referring to memory usage?

    Thank you.
     
  5. syslint

    syslint Well-Known Member

    Joined:
    Oct 9, 2006
    Messages:
    249
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you on a vps too ? if so which type ?
     
  6. JonTheWong

    JonTheWong Active Member

    Joined:
    Oct 8, 2013
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Montreal, Quebec
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes sorry i'm talking about memory; Its been running at ~450mb on the DNSOnly system consistently.
    Compared to 170MB consistent on a full cPanel installer with 40% more overall load.

    DNS - mysqld (mysql) # 0.0% CPU USAGE 449 MB MEMORY USAGE 1 INSTANCE RUNNING
    vs
    cPanel - mysqld (mysql) # 0.0% CPU USAGE 178 MB MEMORY USAGE 1 INSTANCE RUNNING

    Based on my traces nothing is using it. Non of the above services are running and the only thing that was complaining was Tailwatch.

    System specs:

    DNSOnly:
    OpenStack Container
    CentOS 7.2 Linux 3.10.0-327.10.1.el7.x86_64
    Intel Xeon 1 cores 3.8 GB RAM

    cPanel:
    OpenStack Container
    CentOS 7.2 Linux 3.10.0-327.10.1.el7.x86_64
    Intel Xeon 4 cores 31.8 GB RAM

    Stats are based on the last 24 hours; but its been this way since 11.52.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  8. JonTheWong

    JonTheWong Active Member

    Joined:
    Oct 8, 2013
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Montreal, Quebec
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thank you for your post; i'm not experiencing lack of memory. I've just noticed that the memory allocated to SQL on DNSONLY is larger then expected after the update to 11.54. Long term stats shows 3 x allocation above 11.52.

    I was just wondering if anyone else noticed this or if you had inside information.
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I've not seen any additional reports of problems with memory usage on cPanel DNS-Only installations related to MySQL. What version of MySQL is installed on your DNS-Only server?

    Thank you.
     
  10. JonTheWong

    JonTheWong Active Member

    Joined:
    Oct 8, 2013
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Montreal, Quebec
    cPanel Access Level:
    Root Administrator
    Twitter:
    /usr/sbin/mysqld Ver 5.6.29 for Linux on x86_64 (MySQL Community Server (GPL))

    Here is some more information just in case.

    Service Manager

    ChkServd
    Cron Daemon
    cPanel DNS Admin Cache
    Exim Mail Server
    IP Aliases
    DNS Server
    Name Service Cache Daemon
    SSH Daemon
    rsyslog System Logger Daemon

    Other Services Running
    SMX Plugin
    CSF / LFD
    NewRelic Monitoring Daemon

    Everything else is default CentOS 7.2.
    With SQL Disabled everything goes back to 11.52 overall usage.

    Disabled;
    Exim Stats
    cPhulk

    Nothing special besides everything else i mentioned. I'd have to turn mySQL back on and do more diagnostics to see whats actually running and why its being assigned more resources.
     
  11. JonTheWong

    JonTheWong Active Member

    Joined:
    Oct 8, 2013
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Montreal, Quebec
    cPanel Access Level:
    Root Administrator
    Twitter:
    Here are some logs; When i enable mySQL in Service Manager it spawns the below processes.
    When i run a trace on the below processes some seem empty most keep spamming the below logs.


    PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command

    8234 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8235 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8236 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8237 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8238 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8239 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8240 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8241 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8242 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8243 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8245 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8246 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8247 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8248 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8249 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8250 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8251 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8252 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8253 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8254 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8497 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir
    8226 mysql 20 0 1011M 439M 5300 S 0.0 11.4 0:00.82 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/ir

    Trace of process 8241 - /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/dns.example.tld.err --pid-file=/var/lib/mysql/dns.example.tld.pid
    Process 8241 attached
    io_getevents(140521874259968, 1, 256, {}{0, 500000000}) = 0
    io_getevents(140521874259968, 1, 256, {}{0, 500000000}) = 0
    io_getevents(140521874259968, 1, 256, {}{0, 500000000}) = 0
    io_getevents(140521874259968, 1, 256, {}{0, 500000000}) = 0

    [​IMG]
     
    #11 JonTheWong, Mar 15, 2016
    Last edited: Mar 15, 2016
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You can open a support ticket using the link in my signature if you want us to take a closer look and rule out any issues with the DNS-Only software. Feel free to post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page