List:Community« Previous MessageNext Message »
From:shayne.alone@gmail.com Date:January 15 2013 12:16pm
Subject:Re: howto remove redo tablespace
View as plain text  
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

Thread
howto remove redo tablespaceshayne.alone@gmail.com15 Jan
  • Re: howto remove redo tablespaceshayne.alone@gmail.com15 Jan