From: Hahn, Uwe (uwe.hahnsap.com)
Date: Mon Mar 15 2004 - 08:28:08 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello Ajit,

in 7.3 the logentries of large transactions are copied into transaction specific log files in the data area if the log is becoming full.
This makes it possible to overwrite the log area and to assure that the rollback will work.
Regards,
Uwe

>-----Original Message-----
>From: Ajit Aranha [mailto:ajitonmobile.com]
>Sent: Monday, March 15, 2004 11:48 AM
>To: maxdblists.mysql.com
>Subject: 7.3 and DEMO Logmode
>
>Can someone tell me if rollback is possible for an extremely large
>transaction (deleting 2000000 records from a table using a single delete
>statement.This is 50% of table contents)
>I'm using 7.3.0.30 with DEMO Log.
>
> If the log is auto overwritten during the execution of the delete and
>the delete is then aborted. (i.e. client/server is killed) will the
>statement be rolled back?
>
>The db was restarted but did not come to an online state. I gave up on
>it after 3 hours (kernel.exe was busy during this period).
>
>Regards,
>Ajit

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]