I did a quite test vs postgres of that query.
This instance has 40 zones and about 2.25k records.
Explain analyze reports:
QUERY PLAN
Limit (cost=105.26..105.27 rows=1 width=72) (actual time=0.542..0.542 rows=1
loops=1)
-> Sort (cost=105.26..105.46 rows=78 width=72) (actual time=0.541..0.5
Hello,
This is an update in our attempts to debug the performance issues on our
nameservers. We have found the main source of the timeouts: it was
caused by a somewhat larger zone (12699 records, 4236 unique names). The
zone was secured using DNSSEC.
Let's Encrypt certificates are automatically r
Am 24.07.2018 um 13:54 schrieb Martijn Reening:
> Hello everyone,
>
> We are seeing very vague issues with our PowerDNS setup where certain
> sequences of requests can cause full queues and dropped queries. Under
> normal circumstances, the server can handle more than 10 kqueries/sec,
> but when
> You do around 441 DNS queries/second. A single database connection
> would therefore not be able to support your needs (given DNSSEC).
We are currently running with 3 receiver-threads and 3
distributor-threads. We have tried every combination of 1, 3 and 4 of
each of these parameters without muc
On Tue, Jul 24, 2018 at 02:22:08PM +0200, Martijn Reening wrote:
> We are running PowerDNS 4.1.3 and have tested against MySQL 5.1.73 en
> PostgreSQL 10.4. It runs on CentOS 6.9, tested with both kernel versions
> `2.6.32-696.20.1.el6.x86_64` and `4.15.13-x86_64-linode106`.
Thanks!
>1.32192 mi
Hello Bert,
We are running PowerDNS 4.1.3 and have tested against MySQL 5.1.73 en
PostgreSQL 10.4. It runs on CentOS 6.9, tested with both kernel versions
`2.6.32-696.20.1.el6.x86_64` and `4.15.13-x86_64-linode106`.
Running bench-db for all domains reports:
1.32192 millisecond/lookup
Retri
On Tue, Jul 24, 2018 at 01:54:53PM +0200, Martijn Reening wrote:
> We have run out of ideas where to look and what to tune. Perhaps anyone
> here could help us further?
could you tell us what database you run, what version of PowerDNS, what the
output is of 'pdnsutil bench-db', what operating syst
