Bug #51849 Allow to change innodb size dynamically.
Submitted: 9 Mar 2010 0:50 Modified: 26 Mar 2010 14:50
Reporter: Meiji KIMURA Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Mar 2010 0:50] Meiji KIMURA
Now we cannot change InnoDB table space (a.k.a ibdata)'s size dynamically.
So If we want to do this, we have to re-activate mysqld.

This the feature request to do it dynamically, like

o Extend ibdata size whenever use want( to specified size) with setting autoextend option.
  The user can extend (pre-allocate) ibdata when the disk load is low.

o Add new file for idbdata with setting no autoextend option.
  The user cann add new file for ibdata when it exceed the estimate size without re-activate.

And if there is the message about innodb file extend (e.g. xxMB extended at 2010-03-09 18:00:01) in error message, it is useful for management innodb table space.

How to repeat:

Suggested fix:
[26 Mar 2010 14:50] Valeriy Kravchuk
Thank you for the feature request.