Bug #12086 Check for enough free disk space before executing ALTER TABLE
Submitted: 21 Jul 2005 18:49 Modified: 6 Nov 2009 16:44
Reporter: David Ishee Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: CPU Architecture:Any

[21 Jul 2005 18:49] David Ishee
Description:
The database server should check free disk space in the data directory before executing an ALTER TABLE command to make sure there is enough. 

 

How to repeat:
Create a database and supply data. Make sure there is a table that has more data in it than the available free space on the disk. Use and ALTER TABLE statement to add a column.

Suggested fix:
Check free disk space before executing ALTER TABLE command. 

Allow a command line option to specify where the temp data is stored for ALTER TABLE commands. I see no way to specify a location other than the default (which is the data directory).

Modify the way MySQL implements the ALTER TABLE command to not need a complete copy of the new table.
[6 Nov 2009 16:44] Valeriy Kravchuk
Thank you for the feature request.