Search code examples
mysqlxamppinnodb

XAMPP : MySQL shutdown unexpectedly INNODB warnings

Everything was working fine but suddenly MySQL stopped working and shuts down unexpectedly before starting. I tried various solutions based on other stack overflow answers.

  1. I deleted ibdata1 in C:\xampp\mysql\data and restarted XAMPP = Not Resolved
  2. I deleted all the custom database folders and only kept those that were there initially when installed = Not Resolved

Error Log File Says:

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
Solution

  • After asking on different forums I found no solution. I had to reinstall and it happened again. Then I came across an answer somewhere on stackoverflow, that not starting xampp as administrator and shutting it down causes mysql to corrupt over time. So go to properties and make sure it will always run as administrator. Hope others finding the reason behind this get the answer.