[rt-users] Bad query?

[Mark E. Dawson, Jr.]

> Hi,
>    Im running rt 2.0.9.   About once every 2 weeks
> the system seems to lock up.   When I do a show full
> processlist I see the query that is causing the
> problem:

I'm more interested in what else showed up in the
show full proc listing.  Was this the *only* entry,
or were there others?

I used to have a heck of a problem with MySQL's
default locking granularity (which is table-level)
with a number of different apps.  Readers and writers
blocking each other at that coarse a granularity
will kill you.

Try using InnoDB or BDB tables instead within the
database, if you in fact find this to be your issue.
Otherwise, migrate to another database like Oracle.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com