[Pdns-users] mysql vs postgresql

[Norbert Sendetzky]

Hi Adam

> On a same of 100K zones and using the queryperf tool available with bind
> (selecting each record from each zone) over a 10 minute run, both
> untuned postgresql and mysql was able to handle around 2000 qps.
>
> After tuning both Postgresql and Mysql, I was able to reach 2500 qps on
> Postgresql however mysql stayed at 2000 qps.

Could you give me more information about your setup? Which distribution and 
with versions of PowerDNS and the databases do you use? Which PowerDNS 
backends were used to connect to the databases and what were the 
optimizations you've done?

Thanks


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20070205/02f7d69f/attachment-0001.sig>