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