-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peter,
On 6/4/2010 3:50 AM, Peter Crowther wrote: > On 4 June 2010 06:08, suchismitasuchi <suchismitasu...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
