遭遇mediumint上限
Mediumint:The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.
home_notification | CREATE TABLE `home_notification` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `type` varchar(20) NOT NULL DEFAULT '', `new` tinyint(1) NOT NULL DEFAULT '0', `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0', `author` varchar(15) NOT NULL DEFAULT '', `note` text NOT NULL, `dateline` int(10) unsigned NOT NULL DEFAULT '0', `from_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `from_idtype` varchar(20) NOT NULL DEFAULT '', `from_num` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `uid` (`uid`,`new`,`dateline`), KEY `from_id` (`from_id`,`from_idtype`) ) ENGINE=InnoDB AUTO_INCREMENT=16777215 DEFAULT CHARSET=utf8 |
短信息表的主键id自增到上限,第一次碰见。共13G的数据,改主键属性耗时约为1小时。