[MySQL] systemctl start mariadb 에러

[MySQL] systemctl start mariadb 에러

조금 황당한 경우이긴 하지만 mysql 이 죽어있길래 재시작을 하니 에러가 나서 확인해봤습니다.

[root@vtr html]# systemctl status mariadb

● mariadb.service - MariaDB database server

   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)

   Active: failed (Result: exit-code) since Thu 2018-10-04 16:38:06 KST; 4min 23s ago

  Process: 22597 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)

  Process: 22596 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)

  Process: 22566 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

 Main PID: 22596 (code=exited, status=0/SUCCESS)

Oct 04 16:38:04 vtr systemd[1]: Starting MariaDB database server...

Oct 04 16:38:04 vtr mariadb-prepare-db-dir[22566]: Database MariaDB is probab...

Oct 04 16:38:05 vtr mysqld_safe[22596]: 181004 16:38:05 mysqld_safe Logging ....

Oct 04 16:38:05 vtr mysqld_safe[22596]: 181004 16:38:05 mysqld_safe Starting...l

Oct 04 16:38:06 vtr systemd[1]: mariadb.service: control process exited, co...=1

Oct 04 16:38:06 vtr systemd[1]: Failed to start MariaDB database server.

Oct 04 16:38:06 vtr systemd[1]: Unit mariadb.service entered failed state.

Oct 04 16:38:06 vtr systemd[1]: mariadb.service failed.

Hint: Some lines were ellipsized, use -l to show in full.

운영중인 VPS 가 메모리가 너무 부족해서 생긴 현상인데 스왑메모리를 추가해서 해결하였습니다.

swap 늘이는 방법은 https://ivps.tistory.com/283 여기를 참고하세요~