MySQL needed on cPanel DNS-only?

JonTheWong

Active Member
Oct 8, 2013
38
2
58
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
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.
 

JonTheWong

Active Member
Oct 8, 2013
38
2
58
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
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.
 

JonTheWong

Active Member
Oct 8, 2013
38
2
58
Montreal, Quebec
cPanel Access Level
Root Administrator
Twitter
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.
 

JonTheWong

Active Member
Oct 8, 2013
38
2
58
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
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.
 

JonTheWong

Active Member
Oct 8, 2013
38
2
58
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.
 

JonTheWong

Active Member
Oct 8, 2013
38
2
58
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

 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
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.