hi,
to explicitly lock a row (or rows), use :
BEGIN TRAN
select ... from ... where ... FOR UPDATE;
update ...
COMMIT TRAN;
Mathias
Selon Mohammed Sameer <[EMAIL PROTECTED]>:
>
> need some urgent help
>
> im using InnoBD database type...i need to explicitly lock a row and keep it
> locked until
need some urgent help
im using InnoBD database type...i need to explicitly lock a row and keep it
locked until i explicitly unlock that row..
it would be great if u could provide me with sql statements as a solution for
the above...
thanks
Hi again,
I ran into some dead locking that was unexpected, & I basically think
the "insert error -> share lock" behavior is problematic. I would think
that either a insert error does not acquire a row lock ( equivalent of a basic select
),
or that it would acquire an exclusive row lock as if the
check and then update
> >but because of tomcat accepting connections the above becomes
> >check check update update
> >i dont want to set the table locking, as it will make the system slower
> >how can i set exclusive row locking until the update is finished?
>
> Have yo
dont want to set the table locking, as it will make the system slower
how can i set exclusive row locking until the update is finished?
Have you tried using SELECT ... FOR UPDATE?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For
Are you running the queries in parallel or serially? Are you using the same
connection? Are you issuing Low Priority Updates?
-Original Message-
From: Sahil Aggarwal
To: [EMAIL PROTECTED]
Sent: 4/16/04 8:27 AM
Subject: row locking
hi all,
i have select statements in my java code which
make the system slower
how can i set exclusive row locking until the update is finished?
Any pointers are appreciated.
-Regards
Sahil Aggarwal
Robert,
- Original Message -
From: ""Robert Tam"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, January 10, 2003 7:43 AM
Subject: Transaction and Row Locking Feature
> Hello,
>
> I am a new user to MySQL. I need innoDB's
Hello,
I am a new user to MySQL. I need innoDB's transaction and row locking
feature in MySQL. Could someone clarify whether the latest 3.23.54a of
MySQL fully supports innoDB transaction and row locking or do I have to use
beta/gamma version of MySQL 4.0.x. Thanks in advance.
Mike,
- Original Message -
From: "Mike Gohlke" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 07, 2002 6:44 PM
Subject: Re: Innodb row locking question
>
>
> Benjamin Pflugmann wrote:
>
> >Hello.
> >
> &
Hello.
On Sat 2002-12-07 at 10:36:00 -0600, [EMAIL PROTECTED] wrote:
[...]
> >Why do you repeat "job_id = 111 and thread_id = 0"? If you are using a
> >transaction seperation level of at least REPEATABLE READ (which is the
> >default), InnoDb assures that you always see the same rows within one
>
Benjamin Pflugmann wrote:
Hello.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
Heikki and all,
I've got a quick question which may be more general sql related but
since I'm using innodb tables specifically for the row locking.
The following process desc
Hello.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
> Heikki and all,
> I've got a quick question which may be more general sql related but
> since I'm using innodb tables specifically for the row locking.
>
> The following process description is specifi
Heikki and all,
I've got a quick question which may be more general sql related but
since I'm using innodb tables specifically for the row locking.
The following process description is specifically designed to prevent
duplicates.
My current process:
select * from run where job_id
use InnoDB which does support row-locking (MySQL-Max)
-Original Message-
From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 9:23 AM
To: [EMAIL PROTECTED]; MySQL Maling list
Subject: Row Locking issue in 3.23.x
Hi. As far as I know, MySQL doesn't s
Hi. As far as I know, MySQL doesn't suport row-locking, only table locking
is available.
But I figured table locking for sessions table of CGI::Session::MySQL
would be
quite inefficient, for there might be millions of rows and hundreds of
them
could be active at any time. So what do you
Hello sql,
I wonder if there is a timeout for a lock when
the user cancel a script. Let's suupose I use
non-persistent connection.
Also, what happens if I use persistent connection,
does the table/row remains locked for ever?...
Thanx, anybody :)
Daniel BI
--
17 matches
Mail list logo
