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:[EMAIL PROTECTED] > 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 > > [email protected] > > http://mailman.powerdns.com/mailman/listinfo/pdns-users > > > > > _______________________________________________ > Pdns-users mailing list > [email protected] > http://mailman.powerdns.com/mailman/listinfo/pdns-users Brad Dameron Senior Systems Engineer Clearw're _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
