Re: Slow performance with MySQL driver on gentoo
Rob Butler <[email protected]>
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
DLZ has known issues with the MySQL 5 client. Try using the MySQL 4 client. Rob ----- Original Message ---- From: Kenneth Kalmer <[email protected]> To: [email protected] Sent: Thursday, July 24, 2008 11:54:43 AM Subject: [Bind-dlz-testers] Slow performance with MySQL driver on gentoo Hi all This is my first post to the list, apologies if I step on any toes or break any rules. As part of our BIND DLZ on Rails project (http://www.opensourcery.co.za/bind-dlz-on-rails/), I've been spending the last day or so pulling my hair out getting BIND to reliably use the MySQL driver for zone lookups on several Gentoo boxes. named starts up fine and answers queries successfully. But after some time it stops responding to queries for specific clients. I get timeouts with dig, but the query log shows a lot of activity. After a while longer, its stops responding totally. The process is up and running, but it won't shutdown cleanly (you need to kill -9). I've exhausted my resources and don't know how to go about debugging the issue. Below is some technical information about the installations (all the same). OS: Gentoo uname -a: Linux dns-5.za.XXXX 2.6.20-hardened-r2 #2 SMP Tue Jun 12 17:46:09 SAST 2007 i686 Intel(R) Pentium(R) 4 CPU 2.80GHz GenuineIntel GNU/Linux BIND Version (portage): net-dns/bind-9.5.0_p1-r1 [dlz mysql] MySQL Version (portage): dev-db/mysql-5.0.54 Zones: ~4,000 Records: ~60,000 Thanks in advance Kind regards -- Kenneth Kalmer [email protected] http://opensourcery.co.za ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bind-dlz-testers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers