Re: [Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-28 Thread William Edwards via Pdns-users
Thomas Mieslinger via Pdns-users schreef op 2022-11-28 10:35: On 11/26/22 20:33, William Edwards wrote: Thomas Mieslinger via Pdns-users schreef op 2022-11-26 16:21: 10.6.11 is even worse than 10.6.10. I've not had any problems before 10.6.11. Are you saying that you have? Yes. Tracked here

Re: [Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-28 Thread Thomas Mieslinger via Pdns-users
On 11/26/22 20:33, William Edwards wrote: Thomas Mieslinger via Pdns-users schreef op 2022-11-26 16:21: 10.6.11 is even worse than 10.6.10. I've not had any problems before 10.6.11. Are you saying that you have? Yes. Tracked here https://jira.mariadb.org/browse/MDEV-29843 We went back to 1

Re: [Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-27 Thread William Edwards via Pdns-users
Hi Winfried, ab...@t-ipnet.net schreef op 2022-11-26 23:51: Hi, We recently had a similar problem when we updated from 10.5.12 to 10.6.10. The cause was that the default behavior changed from innodb_flush_method = fsync to innodb_flush_method = O_DIREC I've used O_DIRECT even before the u

Re: [Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-26 Thread abang--- via Pdns-users
Hi, We recently had a similar problem when we updated from 10.5.12 to 10.6.10. The cause was that the default behavior changed from innodb_flush_method = fsync to innodb_flush_method = O_DIREC Which means, no kernel file caching. If you have a too small innodb_buffer_pool_size in this ca

Re: [Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-26 Thread William Edwards via Pdns-users
Hi Thomas, Thomas Mieslinger via Pdns-users schreef op 2022-11-26 16:21: 10.6.11 is even worse than 10.6.10. I've not had any problems before 10.6.11. Are you saying that you have? We went back to 10.6.10 because System Load went to 120+... Did you debug this before downgrading? We've

Re: [Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-26 Thread Thomas Mieslinger via Pdns-users
10.6.11 is even worse than 10.6.10. We went back to 10.6.10 because System Load went to 120+... We've automated restarting MariaDB after coredump. If we could, we would go back to 10.5 Am 26.11.22 um 14:45 schrieb William Edwards via Pdns-users: Hi, Are people on this mailing list seeing incr

[Pdns-users] Increased CPU usage after upgrade to MariaDB 10.6.11

2022-11-26 Thread William Edwards via Pdns-users
Hi, Are people on this mailing list seeing increased CPU usage when using MariaDB 10.6.11 with PowerDNS 4.5.4? Context: I use PowerDNS with the gmysql backend. Last Wednesday, I upgraded MariaDB 10.6.10 to 10.6.11 on 8 machines running PowerDNS. Since then, MySQL's average CPU usage has inc