What Database flags cause restart?

[R R]

Hi Cloud SQL Team,

You mention that add/modify flags to Cloud MySQL will cause restart. Can you enlighten me with those flags that will cause a restart?

Thanks.

Regards,
R

[nau...@google.com]

Hello Raj 

Let me check on this information and will get back to you. 

[R R]

Any updates nau?

[Fady (Google Cloud Platform)]

Hello Raj,

According to this document, the instance might be restarted when you add/remove/modify a flag. You may check the flags that require a restart by calling the list method of the API (just click execute without any modifications on this API page), and check the desired flag if  “requiresRestart=True". For further information please check this document.

On the other hand, per "the tips with flags" page, “Exhausting the available instance memory can occur when you set tmp_table_size and max_heap_table_size too high for the number of concurrent queries the instance processes. Exhausting the memory will result in an instance crash and restart.” I hope this helps.

[R R]

Thanks!!

[Pia Chamberlain]

The Cloud SQL docs have been updated to include this information:

https://cloud.google.com/sql/docs/mysql/flags