---

121027  0:04:52  InnoDB: Initializing buffer pool, size = 2.0G
121027  0:04:52  InnoDB: Error: cannot allocate 2097168384 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 48401272 bytes. Operating system errno: 12
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...
121027  0:05:53InnoDB: Fatal error: cannot allocate the memory for the buffer pool


調整 my.cnf

可能是 innodb_buffer_pool_size = 2G 設太大，改成

innodb_buffer_pool_size = 1G

參考
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html



--
※ 作者: Knuckles 時間: 2012-10-27 00:49:57