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
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 the bug is triggered, performance drops to 300-400 queries/se
