Make sure you have an index on billingstatus.
Murugavel wrote:
>Dear Mr. Venu & Tech Group,
>
>
>We are facing few problem in mysql database.
>
>
>Take an eg.
>
>we have table called bb_usersession0
>
>user A is trying to delete a record which is having the billingstatus B .
>
>User A
>
>delete from bb_usersession0 where ui_sessionid='cs_venkatesh0006A46C' AND
>us_billingstaus='B'
>User B
>update bb_usersession0 set us_billingstatus='Y' where us_billingstatus='N';
>
>In the above case mYSQL IS LOCKING THE whole table so the USER B is not
>able to update the status.In user session B we are getting the followin message
>ERROR 1205: Lock wait timeout exceeded; Try restarting transaction
>
>Kindly give me solution for the above problem.
>
>Awaiting your reply
>
>Regards
>velu
>
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread134086@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
