FISH Sub-commands for MariaDB Shell

Overview

MariaDB Shell supports Fully Integrated System Histogram (FISH) sub-commands.

Compatibility

MariaDB Shell (mariadb-shell) has been tested by MariaDB to properly connect and execute commands with:

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

  • MariaDB Enterprise ColumnStore 6

  • MariaDB Enterprise ColumnStore 22.08

  • MariaDB Enterprise ColumnStore 23.02

  • MariaDB Enterprise Server 10.4

  • MariaDB Enterprise Server 10.5

  • MariaDB Enterprise Server 10.6

  • MariaDB MaxScale 2.4

  • MariaDB MaxScale 2.5

  • MariaDB MaxScale 6

  • MariaDB MaxScale 22.08

  • MariaDB MaxScale 23.02

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6.0

  • MariaDB Xpand 6.1

Supported Operating Systems

  • Apple macOS (x86_64 / M1)

  • CentOS 7 (x86_64)

  • Debian 10 (x86_64)

  • Debian 11 (x86_64)

  • Microsoft Windows (x86_64)

  • Red Hat Enterprise Linux 7 (x86_64)

  • Red Hat Enterprise Linux 8 (x86_64)

  • Red Hat Enterprise Linux 9 (x86_64)

  • Rocky Linux 8 (x86_64)

  • Rocky Linux 9 (x86_64)

  • Ubuntu 18.04 (x86_64)

  • Ubuntu 20.04 (x86_64)

  • Ubuntu 22.04 (x86_64)

Execute via Interactive Shell

Fully Integrated System Histogram (FISH) sub-commands can be executed from an interactive shell:

MariaDB (No Database) » fish report

Execute via CLI

Fully Integrated System Histogram (FISH) sub-commands can also be executed using CLI commands:

$ mariadb-shell \
   --host HOSTNAME --port TCP_PORT \
   --user DATABASE_USER --password USER_PASSWORD \
   fish report \
   > ~/mariadb-fish-report.log

collection

The fish collection sub-command provides a set of options for collecting metrics to produce a FISH report.

dump

The fish dump sub-command creates a JSON file containing the metrics used to produce FISH reports:

MariaDB (No Database) » fish dump

report

The fish report sub-command can create FISH reports:

MariaDB (No Database) » fish report