/var/log/mysql/error.log (MariaDB)

/var/log/mysql/error.log
cat /var/log/mysql/error.log | grep -v Note
zcat -f /var/log/mysql/error*
zcat -f /var/log/mysql/error* | grep -i ERROR

2020-05-05  5:55:58 139949469387904 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-05-05  5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/searchindex' is marked as crashed and should be repaired
2020-05-05  5:56:00 139949468755712 [Warning] Checking table:   './xxxxx/searchindex'

Related terms

• MariaDB versions
• systemctl status mariadb
• mariadb-check --all-databases
• /etc/mysql/mariadb.conf.d/50-server.cnf

See also

• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306, /etc/mysql/