[syslog-ng] Performance of syslog-ng for Database access (mysql)

[Patrick H.]

Neither. The performance on both will be about the same (immeasurable 
difference). The libdbi mysql is probably better though as it gracefully 
handles disconnects and is simpler to configure (than an external mysql 
process).

-Patrick

Sent: Mon Jan 17 2011 19:11:09 GMT-0700 (Mountain Standard Time)
From: Yu Watanabe <yu.watanabe at jp.fujitsu.com>
To: syslog-ng at lists.balabit.hu
Subject: [syslog-ng] Performance of syslog-ng for Database access (mysql)
> Hello all.
>
> I would like to ask question for the performance of syslog-ng when it is accessing to mysql database.
>
> I am using syslog-ng 3.0.9 and thinking of using either one of the method below for the database connection.
>
> 1. Using the program driver and fork the "mysql command" to execute the sql.
> 2. Use the sql driver to access to the table
>
> I was wondering which is more efficient for syslog-ng and the server itself (i.e. CPU , memory )
>
> Any advice would be helpful!
>
> Thanks,
> Yu Watanabe
>  
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20110117/a5c4dffb/attachment.htm