mysql服务器安装配置失败或无法启动服务 [英] configuration of mysql server installation failed OR can't start the service

问题描述

我正在安装mysql服务器5.6，但是当涉及到安装配置时，它在尝试启动服务时很烂 当我取消并尝试从服务"开始时，它说: 错误1067:程序意外终止.

这是我的.err:

2014-03-17 20:42:10 1372 [Note] Plugin 'FEDERATED' is disabled.
2014-03-17 20:42:10 fe0 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.
2014-03-17 20:42:10 1372 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-17 20:42:10 1372 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-17 20:42:10 1372 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-17 20:42:10 1372 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-17 20:42:10 1372 [Note] InnoDB: Initializing buffer pool, size = 39.0M
2014-03-17 20:42:10 1372 [Note] InnoDB: Completed initialization of buffer pool
2014-03-17 20:42:10 1372 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-17 20:42:10 fe0  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2014-03-17 20:42:10 1372 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS     error 187. Cannot continue operation

解决方案

解决方案:

将此行添加到配置文件中(programData中的my.ini ...)

innodb_flush_method=normal

http://bugs.mysql.com/bug.php?id=28913

I'm installing mysql server 5.6 but when it comes to installing configuration it sucks on attempting to start service and when I cancel and try to start from Services it says: Error 1067: The program terminated unexpectedly.

and here's my .err:

2014-03-17 20:42:10 1372 [Note] Plugin 'FEDERATED' is disabled.
2014-03-17 20:42:10 fe0 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.
2014-03-17 20:42:10 1372 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-17 20:42:10 1372 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-17 20:42:10 1372 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-17 20:42:10 1372 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-17 20:42:10 1372 [Note] InnoDB: Initializing buffer pool, size = 39.0M
2014-03-17 20:42:10 1372 [Note] InnoDB: Completed initialization of buffer pool
2014-03-17 20:42:10 1372 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-17 20:42:10 fe0  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2014-03-17 20:42:10 1372 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS     error 187. Cannot continue operation

解决方案

solution:

add this line to config file (my.ini in programData...)

innodb_flush_method=normal

http://bugs.mysql.com/bug.php?id=28913

这篇关于mysql服务器安装配置失败或无法启动服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！