So, my current mysql rsyslog drops about 20 million rows of data per day. Over time, this gets slow as tables grow.
I'm not a dba, so I was wondering if anyone had some suggestions for keeping performance still on the order of seconds, and not minutes or hours. thx I did add a key for EventSource, as that is commonly searched. However, using PhpLogCon, it seems that if I search using the web interface (i.e. I click on a host entry and hit the available searches) it is relatively quick. However, changing the text field that is generated and hitting the "search" button is slow. Do these two methods use the same query, or is something else going on? thx _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog
