PowerDNS 4.5.3

Uptime: 27.7 days
Queries/second, 1, 5, 10 minute averages: 1, 1, 1. Max queries/second: 57
Cache hitrate, 1, 5, 10 minute averages: 78.9%, 79.7%, 80.1%
Backend query cache hitrate, 1, 5, 10 minute averages: 68.0%, 85.3%, 86.0%
Backend query load, 1, 5, 10 minute averages: 0, 0, 0. Max queries/second: 1
Total queries: 4848564. Question/answer latency: 0.893ms


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.1372902.9%
67.215.80.1302822.8%
67.215.80.1402722.7%
67.215.80.1332622.6%
67.215.80.1352622.6%
67.215.80.1342592.6%
67.215.80.1392532.5%
67.215.80.1382512.5%
67.215.80.1312422.4%
67.215.80.1322302.3%
Rest:739774.0%
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.1334044.0%
67.215.80.1394034.0%
67.215.80.1343984.0%
67.215.80.1303933.9%
67.215.80.1353883.9%
67.215.80.1373873.9%
67.215.80.1403833.8%
67.215.80.1383793.8%
67.215.80.1313713.7%
67.215.80.1323593.6%
Rest:613561.4%
Total:10000100%
Reset

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

DOMAINhOsTINGPAL.coM/AAAA240.0%
ns1.domainhostingpal.com/AAAA120.0%
ns2.domainhostingpal.com/AAAA120.0%
mail.domainhostingpal.com/AAAA120.0%
Total:5100%
Reset

Queries for non-existent records within existent zones

DEFaULt._BIMi.DOmaInhosTiNGpal.CoM/TXT152315.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:632663.3%
Total:10000100%
Reset

UDP Queries Received

campusshop.com.ng/A2100.0%
Total:2100%
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/A803580.3%
campusshop.com.ng/AAAA182618.3%
campusshop.com.ng/NS1271.3%
cpanel.campusshop.com.ng/A50.1%
_dmarc.CaMpuSsHOP.COM.Ng/TXT40.0%
campusshop.com.ng/SOA20.0%
_DMARc.CaMPUsSHop.Com.ng/A10.0%
Total:10000100%

Variables

backend-queries205631Number of queries sent to the backend(s)
corrupt-packets196Number of corrupt packets received
deferred-cache-inserts3974Amount of cache inserts that were deferred because of maintenance
deferred-cache-lookup739Amount of cache lookups that were deferred because of maintenance
deferred-packetcache-inserts3124Amount 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-packets155283Number of times a NOERROR packet was sent out
nxdomain-packets15742Number of times an NXDOMAIN packet was sent out
overload-drops0Queries dropped because backends overloaded
packetcache-hit4020666Number of hits on the packet cache
packetcache-miss829065Number of misses on the packet cache
packetcache-size327Number of entries in the packet cache
query-cache-hit1065816Number of hits on the query cache
query-cache-miss204960Number of misses on the query cache
query-cache-size13Number 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-answers4841312Number of answers sent out over UDP
udp-answers-bytes263026400Total size of answers sent out over UDP
udp-do-queries4555444Number of UDP queries received with DO bit
udp-queries4848565Number of UDP queries received
udp4-answers4841312Number of IPv4 answers sent out over UDP
udp4-answers-bytes263026400Total size of answers sent out over UDPv4
udp4-queries4848565Number 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-packets3765506Number of times a zone we are not auth for was queried
zone-cache-hit443015Number of zone cache hits
zone-cache-miss1888605Number of zone cache misses
zone-cache-size26Number of entries in the zone cache
cpu-iowait7424734Time spent waiting for I/O to complete by the whole system, in units of USER_HZ
cpu-steal116363Stolen 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
latency892Average 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-usage10932224Actual 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-size5Number 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-size2Number 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-msec844990Number of msec spent in system time
udp-in-errors6800UDP 'in' errors
udp-noport-errors103097UDP 'noport' errors
udp-recvbuf-errors0UDP 'recvbuf' errors
udp-sndbuf-errors9UDP 'sndbuf' errors
uptime2394428Uptime of process in seconds
user-msec713599Number of msec spent in user time
xfr-queue0Size of the queue of zones to be XFRd