mysql偶尔会重启

Question

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

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

是否有可能揭示发生了什么以及我们应该做什么来进一步避免这种行为？

Answer 1

我认为该表已损坏。您可以使用MySQL修复命令:第一次备份! https://dev.mysql.com/doc/refman/5.0/en/rebuilding-tables.html