I've been encountering a somewhat frustrating problem. I using
2.1.0 to monitor approximately 80 different devices (servers,
printers, firewall, and misc. network devices). Some devices are
obviously noisier than others (like my firewall).
I absolutely love Zenoss, it's been an incredible improvement over
the usability of Nagios. However my MySQL database continues to
grow out of control regardless of what I do. I've had to scrap the
whole database and start over several times. Several weeks after
the I deleted the database and started over it's already over 26Gb
and growing.
When the database gets this big the performance is horrible. I
can't even delete the history table rows without getting an error
message. When I click on a server for details, it takes
approximately 3 minutes before it appears due to the database
performance.
Has anyone encountered this type of problem? I'm sure there must be
a way to keep the database from growing so much but I'm baffled as
to how. I'd like to think that Zenoss can scale to a medium size
location like mine and I'm just missing something.
You have three options.
1. Stop your noisy devices from logging so much to Zenoss.
2. Use Zenoss event mapping rules to "drop" events that you don't
care about.
3. Get a beefy MySQL server that has enough RAM and a proper
configuration to deal with this much data.
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
