SQL for logging?
Posted: Mon Feb 04, 2008 1:54 pm
I was just asking myself: Why don't people use a database (e.g. MySQL) for general logging purposes?
It's sometimes really hard to gather information from several logs which must manually be brought into correlation in order to track down certain events. If apps would have a somewhat common logging format and all write into a database, I could do a:
or something like that. Don't have much time now to think it through. just an idea.
It's sometimes really hard to gather information from several logs which must manually be brought into correlation in order to track down certain events. If apps would have a somewhat common logging format and all write into a database, I could do a:
Code: Select all
select * from entry where type='error' and (timestamp > xxx and timestamp < yyy) and debuglevel > 3or something like that. Don't have much time now to think it through. just an idea.