[Opensim-dev] Opensim database management - garbage collection

[Sean Dague]

Mike Mazur wrote:
> Hi,
> 
> On Thu, Jan 15, 2009 at 7:34 PM, Ai Austin <ai.ai.austin at googlemail.com> wrote:
>>> In a grid where you control all the regions and databases, it should be
>>> feasible to write a tool that can discover inaccessible assets.
>>> ...
>>> AFAIK the texture remains in the DB forever.
>> [...]
>>
>> A command console level thing to perhaps run to tidy up one or two
>> types of setup MIGHT be worthwhile though?  Opensim databases cannot
>> grow forever or we will all have trouble.
> 
> If you are running one of the specific types of setup, you can equally
> well grab this cleanup script from a third-party site (such as the
> OpenSim Forge) and run it regularly. In my opinion, this functionality
> doesn't need to live in core.

Agreed.  I added the access time to mysql to support people writing
those kinds of reapers, but every grid is going to have it's own policy.
 I'd suggest that policy stay out of core, but if you want to put
something up on the forge, that would be great.

	-Sean

-- 
Sean Dague / Neas Bade
sdague at gmail.com
http://dague.net


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20090116/c8c0587d/attachment-0001.pgp>