MyISAM、InnoDB在频繁插入删除情况下的不同
建表语句:
create table if not exists `cms_hotarticle`(
`id` int(11) unsigned not null auto_increment,
`name` varchar(100) character set utf8 not null ,
primary key (`id`)
)engine=MyISAM default charset=utf8 collate=utf8_unicode_ci auto_increment=444;
create table if not exists `inno_hotarticle`(
`id` int(11) unsigned not null auto_incremcrement,
`name` varchar(100) character set utf8 not null ,
primary key (`id`)
)engine=InnoDB default charset=utf8 collate=utf8_unicode_ci auto_increment=444;