Creating a DB parameter Group for AWS RDS MySQL

1. Navigate to RDS -> Parameter Groups and click the Create parameter group button.

Screenshot 1 — Creating a DB parameter Group for AWS RDS MySQL

2. Enter the Group name and Description then click the Create button.

Screenshot 2 — Creating a DB parameter Group for AWS RDS MySQL

3. Select the newly created parameter groups and select the Edit option from the Parameter group actions dropdown.

Screenshot 3 — Creating a DB parameter Group for AWS RDS MySQL

4. Search for performance_schema and set its value to 1 change performance_schema_events_statements_history_size to 1024 and click the Save changes button.

Screenshot 4 — Creating a DB parameter Group for AWS RDS MySQL

5. Navigate to the Parameter Groups screen.

Screenshot 5 — Creating a DB parameter Group for AWS RDS MySQL

6. Select both the default and newly created parameter groups, then choose the Compare option from the Parameter group actions dropdown.

Screenshot 6 — Creating a DB parameter Group for AWS RDS MySQL

7. This will display a list of Parameters list that differ between the from default and the newly created groups. If there are additional changes beyond these parameters, edit the newly created parameter group to include those change and save your updates.

Screenshot 7 — Creating a DB parameter Group for AWS RDS MySQL

8. Navigate to RDS > Databases and click the Modify button.

Screenshot 8 — Creating a DB parameter Group for AWS RDS MySQL

9. Choose the newly created parameter group from the DB parameter group dropdown and click the Continue button.

Screenshot 9 — Creating a DB parameter Group for AWS RDS MySQL

Screenshot 10 — Creating a DB parameter Group for AWS RDS MySQL

10. Select the Apply immediately option and click the Modify DB instance button.

Screenshot 11 — Creating a DB parameter Group for AWS RDS MySQL

11. Select the DB instance and click the Reload button to check the status. It will display the status as Modifying. Wait until the Status to became Available.

Screenshot 12 — Creating a DB parameter Group for AWS RDS MySQL

12. Click the Reload button to check the status frequently.

Screenshot 13 — Creating a DB parameter Group for AWS RDS MySQL

13. Once the status changes Available, select the Reboot option from the Actions dropdown.

Screenshot 14 — Creating a DB parameter Group for AWS RDS MySQL

Was this article helpful?

Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.

Opens Zendesk · needs internet and sign-in

Still stuck? Contact support