[Pdns-users] mysql vs postgresql

Adam Cassar adam.cassar at netregistry.com.au
Mon Feb 5 22:33:27 UTC 2007


We tested this on Debian 'testing'. Pdns version is 2.9.20. In testing I
used the gmysql and gpgsql backends.

Postgresql is version 8.1 and Mysql version 5.0.32

The following Postgresql settings where changed:


The following Mysql settings where changed:


Granted we could have spent more time tuning the various components but
we where satisfied with results.

On Mon, 2007-02-05 at 09:42 +0100, Norbert Sendetzky wrote:
> 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
Adam Cassar
ICT Manager
NetRegistry Pty Ltd
Tel:  02 9699 6099          Fax:  02 9699 6088
PO Box 270    Broadway      NSW   2007

Domains |Business Email|Web Hosting|E-Commerce
Trusted  by  10,000s of  businesses since 1997

More information about the Pdns-users mailing list