Hi,
I have a quick question, which I did not find answerd by the manual:
Given this sample query:
SELECT COUNT(ID)
FROM mytable
WHERE property=value
FOR UPDATE
Which rows in 'mytable' are locked after this query?
Every row with property=value, because these rows were used to calculate
COUNT(ID).
N
Andre,
- Original Message -
From: "Andre Charbonneau" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, November 17, 2003 5:11 PM
Subject: row-level locking question...
> Hi,
>
> Let say that I have the following transaction:
>
> 1. R
On Mon, Nov 17, 2003 at 10:10:52AM -0500, Andre Charbonneau wrote:
> Hi,
>
> Let say that I have the following transaction:
>
> 1. Read value v1 from table t1.
> 2. Do some computation using v1.
> 3. Update value v2 from table t2.
>
> If in the above I don't want any other concurrent transaction
Hi,
Let say that I have the following transaction:
1. Read value v1 from table t1.
2. Do some computation using v1.
3. Update value v2 from table t2.
If in the above I don't want any other concurrent transaction to read v2
until I'm done updating it, how should I put an exclusive lock on it?
Us
Steve,
- Original Message -
From: ""Steve McWilliams"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 27, 2003 12:07 AM
Subject: Question about row level locking with InnoDB tables
> Hello,
>
> I am relatively ne
Hello,
I am relatively new to MySql (4.0.14) but I have read through the relevent
documentation and am still confused about how row level locking behaves
with InnoDB tables.
I created a database with a single innodb table which has 2 columns, one
of which is indexed. The locking behavior I see
>-Original Message-
>From: Fernando Grijalba [mailto:fernando@;ggtours.on.ca]
>Sent: Wednesday, November 06, 2002 11:41 AM
>To: MySQL Help
>Subject: InnoDB row level locking?
>
>
>In the documentation it says that InnoDB supports row level
>locking. How
>can
In the documentation it says that InnoDB supports row level locking. How
can I ensure that rows are locked using ADO in a VB Applications
communicating with MySQL through MyODBC?
I have tried setting my Recordsets to adLockPessimistic, but that does not
seam to work.
Any help will be really
Shilline,
- Original Message -
From: "Shilline Lee" <[EMAIL PROTECTED]>
To: ""Heikki Tuuri"" <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 4:08 AM
Subject: Re: ROW LEVEL Locking not affected
>
>
>And then ? please tell
Shilline,
- Original Message -
From: "Shilline Lee" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, October 13, 2002 7:16 AM
Subject: ROW LEVEL Locking not affected
>
> Hello all:
>
> I did a row level lock with my database (
Alex,
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 11:49 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking..
o: Varshavchick Alexander <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Performance Problems with InnoDB Row Level Locking...
>
> Alexander,
>
> - Original Message -
> From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
> To: "
Joe,
- Original Message -
From: "Joe Shear" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 2:13 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
> Hi,
> On a side note, are there any
Alexander,
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 10:08 AM
Subject: RE: Performance Problems with InnoDB
Hi Heikki,
one more question please about innodb_flush_log_at_trx_commit: if there
was some way of increasing the delay between log flushes more than 1 sec,
can you estimate will it bring any real effect in performance? I know
it'll raise the risk of losing some last transactions if something
cra
Steve,
- Original Message -
From: "Orr, Steve" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 1:23 AM
Subject: RE: Performance Problems with InnoDB Row Level Locking
teve
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 2:54 PM
To: Orr, Steve
Cc: [EMAIL PROTECTED]
Subject: Re: Performance Problems with InnoDB Row Level Locking...
Steve,
- Original Message -
From: "Orr, Steve" <[EM
Steve,
- Original Message -
From: "Orr, Steve" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 11:04 PM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
> Heikki,
>
>
i
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Orr, Steve" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 10:30 PM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
> Steve,
>
Steve,
- Original Message -
From: "Orr, Steve" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 9:49 PM
Subject: RE: Performance Problems with InnoDB Row Level Locki
t atomic then does that mean that MySQL
still does not pass the ACID test even with InnoDB?
Thanks again and I'm eagerly awaiting your reply.
Respectfully,
Steve Orr
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 9:05 AM
To:
Alexander,
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 6:51 PM
Subject: Re: Performance Problems with InnoDB Row Level Lock
Heikki, one little question - is it a mistype, or can a flush log interval
duration be controlled by this option? The value should only be 0 or 1 as
the documentation says...
On Thu, 5 Sep 2002, Heikki Tuuri wrote:
> You can try setting
>
> innodb_flush_log_at_trx_commit=2
>
> if you can afford
Steve,
- Original Message -
From: ""Orr, Steve"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:52 PM
Subject: Performance Problems with InnoDB Row Level Locking...
> Background:
> I've developed a sim
Background:
I've developed a simplistic Perl program to test database performance with
concurrent session queries. The queries involve inserts, updates, and
deletes in order to test database performance in an OLTP mult-user ACID
compliant scenario. Obviously this is not a "real world test" but it
On Wed, Sep 04, 2002 at 10:28:36AM +0530, Sekhar.Thota wrote:
> Hi,
>
> I have did setup for MySQL - Innodb tables. But I am not getting support for
> row level locks. Whenever I am issuing a update the innodb tables are
> locking my tables. Please help me whether I need to set any variables in
>
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
-
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
locking
Hi, Ive just downloaded MySQL and am trying to switch on row level locking.
Ive changed the tables to InnoDB but it still seems to be switched off - are
there other things which need to be done?
Thanks,
Tom Robinson
Workforce Systems
Hi, Ive just downloaded MySQL and am trying to switch on row level locking. Ive
changed the tables to InnoDB but it still seems to be switched off - are there other
things which need to be done?
Thanks,
Tom Robinson
Workforce Systems
Kishor,
>Hi,
>
>We are trying to implement row level locking in our appln.
>we have a table Orderwe are locking the table using
>SELECT * FROM Order FOR UPDATE;
>but still another user is able to update this table. why?
check with
mysql>SHOW TABLE STATUS FROM yo
Hi,
We are trying to implement row level locking in our appln.
we have a table Order
we are locking the table using
SELECT * FROM Order FOR UPDATE;
but still another user is able to update this table. why?
we have autocommit set to zero.
Our requirement is
1. user selects a order for
On Monday 12 March 2001 17:17, Heikki Tuuri wrote:
> Hi, readers of the mailing list!
>
> the Innobase table handler has finally been released as a part of
> the MySQL-3.23.34a source distribution Tarball.
Great news!
Congratulations for a great addition to the (already) great MySQL software.
--
of MySQL-3.23.34a
source distribution for Unix. You can find the source distribution file
from the MySQL website: http://www.mysql.com/downloads/mysql-3.23.html,
look at source downloads for 3.23.34a Tarball.
Innobase adds transactions, rollback, commit, row level locking, and
an Oracle-style
Hi!
I hope that this message goes to the right 'thread' in the mailing
list; not replied to a thread before.
Monty recommended that we should wait still for a few weeks before
releasing MySQL 4.0/Innobase-alpha, to keep source code versions in
control.
But I can now report here the current stat
gt; Sent: Thursday, January 18, 2001 12:47 PM
> To: Heikki Tuuri
> Cc: [EMAIL PROTECTED]
> Subject: Re: A new engine under MySQL with trx & row-level locking
>
> On Thu, Jan 18, 2001 at 04:47:47PM +0200, Heikki Tuuri wrote:
>
> > Monty recommended that I should wr
]]
Sent: Thursday, January 18, 2001 12:47 PM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED]
Subject: Re: A new engine under MySQL with trx & row-level locking
On Thu, Jan 18, 2001 at 04:47:47PM +0200, Heikki Tuuri wrote:
> Monty recommended that I should write to this list. I am currently
>
as free open source software.
>
> The Windows and Linux versions of the combined MySQL/Innobase
> database already work.
This is excellent news!
> Innobase supports transactions, rollback, recovery, row-level
> locking, and also consistent non-locking reads in the Oracle
> styl
out with MySQL
version 4 as free open source software.
The Windows and Linux versions of the combined MySQL/Innobase database
already work.
Innobase supports transactions, rollback, recovery, row-level locking,
and also consistent non-locking reads in the Oracle style. I noticed from
the messages
39 matches
Mail list logo
