System Sub-commands for MariaDB Shell

Overview

MariaDB Shell supports the sys sub-commands, which are re-implementations of the mariadb-admin sub-commands.

The system sub-command is an alias for the sys sub-command.

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

The sys sub-commands can be executed from an interactive shell:

MariaDB (No Database) » sys status
Uptime:			0:18:08
Threads Created:	2
Questions:		5
Opened Tables:		16
Open Tables:		10
Queries per second ave:	0.004596

Execute via CLI

The sys sub-commands can also be executed using CLI commands:

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

Supported Sub-commands

The following sys sub-commands are currently supported:

  • create

  • drop

  • shutdown

  • reload

  • refresh

  • version

  • processlist

  • status

  • kill

  • debug

  • variables

  • flush-logs

  • flush-hosts

  • flush-tables

  • password

  • ping

  • extended-status

  • replica-status

  • all-replica-status

  • flush-status

  • flush-privileges

  • start-replica

  • stop-replica

  • start-all-replicas

  • stop-all-replicas

  • flush-threads

  • old-password

  • flush-binary-log

  • flush-engine-log

  • flush-error-log

  • flush-general-log

  • flush-relay-log

  • flush-slow-log

  • flush-table-statistics

  • flush-index-statistics

  • flush-user-statistics

  • flush-client-statistics

  • flush-user-resources

  • flush-all-status

  • flush-all-statistics

  • flush-ssl

  • load-buffer-pool

  • dump-buffer-pool

  • memory-config

  • pre-slice