Suppose I have an innodb table in 4.0.14 and do:
LOCK TABLE maggie
INSERT INTO maggie values(123, 'simpson');
UNLOCK TABLES
As soon as I issue LOCK TABLE, any transaction in progress is
automatically committed.
By what point is this INSERT guaranteed to be committed to disk
(ie. redo log)?
Is i
Marc,
- Original Message -
From: "Marc Slemko" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, August 23, 2003 7:19 AM
Subject: innodb use outside of explicit transactions
> Suppose I have an innodb table in 4.0.14 and do:
>
> LOCK T
On Sat, 23 Aug 2003, Heikki Tuuri wrote:
> Marc,
>
> - Original Message -
> From: "Marc Slemko" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, August 23, 2003 7:19 AM
> Subject: innodb use outside of explicit transactions
&