the bevahiour you are observing is exactly what I
> would expect.
>
> On 8/31/07, Niklas Westerberg <[EMAIL PROTECTED]> wrote:
> > Hello,
> > We seem to have a problem with the usage of GET_LOCK on our mysql
> > server. Is there anyone who has experienced simila
Hello,
We seem to have a problem with the usage of GET_LOCK on our mysql
server. Is there anyone who has experienced similar behavior, or could
provide some insight into what is going on?
/Niklas
Symptoms:
* mysqld CPU-usage is 100%
* Queries of the type GET_LOCK('lock_name', 10)
Adam Newby wrote:
Description:
We have distributed applications which make extensive use of the
get_lock() function
to acquire a system-wide lock. Occasionally, all copies of a given
application
block attempting to acquire a lock on the same lock string. Using
is_used_lock
Description:
We have distributed applications which make extensive use of the
get_lock() function
to acquire a system-wide lock. Occasionally, all copies of a given
application
block attempting to acquire a lock on the same lock string. Using
is_used_lock() reports
I am aware it is a string lock, and this is what I want.
LOCK TABLES is not suitable for advisory locking. My question is targetted
at the usefulness of the GET_LOCK functionality when you can only lock one
'string' per connection.
Richard
- Original Message -
From: &qu
GET_LOCK is just a string lock, and has nothing to do with tables.
Use LOCK TABLES instead.
Richard Clarke wrote:
The manual indicates that a GET_LOCK expires automatically when a new
GET_LOCK is issued. Can someone explain to me how this behaviour could
possibly be the most useful?
I wish to use
The manual indicates that a GET_LOCK expires automatically when a new
GET_LOCK is issued. Can someone explain to me how this behaviour could
possibly be the most useful?
I wish to use GET_LOCK in my applications to provide advisory locking on
which tables should be used for certain operations. I
On Tue, Dec 31, 2002 at 01:49:00PM -0500, 'Bob Diss' wrote:
> Re: GET_LOCK locks
>
> Is there a way to show the status of locks created in this fash-
> ion? I'm looking for something that would list the locks
> current in existance, and which thread is holding it
Re: GET_LOCK locks
Is there a way to show the status of locks created in this fash-
ion? I'm looking for something that would list the locks
current in existance, and which thread is holding it.
filter: sql, mysql, mysql
On 22-Jun-01 Carsten H. Pedersen wrote:
> Has anyone successfully passed the get_lock()
> and release_lock() commands to a MySQL
> server using PHP? If so, how did you go about it?
Yes;
mysql_query("SELECT GET_LOCK('signups',20)");
fillsignups();
m
Hello.
I am not using PHP, so take my comment with a grain of salt.
PHP doesn't need explicit support for GET_LOCK and RELEASE_LOCK as
they are both just simply SQL functions. So I am not sure what you
problem is, just execute the following query:
SELECT GET_LOCK('whatever'
Has anyone successfully passed the get_lock()
and release_lock() commands to a MySQL
server using PHP? If so, how did you go about it?
PHP does not seem to implement these functions
despite the fact that they have been around since
sometime in March/April 1998.
/ Carsten
--
Natural selection
-table-primarykey.
Randy Johnson wrote:
>
> When using getlock what goes in the str in the following syntax
>
>GET_LOCK(str,timeout)
>
> is the the primary key of the row that you would like to lock? the manual isn't
>very specific on that.
."
--Henry Kissinger
> -Original Message-
> From: Randy Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 11:01
> To: [EMAIL PROTECTED]
> Subject: get_lock()
>
>
> When using getlock what goes in the str in the following syntax
>
>
When using getlock what goes in the str in the following syntax
GET_LOCK(str,timeout)
is the the primary key of the row that you would like to lock? the manual isn't very
specific on that
Thanks
randy
-
B
15 matches
Mail list logo
