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 <[EMAIL PROTECTED]> 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- [EMAIL PROTECTED]"

_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions- [EMAIL PROTECTED]"

_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to