Hmmm. When I was in the DB manually editing all my regions' ground textures and so (36 region megaregion, this was far quicker than doing it in-sim), I noticed a lot of old regiondata from earlier iterations of my OpenSim experiments hanging about too. I was able to hand-delete all the unwanted regioninfo from the mySql tools, but the tools didn't want to let me enter edit mode for the binary blobs of region heightmaps, so I couldn't work out how to hand-delete those.
I imagine, like Karen, there is also a lot of dangling cruft built up in my inventory too. Since I am the only user for now, would it be fair to say anything in world or in my current inventory has been 'touched' last login, and assuming mySql does (or can) flag touch dates for entries, could I just find the method of deleting all entries untouched since my last login (after a full backup of course)? Lae On Tuesday December 22 2009 09:52:22 Karen Palen wrote: > My OpenSim database now tops 1Gb with only a single region! > > Looking at the database with MySql tools shows that there is a whole lot of > stuff that I have tried and discarded still in the database and that it > does not seem to be flagged for removal. > > Is there some OpenSim database maintenance tool that I haven't found yet? > > How DO people like OSGrid keep the database to a manageable size? > > Karen > > > > _______________________________________________ > Opensim-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
