PowerDNS 4.5.3

Uptime: 27.5 days
Queries/second, 1, 5, 10 minute averages: 1, 1, 1. Max queries/second: 57
Cache hitrate, 1, 5, 10 minute averages: 78.5%, 82.4%, 82.0%
Backend query cache hitrate, 1, 5, 10 minute averages: 75.2%, 75.6%, 79.4%
Backend query load, 1, 5, 10 minute averages: 0, 0, 0. Max queries/second: 1
Total queries: 4821177. Question/answer latency: 0.543ms


Reset

Log Messages

Not validating response for security status update, this is a non-release version131767.7%
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:46924.1%
Total:1946100%
Reset

Remote server IP addresses

67.215.80.1403173.2%
67.215.80.1333133.1%
67.215.80.1323063.1%
67.215.80.1343003.0%
67.215.80.1392922.9%
67.215.80.1372832.8%
67.215.80.1362832.8%
67.215.80.1382752.8%
67.215.80.1352742.7%
67.215.80.1302652.6%
Rest:709270.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.1405125.1%
67.215.80.1364794.8%
67.215.80.1384744.7%
67.215.80.1304734.7%
67.215.80.1344694.7%
67.215.80.1334604.6%
67.215.80.1324564.6%
67.215.80.1374534.5%
67.215.80.1394474.5%
67.215.80.1354404.4%
Rest:533753.4%
Total:10000100%
Reset

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

ns2.domainhostingpal.com/AAAA240324.0%
ns1.domainhostingpal.com/AAAA239023.9%
domainhostingpal.com/AAAA206120.6%
mail.domainhostingpal.com/AAAA114711.5%
domainhostingpal.com/DNSKEY6977.0%
naijasabi.org/AAAA1731.7%
naijasabi.org/DNSKEY890.9%
_dmarc.domainhostingpal.com/A860.9%
BOa-aPi.NAiJasabI.ORg/AAAA690.7%
domainhostingpal.com/CNAME470.5%
Rest:8388.4%
Total:10000100%
Reset

Queries for non-existent records within existent zones

DefauLt._biMI.DoMAinHOsTiNgpAL.coM/TXT150215.0%
*.domainhostingpal.com/A4044.0%
*.domainhostingpal.com/MX2702.7%
*.domainhostingpal.com/CNAME2652.6%
*.domainhostingpal.com/AAAA2522.5%
*.domainhostingpal.com/NS2482.5%
server13.domainhostingpal.com/A1982.0%
_adsp._domainkey.domainhostingpal.com/TXT1871.9%
server13.domainhostingpal.com/AAAA1621.6%
CPAnEl.DOmAInhosTINGpAl.cOM/A1521.5%
Rest:636063.6%
Total:10000100%
Reset

UDP Queries Received

campusshop.com.ng/A592759.3%
campusshop.com.ng/AAAA8318.3%
ns1.domainhostingpal.com/A6816.8%
ns2.domainhostingpal.com/A6676.7%
ns2.domainhostingpal.com/AAAA4734.7%
ns1.domainhostingpal.com/AAAA4714.7%
mail.domainhostingpal.com/A2592.6%
domainhostingpal.com/A971.0%
domainhostingpal.com/DNSKEY910.9%
domainhostingpal.com/AAAA700.7%
Rest:4334.3%
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/A910991.1%
campusshop.com.ng/AAAA8398.4%
sfdfsDSfdsffsD.CAMPusshOP.COM.ng/A180.2%
SFdFSdsFDSffsd.CampUSShOP.cOm.Ng/AAAA150.1%
camPusSHoP.coM.Ng/NS120.1%
www.campusshop.com.ng/A50.1%
campusshop.com.ng/SOA10.0%
www.google.com/A10.0%
Total:10000100%

Variables

backend-queries204100Number of queries sent to the backend(s)
corrupt-packets196Number of corrupt packets received
deferred-cache-inserts3961Amount of cache inserts that were deferred because of maintenance
deferred-cache-lookup735Amount of cache lookups that were deferred because of maintenance
deferred-packetcache-inserts3101Amount of packet cache inserts that were deferred because of maintenance
deferred-packetcache-lookup457Amount 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-packets154157Number of times a NOERROR packet was sent out
nxdomain-packets15576Number of times an NXDOMAIN packet was sent out
overload-drops0Queries dropped because backends overloaded
packetcache-hit3998957Number of hits on the packet cache
packetcache-miss823395Number of misses on the packet cache
packetcache-size247Number of entries in the packet cache
query-cache-hit1057365Number of hits on the query cache
query-cache-miss203433Number of misses on the query cache
query-cache-size38Number of entries in the query cache
rd-queries2345Number 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-answers2535Number of answers sent out over TCP
tcp-answers-bytes165827Total size of answers sent out over TCP
tcp-queries2576Number of TCP queries received
tcp4-answers2535Number of IPv4 answers sent out over TCP
tcp4-answers-bytes165827Total size of answers sent out over TCPv4
tcp4-queries2576Number 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-answers4813936Number of answers sent out over UDP
udp-answers-bytes261411964Total size of answers sent out over UDP
udp-do-queries4529805Number of UDP queries received with DO bit
udp-queries4821177Number of UDP queries received
udp4-answers4813936Number of IPv4 answers sent out over UDP
udp4-answers-bytes261411964Total size of answers sent out over UDPv4
udp4-queries4821177Number 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-packets3747556Number of times a zone we are not auth for was queried
zone-cache-hit439581Number of zone cache hits
zone-cache-miss1876738Number of zone cache misses
zone-cache-size26Number of entries in the zone cache
cpu-iowait7345901Time spent waiting for I/O to complete by the whole system, in units of USER_HZ
cpu-steal115510Stolen 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
latency543Average 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-usage12591104Actual unique use of memory in bytes (approx)
ring-logmessages-capacity10000Maximum number of entries in the logmessages ring
ring-logmessages-size1946Number of entries in the logmessages ring
ring-noerror-queries-capacity10000Maximum number of entries in the noerror-queries ring
ring-noerror-queries-size10000Number 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-msec839999Number of msec spent in system time
udp-in-errors6800UDP 'in' errors
udp-noport-errors102502UDP 'noport' errors
udp-recvbuf-errors0UDP 'recvbuf' errors
udp-sndbuf-errors8UDP 'sndbuf' errors
uptime2377865Uptime of process in seconds
user-msec708919Number of msec spent in user time
xfr-queue0Size of the queue of zones to be XFRd