cluther wrote: > 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.
Or, this might be indicative of something other than a really noisy box. It seems to me that 26GB is a lot of data for 80-some-odd servers to be logging in just a few weeks, any way you slice it. Especially if the db has been truncated multiple times. Of course, it could be a misconfiguration somewhere as well. But I don't think it's something to dismiss out-of-hand without more information. I just checked my log size, and granted I don't have any terribly noisy boxes, but my entire mysql db directory takes up less than 300MB or so: Code: [EMAIL PROTECTED] mysql]$ pwd /var/lib/mysql [EMAIL PROTECTED] mysql]$ sudo du -sh * 136K events 259M ibdata1 5.1M ib_logfile0 5.1M ib_logfile1 888K mysql 4.0K mysql.sock 8.0K test I asked our network engineering department how much our inet routers are logging to syslog currently (*very* noisy, with the amount of logging we're doing) and they responded back with about 150MB/day. That means it would take our routers 6 months to generate 27GB of data (or so). Just how much are you logging to zenoss? Anyway, that's just my two cents. I'd like to know what size other people's databases are sitting at, to get somewhat of a db size baseline as compared to device count. Anyone else? seth wright ([EMAIL PROTECTED]) windows engineer 540.568.2912 (office) james madison university -------------------- m2f -------------------- Read this topic online here: http://community.zenoss.com/forums/viewtopic.php?p=12901#12901 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
