MySQL Bugs: #48089: Can't change UNDO_BUFFER_SIZE with ALTER LOGFILE GROUP ...

Bug #48089	Can't change UNDO_BUFFER_SIZE with ALTER LOGFILE GROUP ...
Submitted:	15 Oct 17:41	Modified:	15 Oct 17:56
Reporter:	Hartmut Holzgraefe
Status:	Verified
Category:	Server: ClusterDD	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-7.0	OS:	Any
Assigned to:		Target Version:
Tags:	mysql-cluster-7.0.8
Triage:	Triaged: D3 (Medium) / R6 (Needs Assessment) / E6 (Needs Assessment)

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