[Opensim-users] 'terrain' table filling and no index defined

Jabba Gruppman jabba at annuna.net
Mon Jun 2 13:34:44 UTC 2008


Hi all,

I run OpenSim in grid mode with 4 regions on 2 servers (3 + 1). It is 
conntected to a remote mysql server.

Until now I have 57 lines in the 'terrain' table which is currently 
about 34 mb in total size.
Also there is no index defined which makes me wonder...

Did I miss something? I did not find any sql definition for the terrain 
table at ./OpenSim/Data/MySQL/Resources

Also I am curious if there is any mechanism dealing with the number of 
table rows? Any compacting in effect?
If this table grows constantly it is not reasonable to define it without 
any index.

If this is 'normal' for all others too I will create a mantis because 
there is some functionality missing :)

Any ideas?

-- jabba.





More information about the Opensim-users mailing list