List:General Discussion« Previous MessageNext Message »
From:Ian Sales (DBA) Date:October 5 2005 2:34pm
Subject:Re: innodb locking
View as plain text  
Tony Leake wrote:

>Hi, 
>
>I have a query:
>
>UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid =
>100000798
>
>intOrderUid is the primary key
>
>There are 25 columns in the table and a further 8 of these have indexes
>on them. The table is innodb
>
>I have just tried to run the above query 3 times and i got the follwing
>error
>
>Invalid Query Lock wait timeout exceeded; try restarting transaction
>
>  
>
- try using SHOW INNODB STATUS. That will give you more info on table locks.

- ian

-- 
+-------------------------------------------------------------------+
| Ian Sales                                  Database Administrator |
|                                                                   |
|                              "All your database are belong to us" |
| ebuyer                                      http://www.ebuyer.com |
+-------------------------------------------------------------------+

Thread
innodb lockingTony Leake5 Oct
  • Re: innodb lockingAdy Wicaksono5 Oct
  • Re: innodb lockingDBA)5 Oct
RE: innodb lockingSujay Koduri5 Oct
  • RE: innodb lockingTony Leake5 Oct
RE: innodb lockingSujay Koduri5 Oct