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