Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 2 Aug 2006 10:20:32 -0400
From:      Richard Morse <remorse@partners.org>
To:        Jim Stapleton <stapleton.41@gmail.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Problems with MySQL since upgrade
Message-ID:  <1E8F77CE-AC74-4C24-89DC-89201CD4E113@partners.org>
In-Reply-To: <80f4f2b20608020700l53410a09u6efb90aadb6294cb@mail.gmail.com>
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>

next in thread | previous in thread | raw e-mail | index | archive | help
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...

Thanks,
Ricky

On Aug 2, 2006, at 10:00 AM, Jim Stapleton wrote:

> I thought there were mysql forums, but I am not sure.
>
> In the queries I gave you, none of the results were too large I take
> it (not above the low thousands)?
>
> -Jim Stapleton
>
> On 8/2/06, Richard Morse <remorse@partners.org> wrote:
>> Hi!  All of these queries worked just fine, without causing any
>> problems.
>>
>> As this is more of a mysql issue, do you have any suggestions where
>> it would be best for me to query them?
>>
>> Thanks,
>> Ricky
>>
>> On Aug 2, 2006, at 9:36 AM, Jim Stapleton wrote:
>>
>> > Not sure, seems more of a mysql question, but here's some guesses I
>> > have for diagnostics.
>> >
>> > could you run these queries?
>> >
>> > SELECT COUNT(*) FROM users WHERE status < 3
>> > SELECT COUNT(*) FROM sessiions WHERE sid =
>> > "d9fe25949f79f2c767a0d237b4fdf841"
>> > SELECT COUNT(*) FROM FROM users u INNER JOIN sessions s ON u.uid =
>> > s.uid WHERE s.sid = "d9fe25949f79f2c767a0d237b4fdf841" AND  
>> u.status <
>> > 3
>> >
>> > -Jim Stapleton
>> >
>> >
>> >
>> > On 8/2/06, Richard Morse <remorse@partners.org> wrote:
>> >>
>> >> On Aug 1, 2006, at 9:24 AM, Richard Morse wrote:
>> >>
>> >> > Hi!  I recently updated MySQL to version 5.0.22 using the ports
>> >> > system (portupgrade -r -R mysql-\*).  Previous to this, MySQL  
>> was
>> >> > behaving perfectly normally.  Since the upgrade, I have found  
>> that
>> >> > every so often -- sometimes two or three times a day, sometimes
>> >> > every other day, but no more often than that -- one of the
>> >> > databases MySQL is hosting starts misbehaving, MySQL starts
>> >> > climbing in processor usage, and I have to restart MySQL to
>> >> > recover.  By "misbehaving", I mean that some subset of  
>> queries to
>> >> > this database start not returning -- they take forever.  By
>> >> > climbing in processor usage, I mean that my load averages, which
>> >> > normally sit around 0, start going up to 3, 5, even 7.
>> >> >
>> >> > - How can I determine what query it is that is causing this to
>> >> > happen?  I have turned on the log files by adding the following
>> >> > line to /etc/rc.conf:
>> >>
>> >> Hi!  Since this time, I have, I think, found what query is causing
>> >> the problem:
>> >>
>> >> SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid =  
>> s.uid
>> >> WHERE s.sid = "d9fe25949f79f2c767a0d237b4fdf841" AND u.status < 3
>> >> LIMIT 0, 1
>> >>
>> >> How can I determine _why_ this is causing MySQL to hang/enter some
>> >> kind of infinite loop?
>> >>
>> >> Thanks,
>> >> Ricky
>> >> _______________________________________________
>> >> freebsd-questions@freebsd.org mailing list
>> >> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>> >> To unsubscribe, send any mail to "freebsd-questions-
>> >> unsubscribe@freebsd.org"
>> >>
>> > _______________________________________________
>> > freebsd-questions@freebsd.org mailing list
>> > http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>> > To unsubscribe, send any mail to "freebsd-questions-
>> > unsubscribe@freebsd.org"
>>
>>
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions- 
> unsubscribe@freebsd.org"




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1E8F77CE-AC74-4C24-89DC-89201CD4E113>