Skip to main content

MySQL needed on cPanel DNS-only?

JonTheWong
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.

Comments

11 comments

Date Votes
  • cPanelMichael
    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.
    0
  • JonTheWong
    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.
    0
  • cPanelMichael
    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.

    Could you elaborate further on this? Are you referring to memory usage? Thank you.
    0
  • syslint
    Are you on a vps too ? if so which type ?
    0
  • JonTheWong
    Could you elaborate further on this? Are you referring to memory usage? Thank you.

    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.
    0
  • cPanelMichael
    Are you experiencing lack of memory issues on the system? Please ensure you review the following post: Memory usage apparently higher than expected Thank you.
    0
  • JonTheWong
    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.
    0
  • cPanelMichael
    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.
    0
  • JonTheWong
    /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.
    0
  • JonTheWong
    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 ]http://i.imgur.com/0Vufvv7.png
    0
  • cPanelMichael
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post