Error Log for MariaDB Community Server 10.2
MariaDB Community Server 10.2 writes log messages to its error log.
Reference material is available for MariaDB Community Server 10.2.
The error log is intended for:
Monitoring the ES system status
Diagnosing problems with queries
Diagnosing communication problems between Galera Cluster nodes
Diagnosing connection failures
The error log uses the following log format:
timestamp thread id [logging level] message
The fields in each log message are:
The timestamp for the log message in the format
The thread ID
The log level for the log message
The log message.
The error log uses the following log levels in the
logging level field:
By default, the error log is located in the data directory defined by the datadir system variable, and the error log's file name is
HOSTNAME is the system's host name.
You can determine the error log's file name and location by querying the log_error system variable:
SHOW GLOBAL VARIABLES LIKE 'log_error';
Several aspects of the error log are configurable.
Configure the Path
The path to the error log is configured by setting the log_error system variable.
The system variable can be set in a configuration file:
The error log will be created in the data directory defined by the datadir system variable.
The error log can be placed outside of the data directory by setting the log_error system variable to the absolute path of the desired location:
If the log_error system variable is set, but no value is provided, the path to the error log is set to
HOSTNAME is the system's host name:
[mariadb] # base name on the system's host name log_error