我在DigitalOcean上有一个512MB的VPS,运行的是最新的CentOS 7。MySQL 5.6是使用以下命令安装的:
yum localinstall http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server
我在我的my.cnf中使用了以下代码
[mysql]
# CLIENT #
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
# GENERAL #
user = mysql
default-storage-engine = MyISAM
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysql.pid
# MyISAM #
key-buffer-size = 128M
myisam-recover = FORCE,BACKUP
# SAFETY #
max-allowed-packet = 16M
max-connect-errors = 1000000
# DATA STORAGE #
datadir = /var/lib/mysql/
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 100
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 100
# LOGGING #
log-error = /var/lib/mysql/mysql-error.log
log-queries-not-using-indexes = 0
slow-query-log = 0
slow-query-log-file = /var/lib/mysql/mysql-slow.log
当我尝试使用这些命令变体启动MySQL时,什么也没有发生:
[root@server ~]# /etc/init.d/mysql start
-bash: /etc/init.d/mysql: No such file or directory
[root@server ~]# /etc/init.d/mysqld start
-bash: /etc/init.d/mysqld: No such file or directory
因此,我尝试了这种方法:
[root@server ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
它被困在这条消息上,什么也没有发生。我已经检查了ps aux | grep mysql,但没有看到服务正在运行:
[root@server ~]# ps aux | grep mysql
root 10688 0.0 0.1 115212 644 ? Ss 20:08 0:00 /bin/bash /usr/bin/mysql-systemd-start post
root 12646 0.0 0.2 132520 1396 pts/0 S+ 20:16 0:00 /bin/systemctl start mysql.service
root 12852 0.0 0.1 112640 960 pts/1 S+ 20:17 0:00 grep --color=auto mysql
有什么想法吗?
发布于 2015-08-22 01:28:37
如果没有交换,MySQL 5.6将无法在5.12M虚拟机上启动。错误很可能是内存不足。您可以选择:
发布于 2017-10-24 15:21:50
我认为您需要启用交换内存。尝尝这个。
使用CentOS 7启用交换内存内存
$ sudo dd if=/dev/zero of=/swapfile count=4096 bs=1MiB
$ sudo chmod 600 /swapfile
$ sudo mkswap /swapfile
$ sudo swapon /swapfile
$ swapon -s
https://stackoverflow.com/questions/31908449
复制相似问题