How to install Sys Database on Maria DB Server?

How to install Sys Database on Maria DB Server?

Issue:
Solution:
  1. Download the MariaDB-sys from the GitHub using this link
  2. Extract the downloaded zip.
  3. Based on your MariaDB version open the corresponding file [ sys_56.sql, sys_57.sql, sys_10.sql ]
  4. Change all the relative path entries to static path entries as mentioned below.
    Example: 
    1. Relative path: SOURCE ./before_setup.sql
    2. Actual path: SOURCE D:/mariadb-sys-master/before_setup.sql
    3. You need to change all the entries in that file.
  5. Open a terminal/prompt where your file has been located.
  6. Execute the following command to install sys DB
    Example: The file name is based on your Maria DB server version.
    mysql -u root -p < ./sys_10.sql
  7. Login into Maria DB server and check sys DB will be installed
  8. Poll the monitor for a couple of times in the Applications Manager to view required data.
Note:
Check whether performance_schema is enabled or not to view session and performance tab data.