queries locked in the following fashion: 1. SELECT on table OHMYGOD - "Sending data" state 2. UPDATE on the same table OHMYGOD - "Locked" state 3. SELECT on table OHMYGOD - "Locked" state
and subsequently all the other SELECT queries on OHMYGOD table were locked. Its not clear, why mysql locks other queries on OHMYGOD table when its already started "Sending data" of the SELECT sql query executed already. Assuming that there is a reason for it, could someone suggest a workaround to this problem? is there a way to kill/timeout the select query stuck with 'sending data' state? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
