Install the MariaDB sys schema on Debian

The MariaDB sys schema is a collection of views, functions and procedures to help MariaDB administrators get insight in to MariaDB Database usage.

This howto is tested on:

• Debian 10.0 Buster

This howto is tested with these versions of MariaDB:

• 10.3.28

Requirements

This howto requires:

• a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian.

Environment setup

Detect if sudo is available (“command” is used if not):

cmdProxy='command'
command type -f 'sudo' &>'/dev/null' && cmdProxy='sudo'

Installation

Install the required software:

${cmdProxy} apt install 'unzip'

Download the latest schema version:

command wget 'https://codeload.github.com/FromDual/mariadb-sys/zip/master' \
  --output-document='/tmp/mariadb-sys.zip'

Unzip the downloaded file:

command unzip -d '/tmp' '/tmp/mariadb-sys.zip'

Enter the created path:

command pushd '/tmp/mariadb-sys-master'

Install the schema:

command mysql -u root < '/tmp/mariadb-sys-master/sys_10.sql'

Exit the created path:

command popd

Delete the downloaded files:

command rm '/tmp/mariadb-sys.zip'
command rm -r '/tmp/mariadb-sys-master'

Thanks

• Thanks to the MariaDB sys schema developers.