[syslog-ng] Syslog-Ng MySQL Performance Problem

[Balazs Scheidler]

On Tue, 2008-04-29 at 09:59 +0100, Hari Sekhon wrote:
> Hi,
> 
>    I've had a Syslog-NG Central Logserver -> MySQL setup for nearly 2 
> years now but am finding it has developed a performance problem with a 
> backed up pipe so I'm thinking of using batched inserts to try to 
> improve the db processing performance.
> 
> Before I go and code this myself, are there any good generic solutions, 
> somebody must have done this batched inserts before, I saw something on 
> the mailing list once I think but can't see it now...
> 
> Any other suggestions would also be welcome before I go off and do this.
> 
> Thanks

The current 2.1 codebase has native SQL support, although it does not
have batched inserts yet. However it is something that I also wanted to
implement, so I could give a hand. (although I have to admin I'm very
short on time these days)

-- 
Bazsi