Determining whether Database Insights is managing the Performance Schema - Amazon Aurora
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Determining whether Database Insights is managing the Performance Schema

To find out whether Database Insights is currently managing the Performance Schema for all supported major engine versions, review the following table.

Setting of performance_schema parameter Setting of the Source column Database Insights is managing the Performance Schema?
0 System default Yes
0 or 1 Modified No

In the following procedure, you determine whether Database Insights is managing the Performance Schema automatically.

To determine whether Database Insights is managing the Performance Schema automatically

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://eusc-de-east-1.console.amazonaws-eusc.eu/rds/.

  2. Choose Parameter groups.

  3. Select the name of the parameter group for your DB instance.

  4. Enter performance_schema in the search bar.

  5. Check whether Source is the system default and Value is 0. If so, Database Insights is managing the Performance Schema automatically.

    In the example shown here, Database Insights isn't managing the Performance Schema automatically.

    Shows that the settings for the performance_schema parameter are modified.