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