MySQL Forums
Forum List  »  InnoDB

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

Venkataramanan Ramamoorthy Wrote:
-------------------------------------------------------
> 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.


Just to add one more key point that innodbfile_per_table option is already enabled for the DB.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Steps to enable undo tablespace in mysql for an existing database
56
July 09, 2018 01:49PM


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.