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
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
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.
ks!
David
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 12:59 AM
To: Lopez David E-r9374c
Cc: Mysql List (E-mail)
Subject: table lock - which connection id own's it
Hi!
>>>>> "Lopez" == Lopez David > writ
* Shaun Bramley
> Depending on how many people are updating this db should ultimately
> determine your decision to remove the table locks. If hte db is only
> experiencing one person updating it then it is not necessary. However if
> multiple people are updating it, then you will want to keep th
-
From: "Luciano Barcaro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 9:49 AM
Subject: Re: Further Question with --> table lock - which connection id
own's it
*** REPLY SEPARATOR ***
>Hi ...
>
>just wante
*** REPLY SEPARATOR ***
>Hi ...
>
>just wanted to added another question to this one...
>
>you suggested to use LAST_INSERT_ID() , but the
>question is if there are concurrent access to the
>database, how will you get the last id without locking
>the table.
Don't worry about c
Hi ...
just wanted to added another question to this one...
you suggested to use LAST_INSERT_ID() , but the
question is if there are concurrent access to the
database, how will you get the last id without locking
the table.
Because what I've been doing is also:
1. lock the table
2. get the id
3
Hi!
> "Lopez" == Lopez David > writes:
Lopez> AntiSpam - mysql, sql, query
Lopez> Version: 3.23.49a, MyISAM, NT, Solaris
Lopez> My app is 150 daemons writing logs to mysql. The main
Lopez> table is of fixed size but depends on four other tables
Lopez> for foreign keys (hash tables). These
AntiSpam - mysql, sql, query
Version: 3.23.49a, MyISAM, NT, Solaris
My app is 150 daemons writing logs to mysql. The main
table is of fixed size but depends on four other tables
for foreign keys (hash tables). These tables are uploaded
once to the daemon at start-up. Occasionally, a new entry
10 matches
Mail list logo