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.

声明:本站所有文章和图片,如无特殊说明,均为原创发布。商业转载请联系作者获得授权,非商业转载请注明出处。
随机推荐
ES6 Promise 和 async/await 教程
Debian11 安装笔记2:编译安装PHP
JavaScript 基本语法
JavaScript 事件处理程序
WordPress 后台添加菜单
WordPress 中如何在主题和插件中使用
Express 使用 method-override 处理动词覆盖
WordPress 插入文章函数 wp_insert_post()