Re: Steps to enable undo tablespace in mysql for an existing database

[Venkataramanan Ramamoorthy]

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.