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
