CloudSQL CPU SKU

[wahajali]

Hi, is there a way to find out the CPU SKU information (and subsequently processor generation, clock speed etc) that the CloudSQL instance is running on. Unlike Azure and AWS, this information doesn't seem very obvious when creating the instance, as we only have to specify the # of CPUs and memory.

[ms4446 · Accepted solution]

In Cloud SQL, the specific CPU SKU information (such as processor generation and clock speed) isn't explicitly provided when creating or managing instances. This is because  Cloud SQL focuses on providing a managed service where you primarily specify the desired compute resources (CPUs and memory) without needing to delve into the underlying hardware details.

However, you can get some details about the underlying infrastructure by checking the machine type and comparing it with Google Cloud's documentation on available machine types and their specifications.

Here's how you can gather some information:

1. Check the Instance Details:

   • Go to the Google Cloud Console.
   • Navigate to SQL.
   • Select your instance.
   • In the Overview section, you can see the machine type, which typically includes the number of vCPUs and the memory allocated.

2. Identify the Machine Type:

   • Note the machine type, for example, db-n1-standard-4, db-n2-highmem-16, etc.
   • The machine type gives you a clue about the underlying hardware.

3. Refer to Google Cloud Machine Types Documentation:

   • Google Cloud has detailed documentation on machine types used in different services, including the processors they use.
   • You can find the specifications for N1, N2, and other machine families here: Google Compute Engine machine types.

4. Infer CPU Information:

   • For example, N1 machine types typically use Intel Haswell, Broadwell, or Skylake CPUs.
   • N2 machine types generally use Intel Cascade Lake CPUs.
   • Check the specific documentation for the machine type you are using to get more details on the processor generation and clock speed.

If you need the most precise information or have specific compliance requirements, you might need to reach out to Google Cloud support for detailed infrastructure specifications. They can provide more specific details about the underlying hardware if necessary.

[ms4446 · Accepted solution]

In Cloud SQL, the specific CPU SKU information (such as processor generation and clock speed) isn't explicitly provided when creating or managing instances. This is because  Cloud SQL focuses on providing a managed service where you primarily specify the desired compute resources (CPUs and memory) without needing to delve into the underlying hardware details.

However, you can get some details about the underlying infrastructure by checking the machine type and comparing it with Google Cloud's documentation on available machine types and their specifications.

Here's how you can gather some information:

1. Check the Instance Details:

   • Go to the Google Cloud Console.
   • Navigate to SQL.
   • Select your instance.
   • In the Overview section, you can see the machine type, which typically includes the number of vCPUs and the memory allocated.

2. Identify the Machine Type:

   • Note the machine type, for example, db-n1-standard-4, db-n2-highmem-16, etc.
   • The machine type gives you a clue about the underlying hardware.

3. Refer to Google Cloud Machine Types Documentation:

   • Google Cloud has detailed documentation on machine types used in different services, including the processors they use.
   • You can find the specifications for N1, N2, and other machine families here: Google Compute Engine machine types.

4. Infer CPU Information:

   • For example, N1 machine types typically use Intel Haswell, Broadwell, or Skylake CPUs.
   • N2 machine types generally use Intel Cascade Lake CPUs.
   • Check the specific documentation for the machine type you are using to get more details on the processor generation and clock speed.

If you need the most precise information or have specific compliance requirements, you might need to reach out to Google Cloud support for detailed infrastructure specifications. They can provide more specific details about the underlying hardware if necessary.

[taimur1991]

Hi @ms4446 thanks for the guidance. Please refer below.

Check the Instance Details:

---

I was able to spot information in this section. But I needed information as you mentioned in step 4. 

Identify the Machine Type:

---

 I have checked almost all tabs in the instance I created. I cannot identify machine type as you mentioned.

Point 3 and 4 were not possible to explore since I could not identify machine type. 

In Cloud SQL, the specific CPU SKU information (such as processor generation and clock speed) isn't explicitly provided when creating or managing instances. This is because  Cloud SQL focuses on providing a managed service where you primarily specify the desired compute resources (CPUs and memory) without needing to delve into the underlying hardware details.

---

So is this safe to assume that SKU information is not available as you proposed? Could there be another way of identifying such information?

[ms4446 · Accepted solution]

Again, Cloud SQL, specific CPU SKU information (such as exact processor generation and clock speed) is not directly accessible to users. Google Cloud's approach with Cloud SQL prioritizes abstracting away the underlying hardware details to provide a managed database service.

While not directly stated, the machine type you choose (e.g., db-n1-standard-4) can give you a general idea of the underlying hardware generation. You can cross-reference this with Compute Engine's documentation to infer the possible processor families.

Running benchmark tests on your Cloud SQL instance and comparing the results with publicly available benchmarks for different processors might give you some clues, but it’s not a guaranteed way to identify the exact SKU.

If you absolutely need to know the exact CPU SKU information, reach out to Google Cloud support and explain your specific requirements. They might be able to provide you with more details about the underlying hardware, especially if you have compliance or performance-related concerns.