yanqzh 发表于 2017-6-14 08:41:01

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

# /*****/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
1706148:30:02 /usr/local/mysql/bin/mysqld (mysqld 5.5.48) starting as process 20854 ...
1706148:30:02 Plugin 'FEDERATED' is disabled.
1706148:30:02 InnoDB: The InnoDB memory heap is disabled
1706148:30:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1706148:30:02 InnoDB: Compressed tables use zlib 1.2.7
1706148:30:02 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
1706148:30:02 InnoDB: Completed initialization of buffer pool
1706148:30:02 InnoDB: Fatal error: cannot allocate memory for the buffer pool
1706148:30:02 Plugin 'InnoDB' init function returned error.
1706148:30:02 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
1706148:30:02 Unknown/unsupported storage engine: InnoDB
1706148:30:02 Aborting

1706148:30:02 /usr/local/mysql/bin/mysqld: Shutdown complete

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

yanqzh 发表于 2017-6-14 08:58:53

内存2G，刚刚忘了说明

licess 发表于 2017-6-14 09:01:58

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

yanqzh 发表于 2017-6-14 19:34:12

回复 3# 的帖子

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

licess 发表于 2017-6-15 09:34:00

回复 4# 的帖子

参数都是自动优化的
页: [1]
查看完整版本: mysql经常自动结束，然后无法启动