How to view data under Session & Performance tab in MySQL monitor?

How to view data under Session & Performance tab in MySQL monitor?

Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell:

show databases;

If the output does not contain the SYS database, then install the SYS database suitable for the MariaDB version. Click here to learn how to install SYS database in MariaDB

 

To monitor data under Session and Performance tabs, follow the steps given below:

  1. Check whether performance_schema is enabled. If not, include the below statement in MySQL startup (my.ini / my.cnf) file.

[mysqld]

performance_schema=ON

  1. After making the above changes, restart the MySQL/MariaDB server.

  2. Now poll the MySQL monitor in Applications manager to view data.

 

Note: Before proceeding to implement the above steps, make sure all the required privileges are provided for MySQL users. To learn more about the prerequisites, refer here.