Re: [Pdns-users] PowerDNS authoritative server random timeouts

2019-10-02 Thread Netsons - Federico Chiacchiaretta
Hi Klaus, I excluded network issues for a while, so I focused my analysis on MySQL. Simply running a 'show processlist' during one of the random timeouts brought me to the solution: I found a lot of queries in state 'Waiting for query cache lock', so I completely disabled query_cache in MySQL conf

Re: [Pdns-users] PowerDNS authoritative server random timeouts

2019-09-25 Thread Klaus Darilion
I think, first you should find out if there is a problem with PowerDNS or the network - or inbetween. If this happens regularly, just use tcpdump to caputre all DNS traffic to a file (rotate files, keep only X files and choose X to not fill your complete hard disk). Or even simpler - just ca

[Pdns-users] PowerDNS authoritative server random timeouts

2019-09-17 Thread Netsons - Federico Chiacchiaretta
Hi, we have a PowerDNS cluster of authoritative servers running on 4 nodes: OS: CentOS 7.6.1810 (fully updated) Version: pdns-4.1.13-1pdns.el7.x86_64 Backend: mysql - MariaDB-server-10.1.41-1.el7.centos.x86_64 Backend is configured with 1 master and 3 slaves. We perform recurring checks (every 3