Re: Slow performance with MySQL driver on gentoo

Hi Rob

Thanks for the response. After a battle with the Gentoo ebuild for
bind (see http://bugs.gentoo.org/show_bug.cgi?id=180720) I managed to
get 9.5.1-P1 compiled against MySQL 4.22.1 and it seems stable. I
killed the session several times on the MySQL 5 server and named
reconnected as expected.

Thanks for the guidance. I'll make sure the fact gets well publicized
and the ebuilds updated.

Cheers

On 7/24/08, Rob Butler <[email protected]> wrote:
> 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
>
>
>


-- 
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=/