[Pdns-users] mysql vs postgresql

[Adam Cassar]

Hi,

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:

effective_cache_size
shared_buffers

The following Mysql settings where changed:

key_buffer
query_cache_*

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
______________________________________________
http://www.netregistry.com.au
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
______________________________________________