The best LNMP is configured on the Centos7.0 of 0.5G memory

Server Configuration

centos7.0+0.5g Memory +1cpu

Web server Configuration

PHP 5.4.16 + Nginx 1.6.3+mariadb 5.5.44

Ran a shadowsocks and a WordPress, the database configuration file using MY-SMALL.CNF, but mariadb often hang out, so to find a good configuration.

After the database has been hung, restart MARIADB

Start

Systemctl Start mariadb

Results

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:f Ailed (Result:exit-code) since three 2015-11-11 00:42:58 EST; 14s 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 00:42:57 Jack My sqld_safe[10968]: 151111 00:42:57 mysqld_safe starting mysqld daemon with databases From/var/lib/mysql11 month 00:42:57 Jac K mysqld_safe[10968]: 151111 00:42:57 mysqld_safe mysqld from PID file/var/lib/mysql/jack.pid ended11 month 00:42:58 Jack S YSTEMD[1]: Mariadb.service:control process exited, code=exited status=111 month 00:42:58 Jack SYSTEMD[1]: Failed to start MariaDB database server.11 month 00:42:58 Jack Systemd[1]: Unit Mariadb.service entered Failed St Ate.

Run

Journalctl-xn

 --Logs begin at 2015-11-08 06:23:57 EST and end at three 2015-11-11 00:42:58 EST.--11 month 00:27:21 Jack sshd[10936]: Failed  Password for invalid user pi from 104.233.81.149 port 53083 ssh211 month 00:27:21 Jack sshd[10936]: Received disconnect from 104.233.81.149:11:bye Bye [preauth]11 month 00:40:43 Jack Kernel:ack 2451881106 before 2,451,884,026:245,189,862,611 months 11 00:42 : £ º Jack systemd[1]: Starting MariaDB database server...--Subject:unit mariadb.service have begun with start-up--Defined -by:systemd--support:http://lists.freedesktop.org/mailman/listinfo/systemd-devel--Unit Mariadb.service has begun  Starting up.11 month 00:42:57 Jack mysqld_safe[10968]: 151111 00:42:57 mysqld_safe Logging to '/var/lib/mysql/jack.err '. November 00:42:57 Jack mysqld_safe[10968]: 151111 00:42:57 mysqld_safe starting mysqld daemon with databases from/var/lib/mysq L11 month 00:42:57 Jack mysqld_safe[10968]: 151111 00:42:57 mysqld_safe mysqld from PID file/var/lib/mysql/jack.pid ended11 Month 00:42:58 Jack Systemd[1]: Mariadb.service:control process exited, code=exited status=111 month 00:42:58 Jack Systemd[1]: Failed to start mariadb dat Abase server.--subject:unit Mariadb.service has failed--defined-by:systemd--support:http://lists.freedesktop.org/ mailman/listinfo/systemd-devel--Unit Mariadb.service have failed.--the result is failed.11 month one 00:42:58 Jack Systemd[1]: Unit Mariadb.service entered failed state.

Reply content:

Server Configuration

centos7.0+0.5g Memory +1cpu

Web server Configuration

PHP 5.4.16 + Nginx 1.6.3+mariadb 5.5.44

Ran a shadowsocks and a WordPress, the database configuration file using MY-SMALL.CNF, but mariadb often hang out, so to find a good configuration.

After the database has been hung, restart MARIADB

Start

Systemctl Start mariadb

Results

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:f Ailed (Result:exit-code) since three 2015-11-11 00:42:58 EST; 14s 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 00:42:57 Jack My sqld_safe[10968]: 151111 00:42:57 mysqld_safe starting mysqld daemon with databases From/var/lib/mysql11 month 00:42:57 Jac K mysqld_safe[10968]: 151111 00:42:57 mysqld_safe mysqld from PID file/var/lib/mysql/jack.pid ended11 month 00:42:58 Jack S YSTEMD[1]: Mariadb.service:control process exited, code=exited status=111 month 00:42:58 Jack SYSTEMD[1]: Failed to start MariaDB database server.11 month 00:42:58 Jack Systemd[1]: Unit Mariadb.service entered Failed St Ate.

Run

Journalctl-xn

 --Logs begin at 2015-11-08 06:23:57 EST and end at three 2015-11-11 00:42:58 EST.--11 month 00:27:21 Jack sshd[10936]: Failed  Password for invalid user pi from 104.233.81.149 port 53083 ssh211 month 00:27:21 Jack sshd[10936]: Received disconnect from 104.233.81.149:11:bye Bye [preauth]11 month 00:40:43 Jack Kernel:ack 2451881106 before 2,451,884,026:245,189,862,611 months 11 00:42 : £ º Jack systemd[1]: Starting MariaDB database server...--Subject:unit mariadb.service have begun with start-up--Defined -by:systemd--support:http://lists.freedesktop.org/mailman/listinfo/systemd-devel--Unit Mariadb.service has begun  Starting up.11 month 00:42:57 Jack mysqld_safe[10968]: 151111 00:42:57 mysqld_safe Logging to '/var/lib/mysql/jack.err '. November 00:42:57 Jack mysqld_safe[10968]: 151111 00:42:57 mysqld_safe starting mysqld daemon with databases from/var/lib/mysq L11 month 00:42:57 Jack mysqld_safe[10968]: 151111 00:42:57 mysqld_safe mysqld from PID file/var/lib/mysql/jack.pid ended11 Month 00:42:58 Jack Systemd[1]: Mariadb.service:control process exited, code=exited status=111 month 00:42:58 Jack Systemd[1]: Failed to start mariadb dat Abase server.--subject:unit Mariadb.service has failed--defined-by:systemd--support:http://lists.freedesktop.org/ mailman/listinfo/systemd-devel--Unit Mariadb.service have failed.--the result is failed.11 month one 00:42:58 Jack Systemd[1]: Unit Mariadb.service entered failed state.

