Let me know how it goes, whatever you decide to do, and feel free to post back here if you run into any troubles. I'm sure this thread could be useful to future users.
Cheers, Nick Cloud Platform Community Support On Tuesday, May 10, 2016 at 8:19:47 PM UTC-4, channing dev wrote: > > Nick, > > I see. Now I will firstly change my table structure, it seems no other way > as I know. > > Thank you. > > 在 2016年5月11日星期三 UTC+8上午4:48:24，Nick (Cloud Platform Support)写道： >> >> 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 google-appengine+unsubscr...@googlegroups.com. To post to this group, send email to google-appengine@googlegroups.com. 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/8c6e464c-4d21-4737-9c09-b9f9f17658e0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
