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 ______________________________________________ _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
