Articles → AWS → Enable The Performance Schema In Mysql On AWS

Enable The Performance Schema In Mysql On AWS

In this article, we will enable the performance schema in MySQL on AWS.

What Is The Performance Schema?

The performance schema is the diagnostic tool in MySQL that provides insight into various aspects of database performance and resource usage.

To enable the performance schema, we can follow these steps: -

To create a new parameter group, go to the RDS dashboard and click on the Parameter groups options.

Click to Enlarge

The following screen will appear. Click on the Create parameter group button.

Click to Enlarge

A screen will appear to create the parameter group. Enter the details and click on the Create button.

Click to Enlarge

Once the parameter group is created, go to the details, and click on the Edit button.

Click to Enlarge

In the Modifiable parameters, search the parameter performance_schema and change the value from 0 to 1.

Click to Enlarge

Click on the Save changes button to save the change.

The next step is to create a MySQL database.

The last step is to modify the Db parameter group of the database. For that, go to the details screen of the database and click on the Modify button.

Click to Enlarge

Scroll down to the Additional configuration section and modify the Db parameter group.

Click to Enlarge

Save the changes. The performance schema is enabled for your database.

Query/Feedback