>
> 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
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
