<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">One thing
that *might* be faster is to write a perl program to do the inserts.
Perl's DBD::mysql driver allows you to use prepared statements and bind
handles, which significantly speed up the database side of the
operations. Both the command line mysql client and the libdbi mysql
driver have to parse every single statement they come across and also
perform permission checks on the statement, which slows things down.
The tradeoff is that perl isnt the fastest thing in the world, so I
cant say if perl+prepared statements is faster or slower than
libdbi+parsing.<br>
<br>
-Patrick<br>
</font></font><br>
Sent: Mon Jan 17 2011 19:58:16 GMT-0700 (Mountain Standard Time)<br>
From: Patrick H. <a class="moz-txt-link-rfc2396E" href="mailto:syslogng@feystorm.net"><syslogng@feystorm.net></a><br>
To: Syslog-ng users' and developers' mailing list
<a class="moz-txt-link-rfc2396E" href="mailto:syslog-ng@lists.balabit.hu"><syslog-ng@lists.balabit.hu></a> <br>
Subject: Re: [syslog-ng] Performance of syslog-ng for Database access
(mysql)
<blockquote cite="mid:4D3501C8.7090600@feystorm.net" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<font size="-1"><font face="Helvetica, Arial, sans-serif">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).<br>
<br>
-Patrick<br>
</font></font><br>
Sent: Mon Jan 17 2011 19:11:09 GMT-0700 (Mountain Standard Time)<br>
From: Yu Watanabe <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E" href="mailto:yu.watanabe@jp.fujitsu.com"><yu.watanabe@jp.fujitsu.com></a><br>
To: <a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a>
<br>
Subject: [syslog-ng] Performance of syslog-ng for Database access
(mysql)
<blockquote cite="mid:201101180211.AA03156@S2007337.jp.fujitsu.com"
type="cite">
<pre wrap="">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: <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
<pre wrap="">
<hr size="4" width="90%">
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
</body>
</html>