PowerDNS 4.5.3

Uptime: 27.7 days
Queries/second, 1, 5, 10 minute averages: 1, 2, 2. Max queries/second: 57
Cache hitrate, 1, 5, 10 minute averages: 69.8%, 80.1%, 80.3%
Backend query cache hitrate, 1, 5, 10 minute averages: 87.2%, 88.8%, 87.8%
Backend query load, 1, 5, 10 minute averages: 0, 0, 0. Max queries/second: 1
Total queries: 4848337. Question/answer latency: 0.795ms


Reset

Log Messages

Not validating response for security status update, this is a non-release version132667.8%
Backend reported permanent error which prevented lookup (GSQLBackend unable to lookup 'domainhostingpal.com|ANY':Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=?: Lost connection to MySQL server during query), aborting623.2%
Backend error: GSQLBackend unable to lookup 'domainhostingpal.com|ANY':Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=?: Lost connection to MySQL server during query432.2%
Backend reported permanent error which prevented lookup (GSQLBackend unable to lookup 'domainhostingpal.com|ANY':Could not execute mysql statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=?: Lost connection to MySQL server during query), aborting211.1%
Cleaning up70.4%
PDNSException while updating zone cache: Database error trying to retrieve all domains:Could not prepare statement: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ?: Lost connection to MySQL server during query70.4%
TCP server is without backend connections, launching50.3%
Backend error: GSQLBackend unable to lookup 'domainhostingpal.com|ANY':Could not execute mysql statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=?: Lost connection to MySQL server during query50.3%
Caught an exception instantiating a backend: Unable to launch gmysql connection: Please add '(gmysql-)innodb-read-committed=no' to your PowerDNS configuration, and reconsider your storage engine if it does not support transactions.: ERROR 0 (00000): 50.3%
gmysql Connection failed: Please add '(gmysql-)innodb-read-committed=no' to your PowerDNS configuration, and reconsider your storage engine if it does not support transactions.: ERROR 0 (00000): 50.3%
Rest:47124.1%
Total:1957100%
Reset

Remote server IP addresses

67.215.80.1302742.7%
67.215.80.1372722.7%
67.215.80.1342592.6%
67.215.80.1402562.6%
67.215.80.1332522.5%
67.215.80.1392492.5%
67.215.80.1352432.4%
67.215.80.1382402.4%
67.215.80.1312342.3%
67.215.80.1322272.3%
Rest:749474.9%
Total:10000100%
Reset

Remote hosts sending corrupt packets

165.227.156.2252010.2%
24.199.112.66157.7%
174.138.84.177147.1%
139.59.125.28147.1%
167.172.224.131147.1%
170.64.229.4294.6%
209.38.107.23773.6%
192.238.254.12373.6%
202.112.237.20152.6%
185.100.87.13642.0%
Rest:8744.4%
Total:196100%
Reset

Remote hosts querying zones for which we are not auth

67.215.80.1394014.0%
67.215.80.1343984.0%
67.215.80.1333943.9%
67.215.80.1303853.9%
67.215.80.1383713.7%
67.215.80.1353693.7%
67.215.80.1373673.7%
67.215.80.1403653.6%
67.215.80.1313633.6%
67.215.80.1323583.6%
Rest:622962.3%
Total:10000100%
Reset

Queries for existing records, but for type we don't have

Total:0100%
Reset

Queries for non-existent records within existent zones

DEFaULt._BIMi.DOmaInhosTiNGpal.CoM/TXT152215.2%
*.domainhostingpal.com/A4034.0%
*.domainhostingpal.com/MX2732.7%
*.domainhostingpal.com/CNAME2662.7%
*.domainhostingpal.com/AAAA2512.5%
*.domainhostingpal.com/NS2482.5%
server13.domainhostingpal.com/A2082.1%
_adsp._domainkey.domainhostingpal.com/TXT1901.9%
server13.domainhostingpal.com/AAAA1621.6%
cpanel.domainhostingpal.com/A1501.5%
Rest:632763.3%
Total:10000100%
Reset

UDP Queries Received

CAMPUssHop.CoM.ng/A527252.7%
campusshop.com.ng/AAAA9549.5%
ns1.domainhostingpal.com/A7978.0%
ns2.domainhostingpal.com/A7827.8%
ns2.domainhostingpal.com/AAAA5405.4%
ns1.domainhostingpal.com/AAAA5395.4%
mail.domainhostingpal.com/A2322.3%
domainhostingpal.com/A1311.3%
campusshop.com.ng/NS1011.0%
domainhostingpal.com/AAAA720.7%
Rest:5805.8%
Total:10000100%
Reset

Queries that could not be answered due to backend errors

nS2.DOmAINHOstinGpAl.cOm/A1324.1%
NS1.DOmaInHOSTiNGpAL.CoM/A713.0%
ns1.domainhostingpal.com/AAAA713.0%
ns2.domainhostingpal.com/AAAA611.1%
domainhostingpal.com/MX59.3%
domainhostingpal.com/AAAA47.4%
mail.domainhostingpal.com/A47.4%
domainhostingpal.com/A35.6%
mail.domainhostingpal.com/AAAA35.6%
naijasabi.org/A11.9%
Rest:11.9%
Total:54100%
Reset

Queries for zones that we are not authoritative for

campusshop.com.ng/A802280.2%
campusshop.com.ng/AAAA182618.3%
campusshop.com.ng/NS1421.4%
cpanel.campusshop.com.ng/A50.1%
_dmarc.CaMpuSsHOP.COM.Ng/TXT40.0%
_DMARc.CaMPUsSHop.Com.ng/A10.0%
Total:10000100%

Variables

backend-queries205614Number of queries sent to the backend(s)
corrupt-packets196Number of corrupt packets received
deferred-cache-inserts3973Amount of cache inserts that were deferred because of maintenance
deferred-cache-lookup739Amount of cache lookups that were deferred because of maintenance
deferred-packetcache-inserts3123Amount of packet cache inserts that were deferred because of maintenance
deferred-packetcache-lookup464Amount of packet cache lookups that were deferred because of maintenance
dnsupdate-answers0DNS update packets successfully answered.
dnsupdate-changes0DNS update changes to records in total.
dnsupdate-queries6DNS update packets received.
dnsupdate-refused6DNS update packets that are refused.
incoming-notifications4NOTIFY packets received.
noerror-packets155278Number of times a NOERROR packet was sent out
nxdomain-packets15740Number of times an NXDOMAIN packet was sent out
overload-drops0Queries dropped because backends overloaded
packetcache-hit4020485Number of hits on the packet cache
packetcache-miss829018Number of misses on the packet cache
packetcache-size317Number of entries in the packet cache
query-cache-hit1065767Number of hits on the query cache
query-cache-miss204943Number of misses on the query cache
query-cache-size6Number of entries in the query cache
rd-queries2359Number of recursion desired questions
recursing-answers0Number of recursive answers sent out
recursing-questions0Number of questions sent to recursor
recursion-unanswered0Number of packets unanswered by configured recursor
security-status0Security status based on regular polling
servfail-packets54Number of times a server-failed packet was sent out
signatures0Number of DNSSEC signatures made
tcp-answers2551Number of answers sent out over TCP
tcp-answers-bytes166586Total size of answers sent out over TCP
tcp-queries2592Number of TCP queries received
tcp4-answers2551Number of IPv4 answers sent out over TCP
tcp4-answers-bytes166586Total size of answers sent out over TCPv4
tcp4-queries2592Number of IPv4 TCP queries received
tcp6-answers0Number of IPv6 answers sent out over TCP
tcp6-answers-bytes0Total size of answers sent out over TCPv6
tcp6-queries0Number of IPv6 TCP queries received
timedout-packets6927Number of packets which weren't answered within timeout set
udp-answers4841084Number of answers sent out over UDP
udp-answers-bytes263014468Total size of answers sent out over UDP
udp-do-queries4555227Number of UDP queries received with DO bit
udp-queries4848337Number of UDP queries received
udp4-answers4841084Number of IPv4 answers sent out over UDP
udp4-answers-bytes263014468Total size of answers sent out over UDPv4
udp4-queries4848337Number of IPv4 UDP queries received
udp6-answers0Number of IPv6 answers sent out over UDP
udp6-answers-bytes0Total size of answers sent out over UDPv6
udp6-queries0Number of IPv6 UDP queries received
unauth-packets3765320Number of times a zone we are not auth for was queried
zone-cache-hit442993Number of zone cache hits
zone-cache-miss1888486Number of zone cache misses
zone-cache-size26Number of entries in the zone cache
cpu-iowait7421937Time spent waiting for I/O to complete by the whole system, in units of USER_HZ
cpu-steal116356Stolen time, which is the time spent by the whole system in other operating systems when running in a virtualized environment, in units of USER_HZ
fd-usage22Number of open filedescriptors
key-cache-size26Number of entries in the key cache
latency795Average number of microseconds needed to answer a question
meta-cache-size26Number of entries in the metadata cache
open-tcp-connections0Number of currently open TCP connections
qsize-q0Number of questions waiting for database attention
real-memory-usage12406784Actual unique use of memory in bytes (approx)
ring-logmessages-capacity10000Maximum number of entries in the logmessages ring
ring-logmessages-size1957Number of entries in the logmessages ring
ring-noerror-queries-capacity10000Maximum number of entries in the noerror-queries ring
ring-noerror-queries-size0Number of entries in the noerror-queries ring
ring-nxdomain-queries-capacity10000Maximum number of entries in the nxdomain-queries ring
ring-nxdomain-queries-size10000Number of entries in the nxdomain-queries ring
ring-queries-capacity10000Maximum number of entries in the queries ring
ring-queries-size10000Number of entries in the queries ring
ring-remotes-capacity10000Maximum number of entries in the remotes ring
ring-remotes-corrupt-capacity10000Maximum number of entries in the remotes-corrupt ring
ring-remotes-corrupt-size196Number of entries in the remotes-corrupt ring
ring-remotes-size10000Number of entries in the remotes ring
ring-remotes-unauth-capacity10000Maximum number of entries in the remotes-unauth ring
ring-remotes-unauth-size10000Number of entries in the remotes-unauth ring
ring-servfail-queries-capacity10000Maximum number of entries in the servfail-queries ring
ring-servfail-queries-size54Number of entries in the servfail-queries ring
ring-unauth-queries-capacity10000Maximum number of entries in the unauth-queries ring
ring-unauth-queries-size10000Number of entries in the unauth-queries ring
signature-cache-size0Number of entries in the signature cache
sys-msec844898Number of msec spent in system time
udp-in-errors6800UDP 'in' errors
udp-noport-errors103089UDP 'noport' errors
udp-recvbuf-errors0UDP 'recvbuf' errors
udp-sndbuf-errors9UDP 'sndbuf' errors
uptime2394235Uptime of process in seconds
user-msec713545Number of msec spent in user time
xfr-queue0Size of the queue of zones to be XFRd