Hi All,
nxlog feature list specifies that it can handle 100.000 events per second
(EPS); However I tried to sent 100.000 logs over tcp and write it to mysql
database and it took over a minute. I suspected that the libdbi
performance is lower first. So, I inspected libdbi mysql performance and
write a c code to insert same data, it took 7 seconds. So the problem seems
to be with nxlog server when writing to database.
How can I configure to get the expected performance 100.000 EPS. Here is my
configuration:
<Input in>
Module im_tcp
Host 0.0.0.0
Port 514
Exec parse_syslog();
</Input>
<Output dbi>
Exec parse_syslog_bsd();
Module om_dbi
SQL INSERT INTO log (facility, severity, hostname, timestamp, application,
message) \
VALUES ($SyslogFacility, $SyslogSeverity, $Hostname, '$EventTime',
$SourceName, $Message)
Driver mysql
Option host localhost
Option username admin
Option password somepasswd
Option dbname NXLOGS
</Output>
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
nxlog-ce-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nxlog-ce-users
