[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dragonidsuser
Subject:    Re: [Dragonidsuser] Problems with purge-data.pl
From:       Mike Iglesias <iglesias () draco ! acs ! uci ! edu>
Date:       2004-09-09 20:47:24
Message-ID: 200409092047.i89KlOdO021453 () draco ! acs ! uci ! edu
[Download RAW message or body]

> We found that due to the amount of data in our database, increasing the
> max_allowed_packet variable to even a very large number does not always
> work.  I ended up editing the purge-data.pl script so you can also use
> times in addition to dates to define the data you wish to delete.  By
> decreasing the amount of data being queried and deleted (sometimes down to
> 30 min or an hour at a time), you should be able to avoid the errors.  I've
> attached the edited purge-data.pl.

Thanks.  If it got to the point where I had to get down to something more
granular than a day, I'd just turn off the trending stuff and forget about
it.  It's not worth that kind of effort to me.


Mike Iglesias                          Email:       iglesias@draco.acs.uci.edu
University of California, Irvine       phone:       949-824-6926
Network & Academic Computing Services  FAX:         949-824-2069
_______________________________________________
Dragonidsuser mailing list

For help please follow the below instructions.
You can make subsciption adjustments via email by sending a message to:

  Dragonidsuser-request@enterasys.com

with the word `help' in the subject or body (don't include the quotes), and you will \
get back a message with instructions.

You must know your password to change your options (including changing the password, \
itself) or to unsubscribe.   If you forget your password, don't worry, you will \
receive a monthly reminder telling you what all your enterasys.com mailing list \
passwords are, and how to unsubscribe or change your options.  


[prev in list] [next in list] [prev in thread] [next in thread]