ブログ - Raspbian 9.4上のMariaDBの実行状況確認，停止，起動
さらっとインストールされたのだけれど，実は自動起動している．その状態を確認．
active (running)となっていて動いていることが確認．
停止して，再度ステータスを確認してみる．
停止されてますね．deadだなんて．．．
今度は起動してステータスを確認．
あっさり目ですね．
root@raspberrypi:/home/pi# sudo service mysql status🆑
● mariadb.service - MariaDB 10.1.35 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running)🈁 since Sun 2018-09-02 01:59:41 JST; 25min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 3235 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─3235 /usr/sbin/mysqld
9月 02 01:59:38 raspberrypi systemd[1]: Starting MariaDB 10.1.35 database server...
9月 02 01:59:40 raspberrypi mysqld[3235]: 2018-09-02 1:59:40 1996025872 [Note] /usr/sbin/mysqld (mysqld 1
9月 02 01:59:41 raspberrypi systemd[1]: Started MariaDB 10.1.35 database server.
root@raspberrypi:/home/pi#
停止して，再度ステータスを確認してみる．
root@raspberrypi:/home/pi# sudo service mysql stop🆑
root@raspberrypi:/home/pi#
root@raspberrypi:/home/pi# sudo service mysql status🆑
● mariadb.service - MariaDB 10.1.35 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: inactive (dead)🈁 since Sun 2018-09-02 02:27:59 JST; 3s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 3235 (code=exited, status=0/SUCCESS)
Status: "MariaDB server is down"
9月 02 01:59:38 raspberrypi systemd[1]: Starting MariaDB 10.1.35 database server...
9月 02 01:59:40 raspberrypi mysqld[3235]: 2018-09-02 1:59:40 1996025872 [Note] /usr/sbin/mysqld (mysqld 1
9月 02 01:59:41 raspberrypi systemd[1]: Started MariaDB 10.1.35 database server.
9月 02 02:27:57 raspberrypi systemd[1]: Stopping MariaDB 10.1.35 database server...
9月 02 02:27:59 raspberrypi systemd[1]: Stopped MariaDB 10.1.35 database server.
root@raspberrypi:/home/pi#
今度は起動してステータスを確認．
root@raspberrypi:/home/pi# sudo service mysql start🆑
root@raspberrypi:/home/pi#
root@raspberrypi:/home/pi# sudo service mysql status🆑
● mariadb.service - MariaDB 10.1.35 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running) since Sun 2018-09-02 02:29:36 JST; 4s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3607 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, s
Process: 3605 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Process: 3479 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galer
Process: 3475 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, st
Process: 3472 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, sta
Main PID: 3578 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─3578 /usr/sbin/mysqld
9月 02 02:29:33 raspberrypi systemd[1]: Starting MariaDB 10.1.35 database server...
9月 02 02:29:35 raspberrypi mysqld[3578]: 2018-09-02 2:29:35 1996419088 [Note] /usr/sbin/mysqld (mysqld 1
9月 02 02:29:36 raspberrypi systemd[1]: Started MariaDB 10.1.35 database server.
root@raspberrypi:/home/pi#
