[Pdns-users] Need help after the upgrade

[frank at kiwazo.be]

> 
> Forgot to mention: it also might be your DB schema is missing an
> index, making the zone cache query slow.


Posting the result of the following db query might help:

explain select domains.id <http://domains.id/>, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id <http://domains.id/> AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250227/0bcde078/attachment.htm>