找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 24|回复: 2

求助开主机商的大佬 my.cnf

[复制链接]

18

主题

63

回帖

186

积分

注册会员

积分
186
发表于 2017-5-28 22:12:39 | 显示全部楼层 |阅读模式
你们是怎么配置的 数据库大概300+
每次用一段时间mysql后就错误
日志如下
InnoDB: We do not continue the crash recovery, because the table may become InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it. InnoDB: To fix the problem and start mysqld: InnoDB: 1) If there is a permission problem in the file and mysqld cannot InnoDB: open the file, you should modify the permissions. InnoDB: 2) If the table is not needed, or you can restore it from a backup, InnoDB: then you can remove the .ibd file, and InnoDB will do a normal InnoDB: crash recovery and ignore that table. InnoDB: 3) If the file system or the disk is broken, and you cannot remove InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf InnoDB: and force InnoDB to continue crash recovery here.
回复

使用道具 举报

18

主题

63

回帖

186

积分

注册会员

积分
186
 楼主| 发表于 2017-5-28 22:34:17 | 显示全部楼层
回复

使用道具 举报

49

主题

1271

回帖

2695

积分

金牌会员

积分
2695
发表于 2017-5-29 06:55:25 | 显示全部楼层
帮顶
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|Discuz! X

GMT+8, 2025-2-12 02:07 , Processed in 0.014977 second(s), 4 queries , Gzip On, Redis On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表