解决mysql出现"the table is full"的问题
<p><span style="font-size:16px;color:#000000;background-color:#ffffff;">错误信息 [ERROR] /usr/libexec/mysqld: The table 'xxx_xxx' is full</span></p>
<p>
</p>
<p><span style="font-size:16px;color:#000000;background-color:#ffffff;">修改/etc/my.cn</span><span style="line-height:1.5;font-size:16px;color:#000000;background-color:#ffffff;">f ,在</span><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">[mysqld]下面</span><span style="line-height:1.5;font-size:16px;color:#000000;background-color:#ffffff;">添加两行</span></p>
<p><span style="line-height:1.5;">
</span></p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">tmp_table_size = 256M</span>
</p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">max_heap_table_size = 256M</span></p>
<p><span style="color:#454545;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;">
</span></p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">重启mysql服务</span></p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">
</span></p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">ps.网上有资料说修改了参数也可能无效,需要删除报错的表重建</span></p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">
</span></p>
<p><span style="color:#000000;font-family:'microsoft yahei', 微软雅黑, tahoma, arial, helvetica, stheiti;font-size:16px;line-height:25px;background-color:#ffffff;">
</span></p>
<p></p>
评论已关闭