Enabling the performance schema

The performance schema is a tool that we can use to monitor our server performance. It is disabled by default, but it can easily be enabled.

How to do it...

1. Open our my.cnf or my.ini file and add the following code to the [mysqld] section:

   performance_schema

2. Restart MariaDB.

3. Connect to MariaDB using the mysql command-line client.

4. Run the SHOW ENGINES; command and verify that PERFORMANCE_SCHEMA is listed. The performance schema entry will look similar to the following screenshot:

   

5. Switch to the performance_schema database using the following command:

   USE performance_schema;
   

6. Show the performance schema tables using the following command:

   SHOW TABLES;
   

How it works...

The performance schema is implemented as a storage engine. This is why it shows up alongside other storage engines when we use the SHOW ENGINES; command. However, it is not a storage engine for storing data. The purpose of the performance schema is to help us monitor server performance and when it is enabled...