gpt4 book ai didi

mysql - XAMPP : MySQL shutdown unexpectedly INNODB warnings

转载 作者:行者123 更新时间:2023-11-29 11:43:52 25 4
gpt4 key购买 nike

一切都工作正常,但突然 MySQL 停止工作并在启动之前意外关闭。我根据其他堆栈溢出答案尝试了各种解决方案。

  1. 我删除了 C:\xampp\mysql\data 中的 ibdata1 并重新启动了 XAMPP = 未解决
  2. 我删除了所有自定义数据库文件夹,只保留安装时最初存在的文件夹 = 未解决

错误日志文件显示:

2016-02-09 16:47:08 1430 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160209 16:47:08 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160209 16:47:08 [Note] InnoDB: The InnoDB memory heap is disabled
160209 16:47:08 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160209 16:47:08 [Note] InnoDB: Memory barrier is not used
160209 16:47:08 [Note] InnoDB: Compressed tables use zlib 1.2.3
160209 16:47:08 [Note] InnoDB: Not using CPU crc32 instructions
160209 16:47:08 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160209 16:47:08 [Note] InnoDB: Completed initialization of buffer pool
160209 16:47:08 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
160209 16:47:08 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
160209 16:47:08 [Note] InnoDB: Database physically writes the file full: wait...
160209 16:47:08 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
160209 16:47:08 [ERROR] Plugin 'InnoDB' init function returned error.
160209 16:47:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160209 16:47:08 [Note] Plugin 'FEEDBACK' is disabled.
160209 16:47:08 [ERROR] Unknown/unsupported storage engine: InnoDB
160209 16:47:08 [ERROR] Aborting

160209 16:47:08 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

最佳答案

在不同的论坛上询问后,我没有找到解决方案。我不得不重新安装,然后又发生了。然后我在 stackoverflow 上的某个地方发现了一个答案,即不以管理员身份启动 xampp 并将其关闭会导致 mysql 随着时间的推移而损坏。因此,转到属性并确保它始终以管理员身份运行。希望其他找到这背后原因的人得到答案。

关于mysql - XAMPP : MySQL shutdown unexpectedly INNODB warnings,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/35290796/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com