The table 'pre_common_session' is full, Error_code: 1114解决办法

来源：互联网发布：淘宝天猫不能改价格吗编辑：程序博客网时间：2024/05/21 22:18

1.今天早上收到邮件报警，信息如下：

Could not execute Write_rows event on table test.pre_common_session; The table 'pre_common_session' is full, Error_code: 1114;
handler error HA_ERR_RECORD_FILE_FULL; the event's master log mysql-bin.002019, end_log_pos 87968421

(1) 查看了一下表结构：原来表为内存表

CREATE TABLE `pre_common_session` (
`sid` char(6) NOT NULL DEFAULT '',
`ip1` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ip2` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ip3` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ip4` tinyint(3) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` char(50) NOT NULL DEFAULT '',
`groupid` smallint(6) unsigned NOT NULL DEFAULT '0',
`invisible` tinyint(1) NOT NULL DEFAULT '0',
`action` tinyint(1) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastolupdate` int(10) unsigned NOT NULL DEFAULT '0',
`fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `sid` (`sid`),
KEY `uid` (`uid`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 MAX_ROWS=20000;

(2)查看了一下表的记录数，原来已经超过20000万了。

(3)解决方法：修改表的最大记录数即可解决。

alter table pre_common_session max_rows=65535;

0 0