[Pdns-users] PowerDNS problems with MySQL

[William Edwards]

> Op 30 dec. 2022 om 11:55 heeft Giorgio Lardone via Pdns-users <pdns-users at mailman.powerdns.com> het volgende geschreven:
> 
> Hello!
> 
> I have several powerdns servers installed, but only one is behaving 
> strangely.
> 
> The operating system is Debian 11 with the latest stable version of 
> PowerDNS installed (4.7.3) and MySQL (MariaDB) backends.

Are you running MariaDB 10.6.11? If so, see my mailing list post from earlier.

> The server has 2 CPU Cores and 4 GB RAM.
> 
> I see that when the DNS request load increases the server CPU goes to 
> 100% for the mysql and it remains so even for a few hours, without an 
> apparent reason, since the DNS requests are very low (at most 500 
> requests per second) and in any case the CPU usage never drops below 
> 50/60%.
> 
> I also tried to connect the server to an external database, but PowerDNS 
> doesn't connect and it's not a permission or network problem, because 
> trying a mysql connection from the terminal everything works perfectly.
> I also tried installing another parallel test server (same datacenter, 
> same network) and the external database connection works fine.
> 
> Do you have any idea why it behaves like this?
> 
> Thank you!
> 
> Regards,
> 
> Giorgio
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>