Re: Need help after the upgrade

frank--- via Pdns-users <[email protected]> Thu, 27 Feb 2025 10:04:24 +0100
Newsgroups gmane.network.dns.powerdns.user
Message-ID <[email protected]>
> 
> 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

_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users