View a markdown version of this page

✨ อัปเดตล่าสุด: AmazonRDS/latest/UserGuide/USER PerfInsights.EnableMySQL.RDS.html - Kapook Update 2025

Turn on the Performance Schema for Amazon RDS for MariaDB or MySQL

Assume that Database Insights is turned on for your DB instance or Multi-AZ DB cluster but isn't currently managing the Performance Schema. If you want to allow Database Insights to manage the Performance Schema automatically, complete the following steps.

To configure the Performance Schema for automatic management

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. Choose Parameter groups.

  3. Select the name of the parameter group for your DB instance or Multi-AZ DB cluster.

  4. Choose Edit.

  5. Enter performance_schema in the search bar.

  6. Select the performance_schema parameter.

  7. Choose Set to default value.

  8. Confirm by choosing Set values to default.

  9. Choose Save Changes.

  10. Reboot the DB instance or Multi-AZ DB cluster.

    Important

    Whenever you turn the Performance Schema on or off, make sure to reboot the DB instance or Multi-AZ DB cluster.

For more information about modifying instance parameters, see Modifying parameters in a DB parameter group in Amazon RDS. For more information about the dashboard, see Database Insights. For more information about the MySQL performance schema, see MySQL Performance Schema (for 8.0) and MySQL Performance Schema (for 8.4) in the MySQL documentation.