Re: [Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread Matthias Cramer via Pdns-users 

Hi Lucas

Downgraded all systems to mariadb 10.5.17 and problem seams to be gone...

Regards

  Matthias

On 30/12/2022 20:25, Lucas Rolff wrote:

It is MariaDB related: https://jira.mariadb.org/browse/MDEV-29988

On 30 Dec 2022, at 20:05, Matthias Cramer via Pdns-users 
 wrote:


Hi

We have similar high CPU issues in MariaDB since a few days. We 
upgraded to PDNS 4.7.3 and MariaDB 10.5.18 on Debian 11.


We have 5 similar systems with Database Replication in between and 
all show the same issue.


As soon as we restart either mariadb or pdns the load drops for some 
time.


We suspect that it is mariadb related and not pdns, but not shure.

We have not seen any unusual queries until now.

Regards

  Matthias

On 30/12/2022 12:42, Giorgio Lardone via Pdns-users wrote:

Dear William,
my MariaDB version is 10.5.18

Giorgio
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

--
Matthias Cramer / mc322-ripe   Senior Network & Security Engineer
iway AGPhone +41 43 500 
Badenerstrasse 569 Fax   +41 44 271 3535
CH-8048 Zurichhttp://www.iway.ch/
GnuPG 1024D/2D208250 = DBC6 65B6 7083 1029 781E  3959 B62F DF1C 2D20 8250
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users



--
Matthias Cramer / mc322-ripe   Senior Network & Security Engineer
iway AGPhone +41 43 500 
Badenerstrasse 569 Fax   +41 44 271 3535
CH-8048 Zurichhttp://www.iway.ch/
GnuPG 1024D/2D208250 = DBC6 65B6 7083 1029 781E  3959 B62F DF1C 2D20 8250
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Re: [Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread Lucas Rolff via Pdns-users 
It is MariaDB related: https://jira.mariadb.org/browse/MDEV-29988

On 30 Dec 2022, at 20:05, Matthias Cramer via Pdns-users 
mailto:pdns-users@mailman.powerdns.com>> wrote:


Hi

We have similar high CPU issues in MariaDB since a few days. We upgraded to 
PDNS 4.7.3 and MariaDB 10.5.18 on Debian 11.

We have 5 similar systems with Database Replication in between and all show the 
same issue.

As soon as we restart either mariadb or pdns the load drops for some time.

We suspect that it is mariadb related and not pdns, but not shure.

We have not seen any unusual queries until now.

Regards

  Matthias

On 30/12/2022 12:42, Giorgio Lardone via Pdns-users wrote:

Dear William,
my MariaDB version is 10.5.18

Giorgio
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users


--
Matthias Cramer / mc322-ripe   Senior Network & Security Engineer
iway AGPhone +41 43 500 
Badenerstrasse 569 Fax   +41 44 271 3535
CH-8048 Zurich http://www.iway.ch/
GnuPG 1024D/2D208250 = DBC6 65B6 7083 1029 781E  3959 B62F DF1C 2D20 8250


___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Re: [Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread Matthias Cramer via Pdns-users 

Hi

We have similar high CPU issues in MariaDB since a few days. We upgraded 
to PDNS 4.7.3 and MariaDB 10.5.18 on Debian 11.


We have 5 similar systems with Database Replication in between and all 
show the same issue.


As soon as we restart either mariadb or pdns the load drops for some time.

We suspect that it is mariadb related and not pdns, but not shure.

We have not seen any unusual queries until now.

Regards

  Matthias

On 30/12/2022 12:42, Giorgio Lardone via Pdns-users wrote:

Dear William,
my MariaDB version is 10.5.18

Giorgio
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users


--
Matthias Cramer / mc322-ripe   Senior Network & Security Engineer
iway AGPhone +41 43 500 
Badenerstrasse 569 Fax   +41 44 271 3535
CH-8048 Zurichhttp://www.iway.ch/
GnuPG 1024D/2D208250 = DBC6 65B6 7083 1029 781E  3959 B62F DF1C 2D20 8250
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Re: [Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread William Edwards via Pdns-users 

> Op 30 dec. 2022 om 12:42 heeft Giorgio Lardone  
> het volgende geschreven:
> 
> Dear William,
> my MariaDB version is 10.5.18

That version might also contain the regression I posted about. 10.5 is marked 
as one of the ‘fix versions’ in MDEV-29988.

> 
> Giorgio

___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Re: [Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread Giorgio Lardone via Pdns-users 
Dear William,
my MariaDB version is 10.5.18

Giorgio
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Re: [Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread William Edwards via Pdns-users 

> Op 30 dec. 2022 om 11:55 heeft Giorgio Lardone via Pdns-users 
>  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@mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
> 

___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

[Pdns-users] PowerDNS problems with MySQL

2022-12-30 Thread Giorgio Lardone via Pdns-users 
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.
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@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users