Plugin 'InnoDB' init function returned error
kevin.Zhu 发布于：2013-9-21 11:06 分类：Mysql 有 31 人浏览，获得评论 0 条
mysql启动错误日志出现以下错误
# tail -f /opt/mysql/var/localhost.localdomain.err
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
100823 11:20:08 [ERROR] Plugin 'InnoDB' init function returned error.
100823 11:20:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100823 11:20:08 InnoDB: Error: cannot allocate 2147500032 bytes of
InnoDB: memory with malloc! Total allocated memory
100823 11:20:08 [Note] Event Scheduler: Loaded 0 events
100823 11:20:08 [Note] /opt/mysql/libexec/mysqld: ready for connections.
Version: '5.1.39-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
登录mysql,无innodb引擎
mysql>show engines;
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
4 rows in set (0.00 sec)
原因:/etc/my.cnf 配置文件里
innodb_buffer_pool_size=2G
由于内存不足,