Issue Creating Datastore Entity With Large Number of Rows

Question

Using the MySQL cloud config it seems I have run into an issue creating an datastore entity. My CDT does have a large number of rows and when I attempt to publish the datastore I get the generic "The server has encountered an error." I checked the app server error logs to find there was a hibernate error telling me I've exceeded the row size limit (64k) So two questions: 1) can someone confirm there is a row size limit with MySQL 2) if so, I assume the suggestion is to divide the CDT into smaller CDTs. I can do this without any issues. Are there any alternates on this? 
 OriginalPostID-194664 
 OriginalPostID-194664

Tim · Accepted Answer

Yes there is a 64k limit for all the columns in a table. I would look at your table design, assuming you have multiple large varchar fields for example. Are the stated sizes genuine or can they be reduced? Look into using text type instead of varchar.