原则《64位操作系统需要安装64位数据库》

数据库安装基本原则，64位操作系统，安装64位数据库。

2018-09-17 21:32:01 5676 [Note] Plugin 'FEDERATED' is disabled.
2018-09-17 21:32:01 5676 [ERROR] innobase_buffer_pool_size can't be over 4GB on 32-bit systems
2018-09-17 21:32:01 5676 [ERROR] Plugin 'InnoDB' init function returned error.
2018-09-17 21:32:01 5676 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-09-17 21:32:01 5676 [ERROR] Unknown/unsupported storage engine: Innodb
2018-09-17 21:32:01 5676 [ERROR] Aborting

修改innodb_buffer_pool_size后报错

2018-09-17 21:46:42 5140 [Note] Plugin 'FEDERATED' is disabled.
2018-09-17 21:46:42 5140 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-09-17 21:46:42 5140 [Note] InnoDB: The InnoDB memory heap is disabled
2018-09-17 21:46:42 5140 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-09-17 21:46:42 5140 [Note] InnoDB: Memory barrier is not used
2018-09-17 21:46:42 5140 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-17 21:46:42 5140 [Note] InnoDB: Not using CPU crc32 instructions
2018-09-17 21:46:42 5140 [Note] InnoDB: Initializing buffer pool, size = 2.9G
InnoDB: VirtualAlloc(138641408 bytes) failed; Windows error 8
2018-09-17 21:46:43 5140 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-09-17 21:46:43 5140 [ERROR] Plugin 'InnoDB' init function returned error.
2018-09-17 21:46:43 5140 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-09-17 21:46:43 5140 [ERROR] Unknown/unsupported storage engine: Innodb
2018-09-17 21:46:43 5140 [ERROR] Aborting

转载于:https://blog.51cto.com/roidba/2176424