columnstoreSupport for MariaDB Enterprise ColumnStore 1.4

Overview

MariaDB Enterprise ColumnStore 1.4 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 1.4.

MariaDB Enterprise ColumnStore 1.4 is included with MariaDB Enterprise Server 10.4.

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 1.4. 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.

columnstoreSupport Options for MariaDB Enterprise ColumnStore 1.4

Option

Description

-a

Output all Reports (excluding Bulk Logs Reports)

-bl

Output Columnstore Bulk Log Reports only

-c

Output Configuration/Status Reports only

-db

Output DBMS Reports only

-de

Debug Flag

-h

help

-hw

Output Hardware Reports only

-l

Output Columnstore Log/Alarms Reports only

-lc

Output Reports for Local Server only

-p

password (multi-server systems), root-password or 'ssh' to use 'ssh keys'

-r

Output Resource Reports only

-s

Output Software Reports only

To see options supported in other versions, see "columnstoreSupport Options by MariaDB Enterprise ColumnStore Version".

MariaDB Enterprise ColumnStore 1.4 Logs

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

  • activeAlarms

  • alarm.log

  • crit.log

  • debug.log

  • err.log

  • info.log

  • warning.log

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

MariaDB Enterprise Server 10.4 Logs

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

The MariaDB Enterprise Server 10.4 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 1.4 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 10.4 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