首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >mysql偶尔会重启

问mysql偶尔会重启
EN

Stack Overflow用户
提问于 2015-09-21 21:02:35
回答 1查看 188关注 0票数 0

在晚上,我们的mysql服务器偶尔会重启(innodb引擎),在日志中我看到了以下内容:

代码语言:javascript
复制
150921  1:58:44  InnoDB: Page checksum 2064838754 (32bit_calc:  866699801), prior-to-4.0.14-form checksum 400856538
InnoDB:stored checksum 1847129036, prior-to-4.0.14-form stored checksum 42278670
InnoDB: Page lsn 0 3564194321, low 4 bytes of lsn at page end 2315587073
InnoDB: Page number (if stored to page already) 80945,

InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an index page where index id is 116
InnoDB: (index "idx_cru_type" of table "fisheyedb"."cru_login_cookie")
150921  1:58:44  InnoDB: Assertion failure in thread 139799134877440 in file rem0rec.c line 569
 InnoDB: We intentionally generate a memory trap.
 InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
 InnoDB: If you get repeated assertion failures or crashes, even
 InnoDB: immediately after the mysqld startup, there may be
 InnoDB: corruption in the InnoDB tablespace. Please refer to

在http://bugs.percona.com/ key_buffer_size=33554432

有没有可能透露发生了什么,以及我们应该做些什么来进一步避免这种行为?

EN

回答 1

Stack Overflow用户

发布于 2015-09-21 22:12:34

我想那张桌子坏了。你可以使用备份修复命令: First MySQL!https://dev.mysql.com/doc/refman/5.0/en/rebuilding-tables.html

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/32695957

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档