Logging for MariaDB Xpand

Overview

Xpand's server logs enable users and Customer Support to understand the queries and events that occur on a Xpand cluster.

Directory

All the logs created by Xpand are placed, by default, in the /data/clustrix/log directory (this is configurable), and there are a separate set of logs for each node of your cluster.

Logs

MariaDB Xpand's most frequently used logs are:

  • alert.log

  • clustrix.log

  • query.log

  • user.log

alert.log

The alert.log file contains alerts.

For additional information, see "Email Alerts for MariaDB Xpand.

clustrix.log

The clustrix.log is a chronology of events that occur on your cluster.

query.log

The query.log shows information for SQL statements used within Xpand. From the query.log you can identify slow queries as well as query syntax errors.

For additional information, see "Query Logging for MariaDB Xpand".

user.log

The user.log consists of timestamped logins and logouts and does not include detailed query activity.

For additional information, see "User Logging for MariaDB Xpand".