mysql经常自动结束，然后无法启动

yanqzh

[root@ebs-47166 gxSG_32]# /*****/mysqlrestart.sh
Starting MySQL. ERROR! The server quit without updating PID file (/data/var/ebs-47166.pid).

开启错误日志如下：

170614 08:30:02 mysqld_safe Starting mysqld daemon with databases from /data/var
170614  8:30:02 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48) starting as process 20854 ...
170614  8:30:02 [Note] Plugin 'FEDERATED' is disabled.
170614  8:30:02 InnoDB: The InnoDB memory heap is disabled
170614  8:30:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170614  8:30:02 InnoDB: Compressed tables use zlib 1.2.7
170614  8:30:02 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
170614  8:30:02 InnoDB: Completed initialization of buffer pool
170614  8:30:02 InnoDB: Fatal error: cannot allocate memory for the buffer pool
170614  8:30:02 [ERROR] Plugin 'InnoDB' init function returned error.
170614  8:30:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170614  8:30:02 [ERROR] Unknown/unsupported storage engine: InnoDB
170614  8:30:02 [ERROR] Aborting

170614  8:30:02 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170614 08:30:02 mysqld_safe mysqld from pid file /data/var/ebs-47166.pid ended

yanqzh

内存2G，刚刚忘了说明

licess

按提示是无法分配内存，也就是内存不够用了，可能你其他程序占用较多
可以先调整/etc/my.conf 中 innodb_buffer_pool_size 调小些看看

yanqzh

如果是4G的内存，开启innode，应该如何配置my.cnf ?

licess

参数都是自动优化的