[syslog-ng] syslog-ng droping events

[Vivek Khera]

On Nov 10, 2006, at 4:24 AM, Alexander Clouter wrote:

>
> Sounds like, what DB monkeys call, 'SQL Exhaustion' or something.   
> You SQL
> database is slowing up the whole process...mainly as SQL is not  
> suitable for
> *live* realtime processing, thats my opinion though.

We have one very hot process that we log to a file first, then in  
batches stuff into a database.  Doing one single insert transaction  
per log line is death to a DB.  If you can do them in batches all in  
one transaction, it can help a lot.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
Url : http://lists.balabit.hu/pipermail/syslog-ng/attachments/20061110/344ac873/smime.bin