mysql> show create table sbtest1;
| sbtest1 | CREATE TABLE sbtest1 (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
k int(10) unsigned NOT NULL DEFAULT ‘0’,
c char(120) NOT NULL DEFAULT ‘’,
pad char(60) NOT NULL DEFAULT ‘’,
PRIMARY KEY (id),
KEY k_1 (k)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=1000000
1 row in set (0.00 sec)
du -ks shtest1;
MyiSAM引擎下表的大小:
11534336 Apr 1 19:10 sbtest1.ibd
mysql> alter table test engine=innodb;
Query OK, 244688 rows affected (22.60 sec)
Records: 244688 Duplicates: 0 Warnings: 0
InnoDB引擎下表的大小:
65540 test.ibd
mysql> alter table test engine=archive;
Query OK, 244688 rows affected (17.37 sec)
Records: 244688 Duplicates: 0 Warnings: 0
Archive引擎下表的大小:
23052 test.ARZ
总结;在不同的引擎下表的大小是不一样的