[Pdns-users] gmysql backend and stored procedures

Norbert Sendetzky norbert at linuxnetworks.de
Mon Aug 18 20:48:01 UTC 2008

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.

OpenPGP public key

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20080818/59d48cd3/attachment-0001.sig>

More information about the Pdns-users mailing list