Editing /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]]
* <code>[[systemctl status mariadb]]</code>
* <code>[[mariadb-check --all-databases]]</code>
* <code>[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code>

== See also ==
* {{MariaDB}}


[[Category:MariaDB]]
@@ Line 1: / Line 1: @@
-  Note | Warning | ERROR
+  [[/var/log/mysql/]]error.log
+ 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* | grep -i ERROR
+-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.
-== ERROR ==
-* <code>[[No space left on device]]</code>
-* <code>[[is marked as crashed and should be repaired]]</code>
-* <code>[[Probably out of disk space]]</code>
--03-30  5:06:42 4395974 [ERROR] mysqld: [[Disk full]] (/tmp/#sql_1b3c_0.MAI); waiting for someone to free some space... ([[errno]]: 28 "[[No space left on device]]")
 -05-05  5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/[[searchindex]]' [[is marked as crashed and should be repaired]]
 -05-05  5:56:00 139949468755712 [Warning] Checking table:   './xxxxx/searchindex'
--12-15 19:18:32 0 [ERROR] [[InnoDB]]: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
--12-15 19:18:32 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. [[Probably out of disk space]]
--12-15 19:18:32 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
--12-15 19:18:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
--12-15 19:18:37 0 [ERROR] Plugin '[[InnoDB]]' init function returned error.
--12-15 19:18:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
--12-15 19:18:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB
--12-15 19:18:37 0 [ERROR] Aborting
--12-15 19:21:06 35 [ERROR] mysqld: Table './xxxxx/searchindex' [[is marked as crashed and should be repaired]]
-== Warning ==
- [Warning] [[Unsafe statement written to the binary log using statement format since]] [[BINLOG_FORMAT]] = STATEMENT. [[INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement]]
-== Note ==
--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.
--12-26  5:52:14 0 [Note] [[InnoDB]]: [[Starting crash recovery from checkpoint]] LSN=14814872110
 == Related terms ==
@@ Line 42: / Line 14: @@
 * <code>[[mariadb-check --all-databases]]</code>
 * <code>[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code>
-* <code>[[/usr/lib/nagios/plugins/check_mysql]]</code>
 == See also ==
-* {{InnoDB}}
 * {{MariaDB}}
 [[Category:MariaDB]]