Improve performance with Cloud SQL Enterprise Plus edition

This page describes the following types of Cloud SQL Enterprise Plus edition recommenders:

The following sections describe how these recommenders work and how to use them.

Pricing

The recommenders described on this page are all in the standard Recommender pricing tier.

Before you begin

Before you can view recommendations and insights, do the following:

  • To get the permissions to view and work with insights and recommendations, ensure that you have the required roles.
    Tasks Roles
    View recommendations One of these roles: recommender.cloudsqlViewer or cloudsql.viewer.
    Apply recommendations One of these roles: recommender.cloudsqlAdmin, cloudsql.editor, or cloudsql.admin.
    For more information about roles, see understanding roles and granting Identity and Access Management (IAM) permissions.
  • Enable the Recommender API.

    Enable the API

Upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime

The Cloud SQL Enterprise Plus edition for near-zero maintenance downtime recommender helps you detect instances that are either critical and take a long time to stop during maintenance or their maintenance has been deferred. It analyzes instance metadata and data about maintenance.

If your instance is a production instance and takes a long time to stop during maintenance or its maintenance has been deferred, it is recommended to upgrade to Cloud SQL Enterprise Plus edition so that you instances will have near-zero maintenance downtime. Recommendations are generated daily.

List near-zero downtime recommendations

You can list upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime recommendations using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:

  1. Go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

    On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.

Alternatively, follow these steps:

  1. Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.

    Go to the Recommendation Hub

    For more information, see Getting started with the Recommendation Hub.

  2. In the All recommendations card, click Performance.

gcloud

Run the gcloud recommender insights list command as follows:

gcloud recommender recommendations list \
--project=PROJECT_ID \
--location=LOCATION \
--recommender=google.cloudsql.instance.PerformanceRecommender \
--filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS

Replace the following:

  • PROJECT_ID: Your project ID.
  • LOCATION: A region, such as us-central1.

API

Call the insights.list method as follows:

GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations

Replace the following:

  • PROJECT_ID: Your project ID.
  • LOCATION: A region, such as us-central1.

If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.

View insights and detailed recommendations

You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

Do one of the following:

  • On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.

  • On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.

gcloud

Run the gcloud recommender insights list command as follows:

gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.PerformanceInsight
--filter=insightSubtype=INSIGHT_SUBTYPE

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region, such as us-central1.
  • INSIGHT_SUBTYPE: set this parameter to one of the following:
    • CRASH_RECOVERY_CAUSED_HIGH_MAINTENANCE_DOWNTIME: display insights for the total number of crash recoveries for your instance
    • MAINTENANCE_DEFERRED_MULTIPLE_TIMES: display insights for the total number of maintenances deferred for your instance

API

Call the insights.list method as follows:

GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights

Replace the following:

  • PROJECT_ID: Your project ID.
  • LOCATION: A region, such as us-central1.

A panel appears showing insights about metrics or information that the Insights highlight.

Apply recommendations

To implement this recommendation, do the following:

Upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance

The upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance recommender helps you detect instances which are critical and their buffer pool spills pages.

The upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance recommender analyzes instance metadata and metrics about buffer pool. If the instance is a production instance and its buffer pool spills pages, it is recommended to upgrade to Cloud SQL Enterprise Plus edition and enable the data cache to improve read performance. Recommendations are generated daily.

List instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations

You can list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:

  1. Go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

    On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.

Alternatively, follow these steps:

  1. Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.

    Go to the Recommendation Hub

    For more information, see Getting started with the Recommendation Hub.

  2. In the All recommendations card, click Performance.

gcloud

To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations, run the gcloud recommender recommendations list command as follows:

gcloud recommender recommendations list \
--project=PROJECT_ID \
--location=LOCATION \
--recommender=google.cloudsql.instance.PerformanceRecommender \
--filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS_AND_ENABLE_DATA_CACHE

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

API

To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations, call the recommendations.list method as follows:

GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.

View insights and detailed recommendations

You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

Do one of the following:

  • On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.

  • On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.

gcloud

To view insights and detailed recommendations about an instance that can be upgraded, run the gcloud recommender insights list command as follows:

gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.PerformanceInsight
--filter=insightSubtype=READ_HEAVY_WORKLOAD

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

API

Call the insights.list method as follows:

GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

A panel appears showing insights about metrics or information that the Insights highlight.

Apply recommendations

To implement this recommendation, do the following:

Upgrade to Cloud SQL Enterprise Plus edition with enabling data cache

The upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommender helps you detect instances which are critical and take a long time to stop during maintenance or their maintenance has been deferred and their buffer pool spills pages.

The Cloud SQL Enterprise Plus edition with enabling data cache recommender analyzes instance metadata and metrics.

If your instance is a production instance and takes a long time to stop during maintenance or its maintenance has been deferred and its buffer pool spills pages, it is recommended to upgrade to Cloud SQL Enterprise Plus edition and enable data cache so that your instances have near-zero maintenance downtime and improved read performance. Recommendations are generated daily.

List Cloud SQL instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache recommendations

You can list upgrades to Cloud SQL Enterprise Plus edition when enabling data cache recommendations using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:

  1. Go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

    On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.

Alternatively, follow these steps:

  1. Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.

    Go to the Recommendation Hub

    For more information, see Getting started with the Recommendation Hub.

  2. In the All recommendations card, click Performance.

gcloud

To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommendations, run the gcloud recommender recommendations list command as follows:

gcloud recommender recommendations list \
--project=PROJECT_ID \
--location=LOCATION \
--recommender=google.cloudsql.instance.PerformanceRecommender \
--filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS_AND_ENABLE_DATA_CACHE

Replace the following:

  • PROJECT_ID: Your project ID.
  • LOCATION: A region, such as us-central1.

API

To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommendations, call the recommendations.list method as follows:

GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.

View insights and detailed recommendations

You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

Do one of the following:

  • On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.

  • On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.

gcloud

To view insights and detailed recommendations about an instance that can be upgraded, run the gcloud recommender insights list command as follows:

gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.PerformanceInsight
--filter=insightSubtype=INSIGHT_SUBTYPE

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1
  • INSIGHT_SUBTYPE: set this parameter to one of the following:
    • CRASH_RECOVERY_CAUSED_HIGH_MAINTENANCE_DOWNTIME: display insights for the total number of crash recoveries for your instance
    • MAINTENANCE_DEFERRED_MULTIPLE_TIMES: display insights for the total number of maintenances deferred for your instance
    • READ_HEAVY_WORKLOAD: display insights about CPU usage

API

Call the insights.list method as follows:

GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights

Replace the following:

  • PROJECT_ID: Your project ID.
  • LOCATION: A region, such as us-central1.

A panel appears showing insights about metrics or information that the Insights highlight.

Apply recommendations

To implement this recommendation, do the following:

Enable data cache to improve read performance

The enable data cache to improve read performance recommender helps you detect instances which are critical and their buffer pool spills pages.

The Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommender analyzes instance metadata and metrics about the buffer pool.

If your instance is a production instance and its buffer pool spills pages, it is recommended to enable the data cache to improve read performance. Recommendations are generated daily.

List Cloud SQL instances qualifying for Enable data cache to improve read performance recommendations

You can list enable data cache to improve read performance recommendations by using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:

  1. Go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

    On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.

Alternatively, follow these steps:

  1. Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.

    Go to the Recommendation Hub

    For more information, see Getting started with the Recommendation Hub.

  2. In the All recommendations card, click Performance.

gcloud

To list enable data cache to improve read performance recommendations, run the gcloud recommender recommendations list command as follows:

gcloud recommender recommendations list \
--project=PROJECT_ID \
--location=LOCATION \
--recommender=google.cloudsql.instance.PerformanceRecommender \
--filter=recommenderSubtype=ENABLE_DATA_CACHE

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

API

To list enable data cache to improve read performance recommendations, call the recommendations.list method as follows:

GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

If the recommender detects instances whose data cache can be enabled, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.

View insights and detailed recommendations

You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.

Console

Do one of the following:

  • On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.

  • On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.

gcloud

To view insights and detailed recommendations about an instance that can be upgraded, run the gcloud recommender insights list command as follows:

gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.PerformanceInsight
--filter=insightSubtype=READ_HEAVY_WORKLOAD

Replace the following:

  • PROJECT_ID: your project ID
  • LOCATION: a region where your instances are located, such as us-central1

API

Call the insights.list method as follows:

GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights

Replace the following:

  • PROJECT_ID: Your project ID.
  • LOCATION: A region, such as us-central1.

A panel appears showing insights about metrics or information that the Insights highlight.

Apply recommendations

To implement this recommendation, do the following:

  • To upgrade to Cloud SQL Enterprise Plus edition, click Not optimized with Cloud SQL Enterprise Plus edition in the Issues column. An Upgrade to Cloud SQL Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, click Edit > Upgrade > Customize your instance > Enable data cache. For more information on upgrading your instance, see Upgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade.

What's next