Hi, Apart from identifying models/events that are flooding the database (this is always a good thing) you can rid of your archive folder.
When you configure the Reporting Preferences from the OneClick Administration Web Page, you specify how many days you're going to keep data and the Retention Policy (purge / archive / all data). With Archive Policy, Spectrum wrap up old records and store then in archive database. With Purge Policy, Spectrum purge old records and archive folder is empty. You can safely remove this files if you don't need to keep old records for auditing. (anyway, I don't know how you can use this information!!!) Regards. James. On Thu, Jul 7, 2011 at 4:29 PM, Mark Serencha <[email protected]> wrote: > The event database is the Archive Manager’s DDM, which feeds the SRM > Reporting database. > > > > You first should identify which models and/or events are flooding the > database and take steps to suppress them in Spectrum. > > > > I have a forum post with some helpful MySQL queries, attached below. > > > > https://communities.ca.com/web/ca-ehealth-and-ca-spectrum-global-user-community/message-board/-/message_boards/message/19092564 > > > > HTH, > > --Mark S > > > > ________________________________ > > Mark Serencha – Inforonics Global Services, LLC – (m) +1-781-439-0519 – > Mark.Serencha_AT_inforonics.com > > > > From: Mickey Alderson [mailto:[email protected]] > Sent: Thursday, July 07, 2011 10:19 AM > To: spectrum > Subject: [spectrum] report manager - mysql > > > > Disclaimer: My apologies in advance if this is an easy issue that I should > know... > Disclaimer 2: We are currently working without a maintenance agreement due > to some financial difficulties that our customer is having, although we hope > that will change fairly soon... > > Spectrum environment: Win2k3, version 9.1.1.7.13 > > I'm running into an issue where I have over 100Gb of data in the > SPECROOT\mysql folder, 64.4Gb of which is in the SPECROOT\mysql\data\archive > folder. I ran the db_optimize and db_maintenance scripts last night, which > got 5Gb of HD space back, but I need to try to do something with the archive > folder, and possibly the file sizes of some of the files in the > SPECROOT\mysql\data\reporting folder (for example, the event.MYD file is > currently just under 25Gb by itself.) Reading the Report Manager manual > didn't exactly help point me in the right direction as to what I need to do, > so I'm appealing to the list here for assistance. > > -- > Mickey Alderson > Sr. Network Engineer > ACS, A Xerox Company > mobile. 901.833.4908 > email. [email protected] > > --To unsubscribe from spectrum, send email to [email protected] with the > body: unsubscribe spectrum [email protected] > > --To unsubscribe from spectrum, send email to [email protected] with the > body: unsubscribe spectrum [email protected] --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
