Mysql无法启动 使用GPT Drive

错误日志:
160328 11:23:28  InnoDB: Initializing buffer pool, size = 45.0M
160328 11:23:28  InnoDB: Completed initialization of buffer pool
160328 11:23:28  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.1/en/operating-system-error-codes.html
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.

解决方法:
配置文件加入: innodb_flush_method=normal

参考来源:
http://bugs.mysql.com/bug.php?id=28913
差不多是这个样子的,The main reason to use GPT is that it allows for drives > 2TB.  Because of the drive's large size, the OS defaults to a larger block size than the default 4096 bytes.This in turn breaks MySQL, as by default it does direct writes to the drive w/o caching (as it has its own internal caching).Windows requires non-cached disk writes to be a multiple of the block size.

修改时间 2016-03-28

真诚赞赏,手留余香
赞赏
随机推荐
Naxsi 的 MainRule
Photoshop 色彩基础
PS手绘20171012
vue-router的几种使用方式
PHP OpenSSL扩展 - 对称加密
tar打包与解压
Node.js 事件触发器模块 events
MySQL 生成随机整数
使用 linear-gradient 创建渐变背景色的背景
Base64