[Pdns-users] mysql vs postgresql
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?
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