[Opensim-users] Database cleanup

Wed Dec 23 10:29:30 UTC 2009

Actually I was hoping to find some neat script somewhere that just fixed the problem forever.  

Well I can dream at least ...

They say that a true programmer is someone who spends a week automating a 20 minute problem and feels good about the result :-)

I suspect that I will have to end up with multiple databases though. An "experimental" one and a "build things" one. 

Probably isolated in dedicated virtual machines like I do with software tryouts. 

It is amazing how many Windows problems go away when an app is the ONLY one installed on a VM for example. That strategy has also served me well in isolating trojans and "backdoors" in commercial software. So far no major packages (like the infamous Turbo-Tax DRM that permanently crippled your machine a few years ago), but I use and beta test a wide range of stuff and it amazing what you find sometimes.

Karen

--- On Tue, 12/22/09, William Magee <billmagee at gmail.com> wrote:

> From: William Magee <billmagee at gmail.com>
> Subject: Re: [Opensim-users] Database cleanup
> To: opensim-users at lists.berlios.de
> Date: Tuesday, December 22, 2009, 7:50 PM
> Oh, Karen sorry I did not see that it
> was you when I mentioned
> phpmyadmin. Of course I know you are an Ubuntu user.
> 
> Have you considered making a copy and running database
> experiments
> safely on a cloned sim?
> 
> Cheers,
> Bill
> 
> On Wed, Dec 23, 2009 at 8:24 AM, Karen Palen <karen_palen at yahoo.com>
> wrote:
> > I use the same set-up (MySql Admin/Ubuntu). Works
> nicely, but I have to believe that the job would be cleaner
> and safer with the usage and cross reference knowledge in
> the OpenSim app!
> >
> > I am very cautious about fiddling witht he contents of
> databases directly there are too many subtle things that can
> get screwed up!
> >
> > Karen
> > --- On Mon, 12/21/09, William Magee <billmagee at gmail.com>
> wrote:
> >
> >> From: William Magee <billmagee at gmail.com>
> >> Subject: Re: [Opensim-users] Database cleanup
> >> To: opensim-users at lists.berlios.de
> >> Date: Monday, December 21, 2009, 11:32 PM
> >> I use phpmyadmin to fiddle around in
> >> MySQL. It provides a gui for your
> >> databases. I use Ubuntu; not sure what you might
> use with
> >> some other
> >> operating system, but I am sure there are
> options.
> >>
> >> On Tue, Dec 22, 2009 at 2:07 PM, Karen Palen
> <karen_palen at yahoo.com>
> >> wrote:
> >> > That is one way to solve the problem,
> although I don't
> >> know MySQL well enough to figure out how!
> >> >
> >> > I was actually hoping that OpenSim had some
> built in
> >> utility that would do this in a more intelligent
> way though.
> >> Essentially the knowledge about what is deleted or
> not is
> >> fairly high level information within OpenSim
> itself. A
> >> "touch" would at best be an emulation of this.
> >> >
> >> > Ideally this would run regularly and keep
> down the
> >> "cruft" build-up.
> >> >
> >> > Next best would be to dump each region to an
> OAR file,
> >> each avatar's inventory to an IAR file then build
> a new
> >> database from that! It would work, but could take
> several
> >> days of effort to make sure that it was done
> right. My next
> >> thought is to use Second Inventory to do the same
> thing, but
> >> that could be even slower!
> >> >
> >> > Karen
> >> >
> >> > --- On Mon, 12/21/09, LaeMing <laeming at exemail.com.au>
> >> wrote:
> >> >
> >> >> From: LaeMing <laeming at exemail.com.au>
> >> >> Subject: Re: [Opensim-users] Database
> cleanup
> >> >> To: opensim-users at lists.berlios.de
> >> >> Date: Monday, December 21, 2009, 7:34 PM
> >> >> 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
> >> >> > Opensim-users at lists.berlios.de
> >> >> > https://lists.berlios.de/mailman/listinfo/opensim-users
> >> >> >
> >> >>
> >> >>
> _______________________________________________
> >> >> Opensim-users mailing list
> >> >> Opensim-users at lists.berlios.de
> >> >> https://lists.berlios.de/mailman/listinfo/opensim-users
> >> >>
> >> >
> >> >
> >> >
> >> >
> _______________________________________________
> >> > Opensim-users mailing list
> >> > Opensim-users at lists.berlios.de
> >> > https://lists.berlios.de/mailman/listinfo/opensim-users
> >> >
> >>
> >>
> >>
> >> --
> >> William Magee, Ph.D.
> >> XVIth Congress of the IABS, Planning Committee
> Chair
> >> Dharma Drum Buddhist College
> >> Jinshan, Taiwan
> >> _______________________________________________
> >> Opensim-users mailing list
> >> Opensim-users at lists.berlios.de
> >> https://lists.berlios.de/mailman/listinfo/opensim-users
> >>
> >
> >
> >
> > _______________________________________________
> > Opensim-users mailing list
> > Opensim-users at lists.berlios.de
> > https://lists.berlios.de/mailman/listinfo/opensim-users
> >
> 
> 
> 
> -- 
> William Magee, Ph.D.
> XVIth Congress of the IABS, Planning Committee Chair
> Dharma Drum Buddhist College
> Jinshan, Taiwan
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
> 