140727 21:04:38 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140727 21:04:38 [Note] Plugin 'FEDERATED' is disabled. 140727 21:04:38 InnoDB: The InnoDB memory heap is disabled 140727 21:04:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140727 21:04:38 InnoDB: Compressed tables use zlib 1.2.3.4 140727 21:04:38 InnoDB: Initializing buffer pool, size = 128.0M 140727 21:04:38 InnoDB: Completed initialization of buffer pool 140727 21:04:38 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140727 21:04:38 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140727 21:04:39 InnoDB: Waiting for the background threads to start 140727 21:04:40 InnoDB: 5.5.38 started; log sequence number 195543902 140727 21:04:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140727 21:04:40 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140727 21:04:40 [Note] Server socket created on IP: '0.0.0.0'. 140727 21:04:41 [Note] Event Scheduler: Loaded 0 events 140727 21:04:41 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 140727 21:05:16 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140727 21:05:16 [Note] Plugin 'FEDERATED' is disabled. 140727 21:05:16 InnoDB: The InnoDB memory heap is disabled 140727 21:05:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140727 21:05:16 InnoDB: Compressed tables use zlib 1.2.3.4 140727 21:05:17 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140727 21:05:21 InnoDB: Completed initialization of buffer pool 140727 21:05:21 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140727 21:05:21 [ERROR] Plugin 'InnoDB' init function returned error. 140727 21:05:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140727 21:05:21 [ERROR] Unknown/unsupported storage engine: InnoDB 140727 21:05:21 [ERROR] Aborting
140727 21:05:22 [Note] /usr/sbin/mysqld: Shutdown complete 140727 21:05:23 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140727 21:05:23 [Note] Plugin 'FEDERATED' is disabled. 140727 21:05:23 InnoDB: The InnoDB memory heap is disabled 140727 21:05:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140727 21:05:23 InnoDB: Compressed tables use zlib 1.2.3.4 140727 21:05:23 InnoDB: Initializing buffer pool, size = 128.0M 140727 21:05:23 InnoDB: Completed initialization of buffer pool 140727 21:05:23 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140727 21:05:23 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140727 21:05:23 InnoDB: Waiting for the background threads to start 140727 21:05:24 InnoDB: 5.5.38 started; log sequence number 195543912 140727 21:05:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140727 21:05:24 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140727 21:05:24 [Note] Server socket created on IP: '0.0.0.0'. 140727 21:05:24 [Note] Event Scheduler: Loaded 0 events 140727 21:05:24 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 140727 21:06:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140727 21:06:07 [Note] Plugin 'FEDERATED' is disabled. 140727 21:06:07 InnoDB: The InnoDB memory heap is disabled 140727 21:06:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140727 21:06:07 InnoDB: Compressed tables use zlib 1.2.3.4 140727 21:06:07 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140727 21:06:07 InnoDB: Completed initialization of buffer pool 140727 21:06:07 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140727 21:06:07 [ERROR] Plugin 'InnoDB' init function returned error.
InnoDB:Fatalerror:cannotallocatememoryfor thebufferpool
楼主看不懂英文?不会用搜索引擎?
回复 @leo108: @leo108而且我不是没有百度啊,问题是众说纷纭啊……如果你觉得我的态度有问题,我可以反思我表达的方式。我真的一点mysql的挑错经验都没有。而且确实是正在百度。 @leo108而且你的语气是怎么回事? @leo108问题是我一点解决经验都没有,我在问你细节。给层主回血 只要删除MySQL目录下的ib_logfile0和ib_logfile1两个文件,就可以解决问题了。回复 @Tuesday:请问该如何解决呢?这可能成坑,注意innodb引擎.我觉得导出数据,重做一下mysql比较安全.这个……重做过……没有解决http://www.oschina.net/question/2962_115815
我觉得问问题之前一定要先做做功课,OSC搜一下就发现有人问过一样的问题
真心没搜到这个……会不会是 innodb_buffer_pool_size设置的太高了,超过了你的机器内存,请尝试降低该内存配置。
使用innodb最好还是根据机器修改默认配置哦。
之前没有设置过这个属性会不会是 innodb_buffer_pool_size设置的太高了,超过了你的机器内存,请尝试降低该内存配置。
使用innodb最好还是根据机器修改默认配置哦。
之前没有修改过版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。