Re: [Pdns-users] Optimize Powerdns and Mysql for DB with 500K entries

2015-02-25 Thread Chris
Hi, 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). The only things I have done for performance are: - All tables are Inn

[Pdns-users] Optimize Powerdns and Mysql for DB with 500K entries

2015-02-25 Thread Jonathan Hunter
Hi Guys, 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 20G