Fareeda,

----- Original Message ----- 
From: "fareeda" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 25, 2003 5:32 PM
Subject: Question on rollback segment equivalent


> What is the equivalent of rollback segments (from Oracle) on MySQL?
> And if something is being used internally, can I change the size of
> this? I do not want to run into problems like exceeded rollback size
> or something like that.

in InnoDB there is a 'rollback segment', which is the totality of the undo
logs in the tablespace. But you do not need to tune it in any way, and it
takes much less space than in Oracle.

> Any pointer appreciated
> Thanks
> Fareeda

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to