欢迎各位兄弟 发布技术文章

这里的技术是共享的

You are here

mysql 无法启动 Using mutexes to ref count buffer pool pages 有大用 有大大用

2018-06-28 12:41:07 1800 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2018-06-28 12:41:07 1800 [Note] InnoDB: The InnoDB memory heap is disabled

2018-06-28 12:41:07 1800 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2018-06-28 12:41:07 1800 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier

2018-06-28 12:41:07 1800 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-06-28 12:41:07 1800 [Note] InnoDB: Using generic crc32 instructions

2018-06-28 12:41:07 1800 [Note] InnoDB: Initializing buffer pool, size = 256.0M

2018-06-28 12:41:07 1800 [Note] InnoDB: Completed initialization of buffer pool

2018-06-28 12:41:07 1800 [Note] InnoDB: Highest supported file format is Barracuda.

2018-06-28 12:41:07 1800 [Note] InnoDB: 128 rollback segment(s) are active.

2018-06-28 12:41:07 1800 [Note] InnoDB: Waiting for purge to start

2018-06-28 12:41:07 1800 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.38-83.0 started; log sequence number 3383558

2018-06-28 12:41:07 7148 [Note] InnoDB: Dumping buffer pool(s) not yet started

Cannot find checkpoint record at LSN (1,0x22c7)


2018-06-28 12:41:07 1800 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files

2018-06-28 12:41:07 1800 [ERROR] Plugin 'Aria' init function returned error.

2018-06-28 12:41:07 1800 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2018-06-28 12:41:07 1800 [Note] Plugin 'FEEDBACK' is disabled.

2018-06-28 12:41:07 1800 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

2018-06-28 12:41:07 1800 [ERROR] Aborting



These were the logs:

[ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files [ERROR] Plugin 'Aria' init function returned error. [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2 Answers 正确答案

The solution is Removing the aria_log_control file allowed MariaDB to start again. You can find this file in \xampp\mysql\data. Then restart or start xammp.

If XAMPP generated following logs

[Note] Plugin 'FEEDBACK' is disabled.

[ERROR] j:\xampp\mysql\bin\mysqld.exe: unknown option '--skip-federated'

[ERROR] Aborting

Try to run MySQL with the following command

**mysqld.exe --skip-federated**

Hope this helps!! Good Luck!!

来自  https://stackoverflow.com/questions/41170937/how-to-fix-error-mysql-shutdown-unexpectedly-on-xampp-d...


普通分类: