Re: [google-cloud-sql-discuss] Does preformance_schema feature work for Cloud SQL v1 instance?

It's only supported for second generation instances.

On Wed, Jul 12, 2017 at 5:48 PM 'Suqi Xiao' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

I found the following description about performance_schema: 

performance_schema

boolean

on | off (default) You must use the API to change the value of this flag. It cannot be enabled on instances with a tier size smaller than db-n1-standard-8 or db-n1-highmem-4. If this flag is enabled, you cannot change your tier to a size that does not support this flag; you must first disable this flag.

I tried to turn it on with v2 instance, it worked fine. However, when it comes to v1 instance, I cannot find options that allow me to choose tier size (e.g. db-n1-standard-8).

 if I proceed with turning the flag on, I will get errors the next time I try to access it.

The command I used is:

gcloud sql instances patch [INSTANCE_NAME] --database-flags performance_schema=on

The error message I then see is:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

So does v1 instance support performance_schema? If so, did I miss any steps in the process?

Thanks,

Suqi

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e3bc88fb-0bf9-4463-9473-b2cd6cfffaf6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p0o7JSasvo1XwF%2BkKWvtLa%2BeC_oTCpwHv33Yc1Y9xXM%3DQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.