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:

... SQL HERE ...

You can also turn off autocommit like this:


Please see for more information.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
Re: Rollback Segments in MySQL
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.