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

From wikieduonline
Jump to navigation Jump to search
Line 1: Line 1:
 
  [[/var/log/mysql/]]error.log
 
  [[/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*
  

Revision as of 17:53, 30 August 2021

/var/log/mysql/error.log
cat /var/log/mysql/error.log | grep -v Note
zcat -f /var/log/mysql/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: