<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
I have 3 PowerDNS instances running with the MySQL backend across 4
DNS servers. The largest has 1,883,763 domains with 9,736,133
records (With all instances combined there is a total of 21M rows in
the records table).<br>
<br>
The only things I have done for performance are:<br>
<br>
- All tables are InnoDB<br>
- All DNS servers have 16GB or more of memory, InnoDB buffer pool
size is at least 10GB on each<br>
- MySQL 5.6 (actually running Percona, upgrading from 5.5 to 5.6
gave me a slight performance increase)<br>
- InnoDB file format is barracuda, tables are compressed with 4KB
page size<br>
<br>
With table compression my largest instance uses a total of 750mb on
disk.<br>
<br>
The minimum specs for my DNS servers are:<br>
<br>
- 2 x E5-2620 CPU (6 cores + hyperthreading each)<br>
- 16GB of RAM<br>
- 2 x 15K SAS in RAID 1<br>
<br>
With the 3 power DNS instances + unbound instance for caching name
server the load average on the servers is less than 1, there is no
IO wait. Each DNS server is handling an average of 6,714 queries per
second across the 3 PowerDNS instances and Unbound.<br>
<br>
Using dnsscope for my biggest instance I can see that I get these
stats:<br>
<br>
0.01% of questions answered within 50 usec (0.01%)<br>
51.67% of questions answered within 100 usec (51.67%)<br>
60.11% of questions answered within 200 usec (8.44%)<br>
60.40% of questions answered within 300 usec (0.29%)<br>
60.70% of questions answered within 400 usec (0.30%)<br>
63.85% of questions answered within 800 usec (3.14%)<br>
67.78% of questions answered within 1000 usec (3.93%)<br>
97.93% of questions answered within 2.00 msec (30.15%)<br>
99.71% of questions answered within 4.00 msec (1.78%)<br>
99.97% of questions answered within 8.00 msec (0.26%)<br>
100.00% of questions answered within 32.00 msec (0.03%)<br>
100.00% of questions answered within 64.00 msec (0.00%)<br>
0 responses (0.00%) older than 2 seconds<br>
Average non-late response time: 569.60 usec<br>
<br>
What kind of statistics are you seeing? Do you get large amounts of
I/O wait on the server? Is your mysql innodb buffer pool size large
enough to hold the entire table in RAM?<br>
<br>
Chris<br>
<br>
<div class="moz-cite-prefix">On 26/02/2015 2:40 AM, Jonathan Hunter
wrote:<br>
</div>
<blockquote cite="mid:DUB127-W9054BA6689839C38115D3EBD170@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr">Hi Guys,
<div><br>
</div>
<div>I appreciate there are optimization tips on the website,
however I wondered if there are any specific tips for
optimization when dealing with a records table or associated
view of 500K rows in a Mysql backend database on a Virtual
Centos Machine with 2 x 3Ghz processors, 1GB RAM and 20GB
Memory.</div>
<div><br>
</div>
<div>I am seeing some slow responses in terms of using dig to
perform NAPTR record lookups.</div>
<div><br>
</div>
<div>Any help would be great.</div>
<div><br>
</div>
<div>Many thanks</div>
<div><br>
</div>
<div>Jon</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Pdns-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a>
<a class="moz-txt-link-freetext" href="http://mailman.powerdns.com/mailman/listinfo/pdns-users">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
</blockquote>
<br>
</body>
</html>