Cloud SQL only supports a subset of MySQL flags <https://cloud.google.com/sql/docs/mysql-flags>, although you could file a Feature Request in the Public Issue Tracker for Cloud SQL <https://code.google.com/p/googlecloudsql/issues/list> to see innodb_file_format <https://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_format> supported. Are any of the other options from my last post possible to use?
On Monday, May 9, 2016 at 8:18:14 PM UTC-4, channing dev wrote: > > Hi Nick, > > OK. I found some documents about this, found one way to solve it. That is > I want to change InnoDB to Barracuda format. How to config this on Google > Cloud SQL? There is no this tag on Cound SQL console. Or you have some > other advice to me? > > Thanks. > > > 在 2016年5月10日星期二 UTC+8上午1:55:17，Nick (Cloud Platform Support)写道： >> >> Hey Channing, >> >> This isn't a Cloud SQL restriction but rather an InnoDB restriction. You >> can read about it in the links given in this Stack Overflow Q&A from a >> user who saw the exact same error message >> <http://stackoverflow.com/a/15585700/4270992>. >> >> Cheers, >> >> Nick >> Cloud Platform Community Support >> >> On Monday, May 9, 2016 at 3:20:28 AM UTC-4, channing dev wrote: >>> >>> Hello, >>> >>> I have a GAE instance on Google cloudsql and created one database on it, >>> in the database there is a table which have 40 fields, and have 5 text >>> fields. >>> The issue is when I run update sql to update one of the text field, >>> cloudsql alert me with below error: >>> [Err] 1118 - Row size too large (> 8126). Changing some columns to TEXT >>> or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In >>> current row format, BLOB prefix of 768 bytes is stored inline. >>> I can make sure the field is text and the update value is less than 64 >>> kb, and in my another table which have 10 fields we can update successfully >>> use the same sql. >>> Does cloudsql have this issue when a table have more than some fields? >>> e.g. more than 30? or 35? >>> >>> Thanks. >>> >> -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/3da039bd-8087-4f66-9388-121984f1a886%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
