错误:MySQL 意外关闭.尝试在 Xampp 上启动 Mysql 时 [英] Error: MySQL shutdown unexpectedly. While Trying to start Mysql on Xampp
问题描述
我的 xampp 无法运行 mysql.互联网上的千种解决方案我已经做了，但仍然不给我解决方案.这是错误日志:
My xampp can't running mysql. Thousand solution on the internet I already do, but still don't give me the solution. This is the error log :
2018-05-30 02:14:31 1408 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.
2018-05-30 2:14:31 5128 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
****************************
2018-05-30 2:14:31 5128 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-05-30 2:14:31 5128 [Note] InnoDB: The InnoDB memory heap is disabled
2018-05-30 2:14:31 5128 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-05-30 2:14:31 5128 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-05-30 2:14:31 5128 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-30 2:14:31 5128 [Note] InnoDB: Using generic crc32 instructions
2018-05-30 2:14:31 5128 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-05-30 2:14:31 5128 [Note] InnoDB: Completed initialization of buffer pool
2018-05-30 2:14:31 5128 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-30 2:14:33 5128 [Note] InnoDB: 128 rollback segment(s) are active.
2018-05-30 2:14:33 5128 [Note] InnoDB: Waiting for purge to start
2018-05-30 2:14:33 5128 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-83.0 started; log sequence number 546092343
2018-05-30 2:14:33 6096 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x208b)
2018-05-30 2:14:33 5128 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-05-30 2:14:33 5128 [ERROR] Plugin 'Aria' init function returned error.
2018-05-30 2:14:33 5128 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-05-30 2:14:33 5128 [Note] Plugin 'FEEDBACK' is disabled.
2018-05-30 2:14:33 5128 [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-05-30 2:14:33 5128 [ERROR] Aborting
*******************************
谁能帮帮我..
推荐答案
在您的错误日志中有日志指出:
In your error log there is log which states that:
2018-05-30 2:14:33 5128 [ERROR] mysqld.exe:Aria 恢复失败.请在所有 Aria 表上运行 aria_chk -r 并删除所有aria_log.######## 文件
2018-05-30 2:14:33 5128 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
因此，根据您删除这些文件的日志，您必须转到/xampp/mysql/data/
So as per your log for removing that files you have to Go to /xampp/mysql/data/
和删除名称以aria_log开头的文件.这意味着名称以aria_log.###开头的所有文件在这里#表示任何字符串，如 00001 或 anyhting，因此在删除该文件后重新启动 xammp，它大部分时间都可以工作.
and Remove the Files which names start with aria_log. which means all the files which name start with aria_log.### here # means any string like 00001 or anyhting, so after removing that files restart xammp, it works most of the time.
这篇关于错误:MySQL 意外关闭.尝试在 Xampp 上启动 Mysql 时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
