Re: [Perfparse-users] Large Database

[Ben C. <bcl...@pe...>]

Sorry about that, MySQL is a bit slow on the deletion.

If you run the deletion over night every night, then a days data deletes 
a bit better.

You may want to trim it by a few days at a time over night and see how 
that goes...

Ben


barry maclean wrote:
> I have been gathering stats over 700+ servers for 3-4 months and the database has grown to 75GB. I'm looking to tidy up the database and only have 1 month on-line. I know this should have been done at the start. 
> 
> When I try and run a script to delete entries before a date it does delete but very very slow. Any help on tuning the database would be great.
> 
> Many Thanks Barry
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>