Problems with MySQL since upgrade

[Jim Stapleton]

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 at 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 at 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 at freebsd.org mailing list
> >> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> >> To unsubscribe, send any mail to "freebsd-questions-
> >> unsubscribe at freebsd.org"
> >>
> > _______________________________________________
> > freebsd-questions at freebsd.org mailing list
> > http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> > To unsubscribe, send any mail to "freebsd-questions-
> > unsubscribe at freebsd.org"
>
>