Server Configuration Centos7.0 + 0.5g memory + 1 cpuweb server configuration PHP5.4.16 + Nginx1.6.3 + MariaDB5.5.44 run a shadowsocks and a wordpress on it, the database configuration file uses the my-small.cnf, but MariaDB often fails, so please make a good request... server Configuration
Centos7.0 + 0.5g memory + 1 CPU
Web Server Configuration
PHP 5.4.16 + Nginx 1.6.3 + MariaDB 5.5.44
I ran a shadowsocks and a wordpress on it, and the database configuration file used a my-small.cnf, but MariaDB often crashed, so I had a good configuration.
Restart MariaDb after the database fails.
Start
Systemctl start mariadb
Result
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.
Run
Systemctl status mariadb. service
Mariadb. service-MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb. service; enabled) Active: failed (Result: exit-code) since 3 00:42:58 EST; 14 s ago Process: 10969 ExecStartPost =/usr/libexec/mariadb-wait-ready $ MAINPID (code = exited, status = 1/FAILURE) Process: 10968 ExecStart =/usr/bin/mysqld_safe -- basedir =/usr (code = exited, status = 0/SUCCESS) Process: 10941 ExecStartPre =/usr/libexec/mariadb-prepare-db-dir % n (code = exited, status = 0/SUCCESS) Main PID: 10968 (code = exited, status = 0/SUCCESS) November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Logging to '/var/lib/mysql/jack. err '. november 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe mysqld from pid file/var/lib/mysql/jack. pid ended November 11 00:42:58 jack systemd [1]: mariadb. service: control process exited, code = exited status = 111 00:42:58 jack has EMD [1]: Failed to start MariaDB database server. November 11 00:42:58 jack has EMD [1]: Unit mariadb. service entered failed state.
Run
Journalctl-xn
-- Logs begin at 06:23:57 EST, end at 00:42:58 EST. -- November 11 00:27:21 jack sshd [10936]: Failed password for invalid user pi from 104.233.81.149 port 53083 ssh2 November 11 00:27:21 jack sshd [10936]: Received disconnect from 104.233.81.149: 11: bye [preauth] November 11 00:40:43 jack kernel: Ack 2451881106 before 2451884026: 245189862611 00:42:57 jack mongoemd [1]: Starting MariaDB database server... -- Subject: Unit mariadb. service has begun with start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel-- Unit mariadb. service has begun starting up. November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Logging to '/var/lib/mysql/jack. err '. november 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe mysqld from pid file/var/lib/mysql/jack. pid ended November 11 00:42:58 jack systemd [1]: mariadb. service: control process exited, code = exited status = 111 00:42:58 jack systemd [1]: Failed to start MariaDB database server. -- Subject: Unit mariadb. service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel-- Unit mariadb. service has failed. -- The result is failed. November 11 00:42:58 jack lost EMD [1]: Unit mariadb. service entered failed state.
Reply content:
Server Configuration
Centos7.0 + 0.5g memory + 1 CPU
Web Server Configuration
PHP 5.4.16 + Nginx 1.6.3 + MariaDB 5.5.44
I ran a shadowsocks and a wordpress on it, and the database configuration file used a my-small.cnf, but MariaDB often crashed, so I had a good configuration.
Restart MariaDb after the database fails.
Start
Systemctl start mariadb
Result
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.
Run
Systemctl status mariadb. service
Mariadb. service-MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb. service; enabled) Active: failed (Result: exit-code) since 3 00:42:58 EST; 14 s ago Process: 10969 ExecStartPost =/usr/libexec/mariadb-wait-ready $ MAINPID (code = exited, status = 1/FAILURE) Process: 10968 ExecStart =/usr/bin/mysqld_safe -- basedir =/usr (code = exited, status = 0/SUCCESS) Process: 10941 ExecStartPre =/usr/libexec/mariadb-prepare-db-dir % n (code = exited, status = 0/SUCCESS) Main PID: 10968 (code = exited, status = 0/SUCCESS) November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Logging to '/var/lib/mysql/jack. err '. november 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe mysqld from pid file/var/lib/mysql/jack. pid ended November 11 00:42:58 jack systemd [1]: mariadb. service: control process exited, code = exited status = 111 00:42:58 jack has EMD [1]: Failed to start MariaDB database server. November 11 00:42:58 jack has EMD [1]: Unit mariadb. service entered failed state.
Run
Journalctl-xn
-- Logs begin at 06:23:57 EST, end at 00:42:58 EST. -- November 11 00:27:21 jack sshd [10936]: Failed password for invalid user pi from 104.233.81.149 port 53083 ssh2 November 11 00:27:21 jack sshd [10936]: Received disconnect from 104.233.81.149: 11: bye [preauth] November 11 00:40:43 jack kernel: Ack 2451881106 before 2451884026: 245189862611 00:42:57 jack mongoemd [1]: Starting MariaDB database server... -- Subject: Unit mariadb. service has begun with start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel-- Unit mariadb. service has begun starting up. November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Logging to '/var/lib/mysql/jack. err '. november 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql November 11 00:42:57 jack mysqld_safe [10968]: 151111 00:42:57 mysqld_safe mysqld from pid file/var/lib/mysql/jack. pid ended November 11 00:42:58 jack systemd [1]: mariadb. service: control process exited, code = exited status = 111 00:42:58 jack systemd [1]: Failed to start MariaDB database server. -- Subject: Unit mariadb. service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel-- Unit mariadb. service has failed. -- The result is failed. November 11 00:42:58 jack lost EMD [1]: Unit mariadb. service entered failed state.