Hi Max > I'm trying to integrate powerdns with our legacy mysql database here. I > have to create a union of three tables to get something that powerdns > will use. This takes about 0.4 seconds per query, and hammers the cpu. > due to needing to use the %s replacements in the config file in multiple > places in a more optimised version of my queries I've had to use stored > procedures that take 0.14 seconds to run (still not good enough, but > getting better). The problem is I can run the query just fine by hand, > but powerdns times out with the valid entry below, and gives and error > for anything that should go to the recursor?
The gmysql backend doesn't support stored procedures. If you use the OpenDBX backend with the mysql driver instead, your queries will work. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
