Event flood has been my experience - do some reports on what events happen the most and maybe tune them out in the EventDisp (if they are irrelevant for reporting). Thats what I did
On 1 June 2011 02:03, James Garthek <[email protected]> wrote: > Hi, > > I'm using same procedure. > > And if DB is increasing quickly, maybe, something's happening!!! Probably > you have some devices generating a lot of events (lot of traps?). You should > check that. > > In spectrum 8.x there was a tool to optimize reporting database > ($SPECROOT/bin/RpmgrOptimizeDatabase). But it was drop!!! Don't know why. I > think it was a useful tool to remove old data. > > Regards. > James. > > > > > On Tue, May 31, 2011 at 7:59 AM, Gasper Krajnik < > [email protected]> wrote: > >> Hi, >> >> >> >> I have opened ticket on CA Support for same problem. I think CA don't have >> regular solution for this problem. >> >> We solve it with these procedures: >> >> >> >> 1. Run bash -login >> >> 2. Go to folser "%SPECTROOT%/mysql/bin" >> >> 3. Run "./mysql -uroot -proot" >> >> 4. "use reporting" >> >> 5. "optimize tables event;" >> >> >> >> When optimization will be finished, you have to flush tables: >> >> >> >> 6. "flush tables;" >> >> >> >> You can repeat steps also for other tables. >> >> >> >> BR, >> >> >> >> [image: cid:[email protected]] >> >> *mag. Gašper Krajnik *| [email protected] | GSM: +386 >> 41 999 599** >> >> >> >> >> >> *From:* [email protected] [mailto: >> [email protected]] >> *Sent:* Tuesday, May 31, 2011 7:01 AM >> *To:* spectrum >> *Cc:* spectrum >> *Subject:* [spectrum] Reporting database isze increasing >> >> >> >> >> Hi, >> >> From last one month we are facing reporting database issue, the reporting >> database size is increasing immensely. On daily basis its consuming nearly >> about 5 GB.Around 1 month back the reporting database size was just 60 GB, >> we use to delete the archive database after every 1 month now we have to >> delete the archive database daily. Pls suggest >> >> With Regards, >> MOhan >> Unicenter Support >> Wipro Infotech >> TEL: +91-22-3075-3943/3944 >> Mail to: [email protected] >> >> “Kindly log a call on http://usdprdweb2/CAisd/pdmweb.exe for any USD >> related assistance" >> Calls logged in USD would be prioritized >> >> HDFC Bank has been recognized as "The Strongest Bank in Asia Pacific >> Region" by The Asian Banker, outperforming 59 top tier banks across 13 >> countries. >> ____________________________________________ >> >> Disclaimer: >> "The information contained herein (including any accompanying documents) >> is confidential and is intended solely for the addressee(s). If you have >> erroneously received this message, please immediately delete it and notify >> the sender. Also, if you are not the intended recipient, you are hereby >> notified that any disclosure, copying, distribution or taking any action in >> reliance on the contents of this message or any accompanying document is >> strictly prohibited and is unlawful. The organization is not responsible for >> any damage caused by a virus or alteration of the e-mail by a third party or >> otherwise. The contents of this message may not necessarily represent the >> views or policies of HDFC Bank Ltd." >> >> - --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] > > --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
<<image001.jpg>>
