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-co mmunity/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]
