MySQL Forums
Forum List  »  Oracle

Re: Rollback Segments in MySQL
Posted by: Josh Chamas
Date: November 19, 2004 03:12PM

sivagurunathan.subramanian wrote:
> Hi All,
>
> I am doing migration from Oracle 7.x to MySQL 4.0
> Pro (InnoDB) . I have 10 rollback segments in my
> Oracle database. These were used for read
> consistency and rollback transaction.
>
> I need to know the corresponding stuff in MySQL
> 4.0 Pro (InnoDB) version. I didn't find any
> command to create Rollback segment in MySQL.
>

The MySQL InnoDB engine manages its own rollback segments, so there is nothing for you to configure. There are log files to configure for innodb but these are analogous to redo logs in Oracle.

What may not be intuitive in MySQL is by default AutoCommit is enabled. To start a transaction from the command line client for use with InnoDB tables you must:

START TRANSACTION;
... SQL HERE ...
COMMIT/ROLLBACK;

You can also turn off autocommit like this:

SET AUTOCOMMIT=0;

Please see http://dev.mysql.com/doc/mysql/en/COMMIT.html for more information.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Rollback Segments in MySQL
3377
November 19, 2004 03:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.