From: gerald_clark
Date: March 6 2003 2:24pm
Subject: Re: No Reply from your side!! Waiting for your reply!!!
List-Archive: http://lists.mysql.com/mysql/134111
Message-Id: <3E675A3B.7070708@suppliersystems.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>
>  
>