You can use the mySQL procedure clean_event_history to clear out the event history database if the database gets too large to allow for reasonable speeds of data processing. From the command line, users can execute the MySQL procedure like this:

$ mysql events -uzenoss -pzenoss -e 'call clean_history(12)'

The above example assumes the MySQL username is zenoss, and the password is zenoss, and the number of months you want to keep is 12.

The only variable you need to pass is the “months” and this is the number of months back from where you want to start to delete the history. For example, if you wanted to remove all events older than 12 months in the event history database, enter 12.