[Pdns-users] Performance of MongoDBBackend

[fredrik danerklint]

All test performed on the same machine, which has 16GB of ram and 6 core amd 
3,2 Ghz processor. The database is on a raid5 on 6 sata disks.

The database has 16M records for the example.com zone and there is also 
another 16M zones too. 

I've also run pdnssec secure-zone example.com and it took some time to do 
that!


This is what was running at the same time:

One instance importing dns.records at minimum 7500 inserts per second (!)
One instance running pdnssec secure-zone.

Three instances of dnsperf:

One with the first 500k records from the example.com zone.
One with the last 500k records from the example.com zone.
One with the first 736 records from the example.com zone.

These test was running for 600 seconds (10 minutes).
PowerDNS had threads=6 and all the default values for the cache.

The first one:
Queries per second:   4359.149303 qps
Latency: Min: 0.000000 s; Max: 1.040222 s; Avg: 0.004588 s; StdDev: 0.011593

Second :
Queries per second:   4375.941063 qps
Latency: Min: 0.000000 s; Max: 1.040598 s; Avg: 0.004570 s; StdDev: 0.011539

And the third:
Queries per second:   35714.362440 qps
Latency: Min: 0.000000 s; Max: 1.040378 s; Avg: 0.000560 s; StdDev: 0.002787

Yes, that's right. I've even come close to 99 000 qps with only 736 records to 
test on one instance of dnsperf.

This is the same without any cache-values at all:

The first one:
Queries per second:   2429.863022 qps
Latency: Min: 0.000000 s; Max: 1.610033 s; Avg: 0.008151 s; StdDev: 0.016539

Second:
Queries per second:   2431.379185 qps
Latency: Min: 0.000586 s; Max: 2.088204 s; Avg: 0.008166 s; StdDev: 0.016887

And the third again:
Queries per second:   2424.202366 qps
Latency: Min: 0.000576 s; Max: 1.609879 s; Avg: 0.008154 s; StdDev: 0.016426

So that is at least 7 200 qps with no cache-values in PowerDNS.

Without any cache-values the qps is more or less always 11 000 if you don't 
insert anything at the same time and running only one instance of dnsperf!

-- 
//fredan