I have a large MyISAM table, and I would like to change the default value for one of the columns. Using mysql 5.1.31, I issue the following command:
ALTER TABLE medianet_media_files ALTER COLUMN feed_created_id SET DEFAULT 64;
Although this *should* cause only a simple modification to the .frm file, mysql *insists* on copying the entire table:
+----+------+-----------+----------------+---------+------+-------------------+------------------------------------------------------------------------------+| Id | User | Host | db | Command | Time | State | Info |+----+------+-----------+----------------+---------+------+-------------------+------------------------------------------------------------------------------+| 90 | root | localhost | mog_production | Query | 48 | copy to tmp table | ALTER TABLE medianet_media_files ALTER COLUMN feed_created_id SET DEFAULT 64 | | 91 | root | localhost | mog_production | Query | 0 | NULL | show full processlist | +----+------+-----------+----------------+---------+------+-------------------+------------------------------------------------------------------------------+2 rows in set (0.00 sec)
Any ideas?
ALTER TABLE medianet_media_files ALTER COLUMN feed_created_id SET DEFAULT 64;
Although this *should* cause only a simple modification to the .frm file, mysql *insists* on copying the entire table:
+----+------+-----------+----------------+---------+------+-------------------+------------------------------------------------------------------------------+| Id | User | Host | db | Command | Time | State | Info |+----+------+-----------+----------------+---------+------+-------------------+------------------------------------------------------------------------------+| 90 | root | localhost | mog_production | Query | 48 | copy to tmp table | ALTER TABLE medianet_media_files ALTER COLUMN feed_created_id SET DEFAULT 64 | | 91 | root | localhost | mog_production | Query | 0 | NULL | show full processlist | +----+------+-----------+----------------+---------+------+-------------------+------------------------------------------------------------------------------+2 rows in set (0.00 sec)
Any ideas?
Comment