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

[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 20GB Memory.
I am seeing some slow responses in terms of using dig to perform NAPTR record lookups.
Any help would be great.
Many thanks
Jon 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20150225/a5a6725d/attachment.html>