From: shayne.alone@gmail.com
Date: January 15 2013 12:06pm
Subject: howto remove redo tablespace
List-Archive: http://lists.mysql.com/community/394
Message-Id: <CAK627OxNPMJ3sTL3ycu724920F2rVOumr5QnUFvP=mj4H6VMZg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7bdc7a9a94ee1404d3529a90

--047d7bdc7a9a94ee1404d3529a90
Content-Type: text/plain; charset=UTF-8

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

--047d7bdc7a9a94ee1404d3529a90--