Are you running the queries in parallel or serially? Are you using the same connection? Are you issuing Low Priority Updates?
-----Original Message----- From: Sahil Aggarwal To: [EMAIL PROTECTED] Sent: 4/16/04 8:27 AM Subject: row locking hi all, i have select statements in my java code which are followed by updates in my Innodb table. the desired behaviour shud have been check and then update but because of tomcat accepting connections the above becomes check check update update i dont want to set the table locking, as it will make the system slower how can i set exclusive row locking until the update is finished? Any pointers are appreciated. -Regards Sahil Aggarwal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
