This page displays and describes the panels shown in the Google Cloud Console instance overview page.
Viewing instance summary information
You can view summary information about your Cloud SQL instances in the
Google Cloud Console, or by using the gcloud
command-line tool,
or the API.
Console
- Go to the Cloud SQL Instances page in the Google Cloud Console.
- Hover over the status icon to the left of an instance name to see the current instance state.
- Click an instance name to open its Instance details page.
gcloud
gcloud sql instances describe [INSTANCE_NAME]
REST v1beta4
Before using any of the request data below, make the following replacements:
- project-id: The project ID
- instance-id: The instance ID
HTTP method and URL:
GET https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id
To send your request, expand one of these options:
You should receive a JSON response similar to the following:
{ "kind": "sql#instance", "state": "RUNNABLE", "databaseVersion": "MYSQL_5_7", "settings": { "authorizedGaeApplications": [], "tier": "db-f1-micro", "kind": "sql#settings", "pricingPlan": "PER_USE", "replicationType": "SYNCHRONOUS", "activationPolicy": "ALWAYS", "ipConfiguration": { "authorizedNetworks": [], "ipv4Enabled": true }, "locationPreference": { "zone": "asia-east1-a", "kind": "sql#locationPreference" }, "dataDiskType": "PD_SSD", "backupConfiguration": { "startTime": "08:00", "kind": "sql#backupConfiguration", "enabled": true, "binaryLogEnabled": true }, "settingsVersion": "13", "storageAutoResizeLimit": "0", "storageAutoResize": true, "dataDiskSizeGb": "10" }, "etag": "etag-id", "ipAddresses": [ { "type": "PRIMARY", "ipAddress": "10.0.0.1" } ], "serverCaCert": { "kind": "sql#sslCert", "certSerialNumber": "0", "cert": "certificate-id", "commonName": "C=US,O=Google\\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=dn-qualifier-id", "sha1Fingerprint": "sha-id", "instance": "instance-id", "createTime": "2019-06-28T22:46:35.052Z", "expirationTime": "2029-06-25T22:47:35.052Z" }, "instanceType": "CLOUD_SQL_INSTANCE", "project": "project-id", "serviceAccountEmailAddress": "service-acct-id@gcp-sa-cloud-sql.iam.gserviceaccount.com", "backendType": "SECOND_GEN", "selfLink": "https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id", "connectionName": "project-id:region:instance-id", "name": "instance-id", "region": "asia-east1", "gceZone": "asia-east1-a" }
Metrics
This section provides usage charts of key instance metrics that you can use to monitor your instances. When working with metric data, keep the following facts in mind:
- A data point for a metric is an aggregate over all of the databases hosted by the instance.
- Data is reported in Coordinated Universal Time (UTC).
- Rendered charts do not refresh automatically; to see new data, you must refresh the page.
- There is a delay of a few minutes between when metric data is recorded and the time it is displayed in the usage charts.
For more information about the metrics shown in the chart, see Monitoring Cloud SQL instances.
For a complete list of Cloud SQL metrics provided by Cloud Monitoring, see the Cloud SQL metrics list.
For more information about using Cloud Monitoring with Google Cloud, see the Cloud Monitoring documentation.
Connect to this instance
In the Connect to this instance section, you can find your instance's IP addresses, VPC network and connection name.
Click Connect using Cloud Shell to open a terminal and connect to your instance.
Click Connect from a Compute Engine VM instance to open a related tutorial in the right pane.
Click See all connection methods to go to Connection options.
For more information about connecting to an instance, see Connecting overview.
Service account
This section shows the instance's service account email address.
For more information see the IAM service accounts documentation.
Configuration
This section shows current configuration settings of the instance.
Click Edit configuration to make changes.
For more information about editing the instance configuration, see editing an instance.
Operations and logs
This section lists recent instance operations, such as backups.
Click View all operations to go to the Operations page.
Click View MySQL Error Logs to go to the Logs Explorer page.
For more information about viewing, selecting and filtering logs, see Viewing Logs.
For information about exporting logs, see Exporting Logs.
Maintenance
This section shows the current maintenance update settings and schedule.
Click Edit maintenance preferences to make changes.
Click Edit notification preferences to change notification settings.
For more information about maintenance in Cloud SQL, see Maintenance overview.
What's next
- Learn more about Cloud Monitoring metrics for Cloud SQL.
- Learn more about instance settings.
- Learn more about editing an instance.