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

[William Edwards]

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 https://jira.mariadb.org/browse/MDEV-29843
> 
>>> We went back to 10.6.10 because System Load went to 120+...
>> 
>> Did you debug this before downgrading?
> 
> No way. Opened https://jira.mariadb.org/browse/MDEV-29988

Thanks for the URL. I'm watching the issue.

> 
>>> We've
>>> automated restarting MariaDB after coredump.
>>> 
>> Are you saying that MariaDB is crashing for some reason? Or do you 
>> mean
>> it's terminated because of a lack of system resources?
> 
> With 48 cores and 512GB RAM there is no lack of system resources...

Depends on what you run ;)

> All
> instances together take "only" ~200GB RAM.
> 
> We run ~400 MariaDB slave instance. ~3 die per week.
> 
>>> If we could, we would go back to 10.5
>> 
>> You could, of course, dump your database and import it into a clean
>> 10.5.x instance.
> 
> Nope. First we have to convince the DBA Team who run the master
> instances we replicate to go back. Postponed until end Jan '23.
> 
> Lets see.
> 
> Cheers
> 
> Thomas
> 
>>> 
>>> Am 26.11.22 um 14:45 schrieb 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 increased from 2,5% to 55%. This 
>>>> happens
>>>> on all upgraded machines. However, this issue does not occur on 
>>>> machines
>>>> running MariaDB 10.6.11 without PowerDNS. PowerDNS itself was not
>>>> upgraded.
>>>> 
>>>> I am aware that this issue is (most likely) not caused by PowerDNS. 
>>>> I am
>>>> therefore only wondering whether others have seen the same 
>>>> behaviour. If
>>>> so, that would save me some debugging time.
>>>> 
>>>> Thank you,
>>>> 
>>>> William Edwards
>>>> 
>>>> _______________________________________________
>>>> Pdns-users mailing list
>>>> Pdns-users at mailman.powerdns.com
>>>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>>> _______________________________________________
>>> Pdns-users mailing list
>>> Pdns-users at mailman.powerdns.com
>>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>> 
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users

-- 
With kind regards,

William Edwards