mysql启动出错

[Sherlock_Cool]

mysql连接不上,
报警日志如下:

170710 11:15:17 [Note] C:\MySQL\MySQL Server 6.0\bin\mysqld: Shutdown complete

170710 11:20:48 InnoDB: Error: cannot allocate 2147500032 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 32390264 bytes. Operating system errno: 8
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
170710 11:21:49 [ERROR] Plugin 'InnoDB' init function returned error.
170710 11:21:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170710 11:21:49 [ERROR] Unknown/unsupported table type: INNODB
170710 11:21:49 [ERROR] Aborting

[我没有吃饭]

看提示跟内存或磁盘空间有关系吧，之前能不能启动？如果之前能启用，检查一下是不是磁盘格式限制了数据库文件增长

[rucypli]

innodb的bufferpool改小点试试

[LongRui888]

170710 11:20:48 InnoDB: Error: cannot allocate 2147500032 bytes of 170710 11:21:49 [ERROR] Plugin 'InnoDB' init function returned error. 170710 11:21:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 170710 11:21:49 [ERROR] Unknown/unsupported table type: INNODB 170710 11:21:49 [ERROR] Aborting 上面说的是不能分配2G左右的内存，后面几条是innodb引擎返回错误，不能注册innodb引擎，你看看你的机器上有2G物理内存吗，是不是分配的太大了。。。