-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Peter,
On 6/4/2010 3:50 AM, Peter Crowther wrote:
> On 4 June 2010 06:08, suchismitasuchi <suchismitasuchi@rediffmail.com> wrote:
>>
>> Thanks a lot.
>> What will be the workaround for this?
>
> Having said all of that, my guess is that either a) you're overloading
> your MySQL database with queries or b) you have code that causes a
> deadlock somewhere in the database. In either case, I suggest
> monitoring MySQL. If it's very busy, it's probably overloaded; if
> it's very quiet, you probably have a deadlock.
MySQL is pretty good at detecting deadlock and canceling queries to
allow one (or more) continue. They could just be queries that take
forever to run. "SELECT * FROM huge_table JOIN huge_table" is one sure
way to lock-up a query.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkwJM/kACgkQ9CaO5/Lv0PBXYgCgwWKJpiKg/zBxK2lHQwOLtKYc
n4UAoKqY6oC2/P4AE87gml3YaBLCkS1W
=iPtG
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
|