[Opensim-users] MySQL create table for regions fails on new data base setup?

[Tom Frost]

Hi,

On Fri, Jan 08, 2016 at 12:05:46PM +0000, Ai Austin wrote:
> As noted before, I am getting an error on loading a MySQL 5.6 dump
> of my OpenSim content and trying to load it on a new MySQL 5.7
> server.  I have tracked this down to the SQL load complaining about
> a ROW_FORMAT=FIXED on the "regions" table That seems to be the only
> table row that has that option.
> 
> Is this fixed setting needed, and is it correct for recent MySQL
> data base versions?  Can it safely be changed to "Don't Use" like
> all the other opensim data base tables?

https://dev.mysql.com/doc/refman/5.6/en/innodb-row-format-specification.html does not specify FIXED as a valid valie for ROW_FORMAT in 5.6, so I assume it is a deprecated setting that was ignored in 5.6 and completely removed in 5.7.

In any case, the ROW_FORMAT option determines the way mysql stored rows in binary format in the underlying database files. The worst that can happen is that performance is impacted if this setting is 'incorrect'. Given that this is in the region table, which normally doesn't have many rows anyway, it's rather a moot point what you set it to.

Best,

Tom