columnstoreSupport for MariaDB Enterprise ColumnStore

Overview

MariaDB Enterprise ColumnStore includes the columnstoreSupport utility, which can be used to collect logs and system information for MariaDB Support.

Reference material is available for MariaDB Enterprise ColumnStore.

MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server.

Note

The columnstoreSupport utility has been removed from MariaDB Enterprise ColumnStore 5. If you have any questions about how to collect logs and system information, please contact MariaDB Support.

USAGE

The syntax for columnstoreSupport is:

$ columnstoreSupport [OPTION ...]

DETAILS

The columnstoreSupport utility collects a lot of different information from a system running MariaDB Enterprise ColumnStore. It is most often used when the MariaDB Support Team requests system details while working on a support case.

The utility collects the following information from each node:

  • ColumnStore logs

  • MariaDB Server logs

  • Configuration details

  • Hardware details

  • Resource details

  • Software details

  • Database details

The output file is columnstoreSupportReport.SYSTEM_NAME.tar.gz in the current working directory.

MariaDB Enterprise ColumnStore Logs

The columnstoreSupport utility collects the following MariaDB Enterprise ColumnStore logs from each node:

  • activeAlarms

  • alarm.log

  • crit.log

  • debug.log

  • err.log

  • info.log

  • warning.log

The MariaDB Enterprise ColumnStore logs are put into the file NODEID_logReport.tar.gz.

MariaDB Enterprise Server Logs

The columnstoreSupport utility collects the MariaDB Enterprise Server logs from each node.

The MariaDB Enterprise Server logs are put into the file NODEID_mysqllogReport.tar.gz.

Configuration Details

The columnstoreSupport utility collects the following configuration details from each node:

  • Server processes, including ps and top output

  • System network information

  • System configuration, including /etc/fstab

  • System status

  • Enterprise ColumnStore configuration, including Columnstore.xml

The configuration details are put into the file NODEID_configReport.txt.

Hardware Details

The columnstoreSupport utility collects the following hardware details from each node:

  • OS version

  • CPU details

  • Memory details

  • Storage details

  • Networking details, including ifconfig output

The hardware details are put into the file NODEID_hardwareReport.txt.

Resource Details

The columnstoreSupport utility collects the following resource details from each node:

  • Shared memory

  • Disk usage

  • DBRM files

  • Active table locks

  • Extent map

The resource details are put into the file NODEID_resourceReport.txt.

Software Details

The columnstoreSupport utility collects the following software details from each node:

  • MariaDB Enterprise ColumnStore version

The software details are put into the file NODEID_softwareReport.txt.

Database Details

The columnstoreSupport utility collects the following database details from each node:

  • MariaDB Enterprise Server version

  • System catalog

  • Tables

  • User accounts

  • System variables

  • ES configuration, including my.cnf

  • Active queries

The database details are put into the file NODEID_dbmsReport.txt.

EXAMPLES

Output All Reports

To output all reports, use the -a and -bl options:

$ columnstoreSupport -a -bl

Output Local Reports

To output only local reports, use the -lc option:

$ columnstoreSupport -lc