Mysql engines切换到InnoDB的时候发生的问题 发布日期:2017-03-02 17:15:53     博主推荐★

2017-02-16 16:42:10 11376 [Note] Plugin 'FEDERATED' is disabled.

2017-02-16 16:42:10 11376 [Note] InnoDB: Using atomics to ref count buffer pool pages

2017-02-16 16:42:10 11376 [Note] InnoDB: The InnoDB memory heap is disabled

2017-02-16 16:42:10 11376 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2017-02-16 16:42:10 11376 [Note] InnoDB: Compressed tables use zlib 1.2.3

2017-02-16 16:42:10 11376 [Note] InnoDB: Not using CPU crc32 instructions

2017-02-16 16:42:10 11376 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2017-02-16 16:42:10 11376 [Note] InnoDB: Completed initialization of buffer pool

2017-02-16 16:42:10 11376 [Note] InnoDB: Highest supported file format is Barracuda.

2017-02-16 16:42:10 11376 [Note] InnoDB: The log sequence numbers 1793940 and 1793940 in ibdata files do not match the log sequence number 1793950 in the ib_logfiles!

2017-02-16 16:42:10 11376 [Note] InnoDB: Database was not shutdown normally!

2017-02-16 16:42:10 11376 [Note] InnoDB: Starting crash recovery.

2017-02-16 16:42:10 11376 [Note] InnoDB: Reading tablespace information from the .ibd files...

2017-02-16 16:42:10 11376 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace my/ss uses space ID: 2 at filepath: .\my\ss.ibd. Cannot open tablespace mysql/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd

InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd

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.


修改数据库引擎导致的问题

在\mysql\bin下面的my.ini中添加

innodb_force_recovery = 1

就OK了。



博文地址:https://blog.ahamu.cn/blog/detail.html?id=103
   
推荐文章
  • 1
    sysbench
    2020/07/08
  • 2
    phper转java记录篇-spring boot
    2020/06/10
  • 3
    thinkphp5.0使用路由之后,post请求的
    2020/05/19
  • 4
    springboot单元测试aop失效
    2020/05/15
  • 5
    脑海中的JVM
    2020/05/12
  • 6
    IDEA搜索插件时显示search results
    2020/05/12
  • 7
    spring boot 配置加载源码查找
    2020/04/20
  • 8
    通过javap命令分析java汇编指令
    2020/04/16
  • 9
    IDEA小知识:查看JVM内存使用情况的步骤
    2020/04/16
  • 10
    springboot-加载自定义的properti
    2020/04/14
  • 11
    Jenkins执行shell脚本无法启动子进程解决
    2020/04/03
  • 12
    mac idea激活找专业的
    2020/04/02
  • 13
    Jenkins + DockerSwarm 实现弹
    2020/03/31
  • 14
    mac swarm学习过程
    2020/03/31
  • 15
    spring cloud
    2020/03/18
  • 16
    JAVA开发中遇到的问题记录002
    2020/03/12
  • 17
    JAVA开发中遇到的问题记录001
    2020/03/07
  • 18
    php -i查看信息
    2020/02/23
  • 19
    phpStorm中使用xdebug工具调试dock
    2019/12/09
  • 20
    讲的比较好的B+树执行原理的文章
    2019/12/09
最喜标签
NYOJ 面试 AJAX ping CentOS 灰度算法 YII2