columnstoreSupport for MariaDB Enterprise ColumnStore
This page is part of MariaDB's Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Enterprise ColumnStore
Topics on this page:
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.
columnstoreSupport Options by MariaDB Enterprise ColumnStore Version
Choose a version of MariaDB Enterprise ColumnStore to see the options supported by that version:
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
andtop
outputSystem 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