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:

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


0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.