Hi Ai, It has been my experience that when I take the approach of saving
and reloading OAR/IAR files to a new fresh database it usually does
result in a smaller assets table (as compared to the previous database)
but I suppose the space gain all depends on how many unreferenced assets
there were on the previous database.
As far as I can tell, IAR and OAR saves work by only collecting assets
that are referenced on the regions that have had OARs made from, and any
assets that are referenced in the path specified for IARs that are
created from user inventories. Any thing left over will be gone once a
new empty database is created.
I am not 100% certain since I am only going by what I have observed in
the process of saving/loading archives and transferring to a new
database so anyone please by all means correct me if I'm not entirely
accurate here :)
On 4/11/2013 9:39 AM, Ai Austin wrote:
Our OpenSim grid has been running continuously since version 0.4 from
September 2007... and has probably by now accumulated a LOT of stuff
that has not been garbage collected.
We are changing to some new more powerful core servers in the next few
weeks, and I had an idea of how to do the upgrade that MIGHT get rid
of the clutter while still keeping in place the region UUIDs (for web
map servers, etc), the avatar UUIDs for permissions and .ini files
that refer to these, and even perhaps the UUIDs of key assets in case
they are in scripts.
but i am assuming that the IARs and OARs work by trying to reuse the
UUIDs if they are not already use din the data base.
Will this process work..
1. Save each region as an OAR and the avatar inventories we wish to
carry over as an IAR
2. Create a completely fresh data base - empty.
3. Create the avatars we want to preserve using the ption to set a
specific UUID for them
4. Start up with the original region.ini files which have the old UUID
in them
5. restore the OARS to the relevant regions, and the IARs to the
relevant avatars.
6. Then fingers crossed we have a smaller neater, no clutter version
of what we have now?
Or is that just plain silly and we have to take over more, or dump to
SQL and restore the data base as is?
Any comments from devs or those with experience of a migration would
be appreciated before we try this if its going to be a waste of time. Ai
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
--
OpenSim: 10 Region Standalone on 0.7.6 Dev
Physics: Open Dynamics Engine
OS: Windows 7 (x64)
CPU: AMD Phenom II X4 840 3.2 GHz
Memory: 11 GB DDR3
Database: MySQL 5.1.63 (x64)
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
