S
srikanth kasavajhula
Guest
I dont understand the part where you say , I cant add fields . How I reproduced and checked: So I reproduced the issue in 5.5 using 200 textfields with data . When creating a new object with 200 fields filled with random text(100-150) characters we are getting " 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. " Is this the exact error you are getting . This happens when row_format is compact (5.5/5.6) From 5.7.13+ the default row_dormat is dynamic /compressed . So i again created 200 text fields with the same text and submitted the new object . We dont get the error This is because the compressed row formats include compressed tables and off-page storage for long column data. More detailed explanation: When a table is created with ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED , long variable-length column values (for VARBINARY , VARCHAR , BLOB , and TEXT columns) are stored fully off-page, and the clustered index record contains only a 20-byte pointer to the overflow page. Couple of questions to test the safety of the upgrade /time taken What type of upgrade are you planning ? In-place upgrade or dump restore( Logical Upgrade ) Best regards, Srikanth
Continue reading...
Continue reading...