Re: table lock - which connection id own's it

On Wed, Apr 24, 2002 at 12:45:43PM +0300, Michael Widenius wrote: > > I will add to our TODO to add to SHOW OPEN TABLES a list of threads > that has locks on the table (or maybe a SHOW LOCKS command) to > better cover this case in the future. Could it be SHOW TABLE LOCKS? That way it is not con

RE: table lock - which connection id own's it

Hi! > "Lopez" == Lopez David > writes: Lopez> If no row is returned, then the following happens: Lopez> 1) lock table ... Lopez> 2) select ... Lopez> 3) if no row is returned, Lopez> 4)insert ... Lopez> 5)use LAST_INSERT_ID() to get the value of the key Lopez> 6) else

RE: table lock - which connection id own's it

Lopez David E-r9374c writes: > Monty > > BTW, it's a thrill to hear from the CTO. > > The procedure for locking a table is more complex but will > attempt to describe it further for you. Any of the 150 daemons > can insert to the hash tables. The data in the row can be used > by all 150 daemons.

RE: table lock - which connection id own's it

Monty BTW, it's a thrill to hear from the CTO. The procedure for locking a table is more complex but will attempt to describe it further for you. Any of the 150 daemons can insert to the hash tables. The data in the row can be used by all 150 daemons. The primary key in hash table is the "id" f