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


This howto requires:

Environment setup

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

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


Install the required software:

${cmdProxy} apt install 'unzip'

Download the latest schema version:

command wget '' \

Unzip the downloaded file:

command unzip -d '/tmp' '/tmp/'

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/'
command rm -r '/tmp/mariadb-sys-master'



Leave a Reply

Avatar placeholder

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.