CloudSql: set row_format to dynamic

[jameslast]

Hello All,

I have some databases running on a CloudSql instance, version 8.0.

Now I 'm trying to set the default row_format to dynamic. But none of the users have the right permisson. I understand

things are different on CloudSql because it is a managed service.

I can't find a database flag to set this value either.

Can anybody help me out?

Greetings, j.

[jameslast]

Hello,

some more info on what I'm try!ng to do: I'm trying to run this Mysql command:

mysql> SET GLOBAL innodb_default_row_format=DYNAMIC;

Output: 

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

I don't think I can get system_variables_admin privileges on CloudQql. And I can not find a database flag to solve this.

Any help would be appreciated.

Greetings, j.

[mcbsalceda]

Hi @jameslast,

Unfortunately, innodb_default_row_format is a flag that is not supported in Cloud SQL. You may check the supported flags here. 

You could also throw in a suggestion to get Cloud SQL to support this flag through the issue tracker. 

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[jameslast]

Hello mcbsalceda,

thanks for your reply.

Ok, no flag then....does this mean row_format can't be set at all in CloudSql? We are still very much getting to know the system & are mainly struggling with permissions.

Greetings, j.