MySQL Forums
Forum List  »  InnoDB

ROLLBACK Segments found
Posted by: Philip Gladwin
Date: September 08, 2016 04:23AM

While looking through a log file on Workbench I noticed this item:

InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active

Does this relate to the number of BEGIN / COMMIT / ROLLBACKS I've done? If yes, is there any danger that "forks" will appear in my tables.
Is it best practice to remove the rollback segments? How do you do that?

Thank you,

Options: ReplyQuote

Written By
ROLLBACK Segments found
September 08, 2016 04:23AM
September 11, 2016 07:50PM

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.