From: shayne.alone@gmail.com Date: January 15 2013 12:16pm Subject: Re: howto remove redo tablespace List-Archive: http://lists.mysql.com/community/395 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3079b9043b2d3004d352bf15 --20cf3079b9043b2d3004d352bf15 Content-Type: text/plain; charset=UTF-8 I had checked: (2- what would happened if i delete the undo016~32 files? stoped mysql updated config and rename undo017 to undo017OLD :-S amazing result was that it was not able to boot again... On Tue, Jan 15, 2013 at 3:36 PM, shayne.alone@stripped < shayne.alone@stripped> wrote: > Hi all; > In a file_per_table env I had configured InnoDB to separate undo > tablespace files. > innodb_undo_logs = 64 > innodb_undo_tablespaces = 32 > > do to the heavy write I had and for performance which I need, decided to > change configuration as: > innodb_undo_logs = 1 > innodb_undo_tablespaces = 16 > > there are two problem: > 1- undo001 file has been grown to 13G! how can i reduce it size? > 2- what would happened if i delete the undo016~32 files? > > > -- > Regards, > Ali R. Taleghani > -- Regards, Ali R. Taleghani --20cf3079b9043b2d3004d352bf15--