IPS Manager Express - archiving old events

Answered Question
Sep 14th, 2009
User Badges:

Hi everyone


How can we archive or delete old events in IME? The .myd files in MYSQL\data\alarmDB are getting bigger and bigger and it is affecting the server.


Thanks

Correct Answer by marcabal about 7 years 6 months ago

The database files can not just be simply removed.


If IME is still functioning, then you can do the following:

Select Tools->Preferences

Modify the "Maximum number of events in current event file", and the "Maximum number of archived files".


The maximum number of events will reduce the largest size that each event file can become.

The maximum number of archived files will reduce the total number of database files that will be saved.


You may also want to "Enable time schedule for archiving events", and temporarilly set it to every 10 minutes.


Then keep an eye on the alarmDB directory over the next hour or 2.

Continue to change the settings until you are comfortable with the amount of disk space it will be using.

You may also want to change the archive internal to once a day in order to prevent a lot of small 10 minute files in the future.


If you need to save old alarm information, then you may want to first export the old alarm data before making the changes above.

Select the File->Export option and select the time frame you want exported and browse to a directory on another disk where you want the file created.



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
hadbou Fri, 09/18/2009 - 09:59
User Badges:
  • Bronze, 100 points or more

you must clear the event archive of the older events by using the clear events command.


Clearing Events


Use the clear events command to clear Event Store.


To clear events from Event Store, follow these steps:


Step 1 Log in to the CLI using an account with Administrator privileges.


Step 2 Clear Event Store.


sensor# clear events


Warning: Executing this command will remove all events currently stored in the event

store.


Continue with clear? []:



Step 3 Enter yes to clear the events.

osiristrading Tue, 09/22/2009 - 07:54
User Badges:

Thanks for the info, but this does not clear up any space on the IME server at all. Is there any way to remove the .myd files without breaking IME?

Correct Answer
marcabal Tue, 09/22/2009 - 19:39
User Badges:
  • Cisco Employee,

The database files can not just be simply removed.


If IME is still functioning, then you can do the following:

Select Tools->Preferences

Modify the "Maximum number of events in current event file", and the "Maximum number of archived files".


The maximum number of events will reduce the largest size that each event file can become.

The maximum number of archived files will reduce the total number of database files that will be saved.


You may also want to "Enable time schedule for archiving events", and temporarilly set it to every 10 minutes.


Then keep an eye on the alarmDB directory over the next hour or 2.

Continue to change the settings until you are comfortable with the amount of disk space it will be using.

You may also want to change the archive internal to once a day in order to prevent a lot of small 10 minute files in the future.


If you need to save old alarm information, then you may want to first export the old alarm data before making the changes above.

Select the File->Export option and select the time frame you want exported and browse to a directory on another disk where you want the file created.



satyajit.samal1 Fri, 10/16/2015 - 01:25
User Badges:

Hello,

 

I am facing similar issue with increasing the size of alarmDBDemo folder as the size is increasing day by day and it also reduces the performance of server. it is generating approximately files size of 2gb a day.

I need to understand the alrm dbdemo and cal i delete older files

 

Attachment: 

Actions

This Discussion