You are here
mysql运行一段时间后自动停止 有大用
星期二, 2018-06-26 00:57 — adminshiping1
10
140118 14:17:30 [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.
140118 14:17:30 [Note] Plugin 'FEDERATED' is disabled.
140118 14:17:30 InnoDB: The InnoDB memory heap is disabled
140118 14:17:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140118 14:17:30 InnoDB: Compressed tables use zlib 1.2.3.4
140118 14:17:30 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140118 14:17:30 InnoDB: Completed initialization of buffer pool
140118 14:17:30 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140118 14:17:30 [ERROR] Plugin 'InnoDB' init function returned error.
140118 14:17:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140118 14:17:30 [ERROR] Unknown/unsupported storage engine: InnoDB
140118 14:17:30 [ERROR] Aborting
140118 14:17:30 [Note] Plugin 'FEDERATED' is disabled.
140118 14:17:30 InnoDB: The InnoDB memory heap is disabled
140118 14:17:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140118 14:17:30 InnoDB: Compressed tables use zlib 1.2.3.4
140118 14:17:30 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140118 14:17:30 InnoDB: Completed initialization of buffer pool
140118 14:17:30 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140118 14:17:30 [ERROR] Plugin 'InnoDB' init function returned error.
140118 14:17:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140118 14:17:30 [ERROR] Unknown/unsupported storage engine: InnoDB
140118 14:17:30 [ERROR] Aborting
140118 14:17:30 [Note] /usr/sbin/mysqld: Shutdown complete
最佳答案
1、根据你警告得知: 内存不够用，启动不了MySQL
2、再看看当前的内存使用情况：free -m
3、把“innodb_buffer_pool_size”改小，重启就可以了。
来自 https://zhidao.baidu.com/question/303780951548443244.html
普通分类: