文档首页
MySQL 8.4 参考手册
8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文,英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成,仅供理解参考;有疑问请以官方英文原文为准。

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

17.20.2 解决恢复失败问题17.20.2 Troubleshooting Recovery Failures

在重做日志恢复完成并且数据字典动态元数据(srv_dict_metadata)被传输到数据字典表(dict_table_t)对象之前,不允许检查点和推进检查点 LSN。如果在恢复期间或恢复之后(但在数据字典动态元数据传输到数据字典表对象之前)由于此更改导致重做日志空间不足,可能需要进行 innodb_force_recovery 重启,至少从 SRV_FORCE_NO_IBUF_MERGE 设置开始,如果失败,则使用 SRV_FORCE_NO_LOG_REDO 设置。如果在这种情况下 innodb_force_recovery 重启失败,可能需要从备份中恢复。Checkpoints and advancing the checkpoint LSN are not permitted until redo log recovery is complete and data dictionary dynamic metadata (srv_dict_metadata) is transferred to data dictionary table (dict_table_t) objects. Should the redo log run out of space during recovery or after recovery (but before data dictionary dynamic metadata is transferred to data dictionary table objects) as a result of this change, an innodb_force_recovery restart may be required, starting with at least the SRV_FORCE_NO_IBUF_MERGE setting or, in case that fails, the SRV_FORCE_NO_LOG_REDO setting. If an innodb_force_recovery restart fails in this scenario, recovery from backup may be necessary.