MonitorWare Knowledge Base

I have a lot of servers, 30-50, is it better to use mysql logging, log to a file?

TIA

From the performance point of view, logging to a file is *much* (much!) faster than writing to a database. But, of course, it depends on the volume of incoming data. With rsyslog queued modes, you can also write massive amounts of messages into the database, even if you server is not fast enough to handle it

Here are the details:

http://www.rsyslog.com/doc-rsyslog_high ... _rate.html

Rainer
PS: To remain honest, the server must be capable of handling the message volume at some time. But it must not be capable to handle it immediately. Messages may be queued for some hours...

So if processing power wasn't an issue, you'd say go with mysql?

Yes - of course assuming, that you actually need the database functionality. But in general, if you can put things into a database, analysis is simpler.