Question

MySQL服务启动不了，提示意外终止

141013 8:58:24 InnoDB: Error: cannot allocate 2147500032 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 30344740 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
141013 8:59:24 [ERROR] Default storage engine (InnoDB) is not available
141013 8:59:24 [ERROR] Aborting

141013 8:59:24 [Note] E:\MyEclipse\Server\bin\mysqld-nt: Shutdown complete

Answer 1

InnoDB: Fatal error: cannot allocate the memory for the buffer pool

根据这个提示是内存分配不足，第一二行提示分配的内存大于innoDB呢uc，检查my.ini配置文件

追问

my.ini看不懂，能说详细一点吗？谢谢

追答

你是什么平台？看看这个innodb_buffer_pool_size=672M 是多大？提示你的内存分配太多

追问

innodb_buffer_pool_size=2G