[Pdns-users] Any cure for powerdns respawning ?

[Brad Dameron]

I forgot that PowerDNS actually uses InnoDB tables which uses different
memory settings. Check this over for some good settings:

http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/



On Fri, 2008-06-06 at 12:36 -0700, Eugene Pefti wrote:
> I remember I set it to 200 while fine-tuning mysql server. Just thinking
> that having the default value doubled be sufficient.
> These are the other settings that I upped:
> key_buffer_size=32M
> 
> max_allowed_packet=8M
> 
> Eugene
> 
> -----Original Message-----
> From: Curtis Maurand [mailto:curtis at maurand.com] 
> Sent: Friday, June 06, 2008 11:40 AM
> To: Eugene Pefti
> Subject: Re: [Pdns-users] Any cure for powerdns respawning ?
> 
> Check your max connections in my.cnf
> 
> Curtis
> 
> Eugene Pefti wrote:
> > Good morning or day, guys.
> > Is there any explanation or a configuration cure to minimize errors like
> > this:
> >
> > Jun  6 08:32:27 ns2 pdns[23831]: 50044 questions waiting for database
> > attention. Limit is 50000, respawning                         
> > Jun  6 08:32:27 ns2 pdns[14696]: Our pdns instance exited with code 1
> >
> > Jun  6 08:32:27 ns2 pdns[14696]: Respawning
> >
> > I kept increasing the value of max-queue-length but it seems the number of
> > questions keep building up and eventually leads to the above-said
> situation.
> > Are there any settings that I should look at in the MySQL. I run gmysql
> > backend.
> >
> > Eugene
> >
> > _______________________________________________
> > Pdns-users mailing list
> > Pdns-users at mailman.powerdns.com
> > http://mailman.powerdns.com/mailman/listinfo/pdns-users
> >   
> 
> 
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users

Brad Dameron
Senior Systems Engineer
Clearw're