Date: Thu, 3 Aug 2006 21:36:09 +0200 From: usleepless@gmail.com To: "Richard Morse" <remorse@partners.org> Cc: freebsd-questions@freebsd.org Subject: Re: Problems with MySQL since upgrade Message-ID: <c39ec84c0608031236y5edd061bh97634e80c1b0e2f2@mail.gmail.com> In-Reply-To: <1E8F77CE-AC74-4C24-89DC-89201CD4E113@partners.org> References: <31F1465C-5B87-4B79-8D58-0A538BF30562@partners.org> <D1FBD2B5-CEB6-479B-8254-497E199462CF@partners.org> <80f4f2b20608020636o3dd712c9vf1aad9b6f3ba6e6f@mail.gmail.com> <B4660167-78AB-4A4D-AF7C-9AD258185E7C@partners.org> <80f4f2b20608020700l53410a09u6efb90aadb6294cb@mail.gmail.com> <1E8F77CE-AC74-4C24-89DC-89201CD4E113@partners.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Dear Ricky, On 8/2/06, Richard Morse <remorse@partners.org> wrote: > No, they were all normal (the latter two were 0, the first was about > 110). FWIW, the query usually proceeds normally; it's only when it > doesn't that things go bad. > > I'm wondering if this is a problem with threads -- I've been doing > research, and a number of places say that there are threading issues > on FreeBSD 5 with MySQL thread when using the standard threading > library. I'm going to recompile MySQL with the linuxpthreads option, > and see if that stops this... i understand if this is of no use to you, but: switch to PostgreSQL as soon as you can. MySQL has given me nothing but trouble, especially on FBSD ( threads ). PGSQL is more complete, and faster on harder queries. regards, usleep
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c39ec84c0608031236y5edd061bh97634e80c1b0e2f2>