MySQL Forums
Forum List  »  InnoDB

Steps to enable undo tablespace in mysql for an existing database
Posted by: Venkataramanan Ramamoorthy
Date: July 09, 2018 12:43PM

I'm new to mySQL. we are running a mysql(5.7.21) database and the ibdata1 file growing uncontrollably.

Upon researching found undo tablespaces can be created managed separately.

Currently I have only one schema/database( called kip1) in addition to the default databases. Someone else created this database and I would like to enable the undo tablespace.

I tried to include the parameters in "cnf" file, but mysql database report an error and never started the DB.

I'm looking for some support for the exact steps to be performed to enable the same.

Appreciate any help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Steps to enable undo tablespace in mysql for an existing database
39
July 09, 2018 12:43PM


Sorry, only registered users may post in this forum.

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.