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