I'm sorry to mistake the wrong storage engine. On Wed, Nov 12, 2008 at 3:52 PM, Moon's Father <[EMAIL PROTECTED]>wrote:
> Hi. > I got an error when I use alter statement to modify an innodb's table > structure. The error no is 1114 and the detail information is > ERROR 1114 (HY000): The table '#sql-4c0_1' is full. > > Here is my table's structure. > mysql> show create table t1; > > +-------+----------------------------------------------------------------------- > > -------------------------------------------------------------------------------- > ---------------------------------------+ > | Table | Create Table > > | > > +-------+----------------------------------------------------------------------- > > -------------------------------------------------------------------------------- > ---------------------------------------+ > | t1 | CREATE TABLE `t1` ( > `a` int(11) NOT NULL AUTO_INCREMENT, > `message` char(20) DEFAULT NULL, > PRIMARY KEY (`a`) > ) ENGINE=MyISAM AUTO_INCREMENT=9437185 DEFAULT CHARSET=latin1 MAX_ROWS=100 > | > > +-------+----------------------------------------------------------------------- > > -------------------------------------------------------------------------------- > ---------------------------------------+ > 1 row in set (0.02 sec) > > > > > I just want to know how to affect a innodb table's behavior when I added a > max_rows option to it. > I read the document but she said this option didn't matter. > > mysql> alter table t1 modify message varchar(20) not null; > ERROR 1114 (HY000): The table '#sql-4c0_1' is full > mysql> alter table t1 max_rows = 1000000000; > Query OK, 0 rows affected (0.03 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > mysql> alter table t1 modify message varchar(20) not null; > Query OK, 4437184 rows affected (1 min 32.93 sec) > Records: 4437184 Duplicates: 0 Warnings: 0 > > > -- > I'm a MySQL DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
