Code: Select all
root@DietPi:~# rm /var/lib/mysql/ib_logfile0
root@DietPi:~# rm /var/lib/mysql/ib_logfile1
Here is the status of the Mariadb service:
Code: Select all
root@DietPi:~# systemctl status mariadb
● mariadb.service - MariaDB 10.1.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset:
enabled)
Active: active (running) since Tue 2020-01-21 13:18:52 MST; 3s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2079 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_STAR
T_POSITION (code=exited, status=0/SUCCESS)
Process: 2077 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUC
CESS)
Process: 2023 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR
= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environme
nt _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 2018 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START
_POSITION (code=exited, status=0/SUCCESS)
Process: 2015 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/ru
n/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2048 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 26 (limit: 4915)
CGroup: /system.slice/mariadb.service
└─2048 /usr/sbin/mysqld
Jan 21 13:18:51 DietPi mysqld[2048]: InnoDB: for more information.
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1995968304 [Note] InnoD
B: 128 rollback segment(s) are active.
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1995968304 [Note] InnoD
B: Waiting for purge to start
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1995968304 [Note] InnoD
B: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence nu
mber 1070602161
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1283453760 [Note] InnoD
B: Dumping buffer pool(s) not yet started
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1995968304 [Note] Plugi
n 'FEEDBACK' is disabled.
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1995968304 [Note] Serve
r socket created on IP: '::'.
Jan 21 13:18:51 DietPi mysqld[2048]: 2020-01-21 13:18:51 1995968304 [Note] /usr/
sbin/mysqld: ready for connections.
Jan 21 13:18:51 DietPi mysqld[2048]: Version: '10.1.38-MariaDB-0+deb9u1' socket
: '/var/run/mysqld/mysqld.sock' port: 3306 Raspbian 9.0
Jan 21 13:18:52 DietPi systemd[1]: Started MariaDB 10.1.38 database server.