Bug #48089 Can't change UNDO_BUFFER_SIZE with ALTER LOGFILE GROUP ...

• Submitted: 15 Oct 2009 15:41
• Modified: 10 Mar 2010 10:13
• Reporter: Hartmut Holzgraefe
• Status: In progress
• Category: MySQL Cluster: Disk Data
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-7.0
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: mysql-cluster-7.0.8

[15 Oct 2009 15:41] Hartmut Holzgraefe

Description:
The UNDO_BUFFER_SIZE can only be set when creating a logfile group but can't be modified afterwards. If it turns out that the original value was too low all tables using a tablespace tied to the logfile group need to be dropped or converted to memory tables, all tablespace files removed, the tablespace dropped, all logfiles removed, and the logfile group dropped after which the logfile group and table space may be recreated with the new undo buffer size and tables restored or converted from memory to disk based tables again

How to repeat:
See documentation on CREATE LOGFILE GROUP and ALTER LOGFILE GROUP, ALTER has no idea about UNDO_BUFFER_SIZE