09-14-2009 08:31 PM - edited 03-10-2019 04:45 AM
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
Solved! Go to Solution.
09-22-2009 07:39 PM
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.
09-18-2009 09:59 AM
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.
09-22-2009 07:54 AM
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?
09-22-2009 07:39 PM
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.
10-16-2015 01:25 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide