R
romain.pennes@foederis.fr
Guest
Hello, I am encoutering the "Row size too large (> 8126)" errors on my Private Cloud instance. This is because we have some objectifs with dozens of text area fields in them. I cannot add any more fields (INTGXXX) to my tables because of it. I noticed on the 4.2 patch that you have fixed this issue on Rollbase Hosted Cloud. Could you tell me what you have done? I'm trying to fix this error in my Private Cloud instance, and I want to be able to add some more columns afterwards. I can't seem to be able to fix this issue. We are using MySQL 5.5.25, with InnoDB and the Antelope file format. I read that we need to use the Barracuda file format. However, we can't seem to be able to switch to Barracuda file format. Is this what you had to do to fix the issue? Here is what we have done so far: SET GLOBAL innodb_file_format = barracuda; SET GLOBAL innodb_file_format_max = barracuda; ALTER TABLE rb_obj_data ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; The ALTER TABLE doesn't work; when trying it, we get the "Row size too large (> 8126)" error. Thank you for your help. Kind regards, Romain.
Continue reading...
Continue reading...