Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
the
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 18, 2007 10:00 AM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
I realize that wasn't the question, but it does seem like a lot of
trouble to get the equivalent of setAutoCommit
ichael Dykman [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 17, 2007 2:56 PM
> To: Robert DiFalco
> Cc: Baron Schwartz; mysql@lists.mysql.com
> Subject: Re: Rollback on a Transaction with No Updates
>
> If your transaction are only 1 query deep, why use them at all? An
> indivi
Sure, but that wasn't really the question.
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:56 PM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
If your transa
same as issuing a commit (unless there was an exception but I'm not
> analyzing that case).
>
> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 17, 2007 2:36 PM
> To: Robert DiFalco
> Cc: mysql@lists.mysql.com
>
ing a commit (unless there was an exception but I'm not
analyzing that case).
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:36 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updat
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
the
449 |
+---+--+
222 rows in set (0.00 sec)
Please check what is wrong and teach me.
Thanks you,
- Original Message -
From: "Pooly" <[EMAIL PROTECTED]>
To: "MySQL General"
Sent: Tuesday, March 14, 2006 2:53 PM
Subject: Re: Rollback is no
ser |
> +--+
>
>
> I set innodb_table_locks=0 in my.cnf , but ROLLBACK is still not effect.
>
>
> Could you teach me more ?
>
>
> Thanks and best regards,
>
>
> - Original Message -
> From: "Pooly"
: Monday, March 13, 2006 5:13 PM
Subject: Re: Rollback is not take effect on MySQL 5.0.18
2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>:
Dear Sir,
On RedHat Enterprise 4, and MySQL 5.0.18, I did :
mysql> set autocommit=0;
mysql> savepoint abc;
mysql> insert something
2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>:
> Dear Sir,
>
> On RedHat Enterprise 4, and MySQL 5.0.18, I did :
>
> mysql> set autocommit=0;
>
> mysql> savepoint abc;
>
> mysql> insert something
>
> mysql> rollback to save point abc;
>
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> ^
Jaime,
please post the COMPLETE UNEDITED .err log.
The log sequence number would mean that your InnoDB tablespace has not been
used after it was created:
051130 19:01:26 InnoDB: Started; log sequence number 0 43634
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row
_increment the table you
are inserting the record into. This should be a little less resource
intensive than to put all data into temporary tables.
Clint
From: Joerg Bruehe <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
CC: Andre Matos <[EMAIL PROTECTED]>, Paul DuBois <[EMAI
Hi!
Am Di, den 18.01.2005 schrieb Paul DuBois um 3:53:
> At 21:27 -0500 1/17/05, Andre Matos wrote:
> >Thanks Eric, but I can let it increment because I cannot have a gave in the
> >numbers. I think I will need to use MAX() in this case.
>
> Using MAX() won't guarantee that you won't have gaps.
>
Yes, I know about this. What I plan is to remove the auto_increment. I will
do this by hand locking the entire table just right before inserting the
field. Actually, it is running like this. I am just upgrading the PHP.
I will keep the auto_increment in other tables that does not have this kind
of
At 21:27 -0500 1/17/05, Andre Matos wrote:
Thanks Eric, but I can let it increment because I cannot have a gave in the
numbers. I think I will need to use MAX() in this case.
Using MAX() won't guarantee that you won't have gaps.
What you're describing cannot be achieved in the general case.
Conside
Thanks Eric, but I can let it increment because I cannot have a gave in the
numbers. I think I will need to use MAX() in this case.
Thanks.
Andre
On 1/17/05 8:14 PM, "Eric Bergen" <[EMAIL PROTECTED]> wrote:
> Just let it increment. Keeping it incremented is MySQL's way ot
> insuring that the
Just let it increment. Keeping it incremented is MySQL's way ot
insuring that the same id doesn't get used twice for different
records. It's doing everything correctly.
-Eric
On Mon, 17 Jan 2005 19:06:45 -0500, Andre Matos
<[EMAIL PROTECTED]> wrote:
> Hi List,
>
> I have a field in one of my tab
You can add a version field to each row. Then add a seperate table with
info with a list of the versions and a flag for deleted. Queries would
look for each record that has the highest version number thats not
deleted. Having a lot undo/redo info can get kind of complicated,
especialy with multip
Am Fr, den 02.01.2004 schrieb karthikeyan.balasubramanian um 09:28:
> Is there any alternative way to get back to the old state of the database?
The only way I can think of is to dump the respective tables (e.g. every
night) and re-import them when needed.
Note that this can't be done by mysql
an"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 02, 2004 1:33 PM
Subject: RE: Rollback
> I'm fairly sure there is *no* way to do it. COMMIT says 'I want this data
in
> the database' not 'I think I want this data in the database'
>
&g
I'm fairly sure there is *no* way to do it. COMMIT says 'I want this data in
the database' not 'I think I want this data in the database'
Chris
-Original Message-
From: karthikeyan.balasubramanian
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 11:37 PM
To: [EMAIL PROTECTED]
Su
y, November 14, 2003 4:54 PM
Subject: Re: rollback error
> Fernando <[EMAIL PROTECTED]> wrote:
> >
> > In version 3.23.57 when i do a rollback i get this error message and the
changes are not undone, why?
> >
> > This is what i typed: (NOTE: 'insert.sql&#x
Fernando <[EMAIL PROTECTED]> wrote:
>
> In version 3.23.57 when i do a rollback i get this error message and the changes are
> not undone, why?
>
> This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
>
> mysql> SET AUTOCOMMIT=0;
> Query OK, 0 rows affected (0.00
Susan,
you had posted your message to the newsgroup mailing.database.mysql. That is
only a mirror of the mailing list [EMAIL PROTECTED], where you should
send your postings for them to be readable for all.
InnoDB has a data structure which is equivalent to the 'rollback segment' of
Oracle. But, c
Yes,
Back up your data every night. Then you will only have to perform a single simple
restore instead of rebuilding from four months ago. I know that this sounds like a
smart ass reply but I am serious. Disk space is cheap. CD's are cheap. Other media
like DVDs are getting cheaper every day. U
Mark wrote:
Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
months ago and binlogs from then on. I had to load the original table
into a separate db and then grep through the binlogs for queries to
update
* Irmund Thum <[EMAIL PROTECTED]> wrote on 25.02.01 17:20:
> ERROR 1196: Warning: Some non-transactional changed tables couldn't be
> rolled back
> ***
> so I'm not that expert knowing what "non-transactional changed tables"
> exactly means
You're probably using the RPM version or otherwise just
[EMAIL PROTECTED] schrieb:
>
> create table bdbtest (pk int primary key, name varchar(20)) type=bdb;
> begin;
> insert into bdbtest values (1, 'tim');
> rollback;
> select * from bdbtest;
> (I see the row but should not)
on RH7 I get
***
mysql> select * from bdbtest;
++--+
| pk | name |
29 matches
Mail list logo
