Difference between revisions of "/var/log/mysql/error.log (MariaDB)"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
cat /var/log/mysql/error.log | grep -v [[Note]] | cat /var/log/mysql/error.log | grep -v [[Note]] | ||
[[zcat -f]] /var/log/mysql/error* | [[zcat -f]] /var/log/mysql/error* | ||
| − | zcat -f /var/log/mysql/error* | grep -i | + | 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: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. | ||
Revision as of 18:51, 1 June 2022
/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
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/
Advertising:
