Difference between revisions of "/var/log/mysql/error.log (MariaDB)"

From wikieduonline
Jump to navigation Jump to search
Line 6: Line 6:
 
  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.
  
  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 [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'
 
  2020-05-05  5:56:00 139949468755712 [Warning] Checking table:  './xxxxx/searchindex'
  

Revision as of 05:33, 22 September 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

Advertising: