Hi All,
I have configured rsyslog writing to Oracle.The writing was successful.But after several messages have been made into Oracle,the CPU use percentage of rsyslogd goes up to 99%-100%.It is abnormally too much high. There's no problem with the cpu usage when writing to files. Here is my rsyslogd.conf: #==================================================== #*.* >192.168.45.213,rsyslog # Use traditional timestamp format $ActionFileDefaultTemplate RSYSLOG_TraditionalFileFormat # Provides kernel logging support (previously done by rklogd) $ModLoad imklog # Provides support for local system logging (e.g. via logger command) $ModLoad imuxsock # Log all kernel messages to the console. # Logging much else clutters up the screen. #kern.* /dev/console # Log anything (except mail) of level info or higher. # Don't log private authentication messages! *.info;mail.none;authpriv.none;cron.none /var/log/messages # The authpriv file has restricted access. authpriv.* /var/log/secure # Log all the mail messages in one place. mail.* -/var/log/maillog # Log cron stuff cron.* /var/log/cron # Everybody gets emergency messages *.emerg * # Save news errors of level crit and higher in a special file. uucp,news.crit /var/log/spooler # Save boot messages also to boot.log local7.* /var/log/boot.log #Load External Listender $modload imudp $UDPServerRun 514 #SPA Messages #*.* /var/log/linksys.log $template DynaFile,"/var/log/system-%HOSTNAME%.log" *.* -?DynaFile ################ #### ORACLE #### ################ $ModLoad omoracle $OmoracleDBUser syslog $OmoracleDBPassword syslog $OmoracleDB syslog $OmoracleBatchSize 1 $OmoracleBatchItemSize 4096 $OmoracleStatementTemplate OmoracleStatement $template OmoracleStatement,"INSERT INTO TEST(hostname,message) VALUES(:hostname,:msg)" $template TestStmt,"%hostname%%msg%" *.* :omoracle:;TestStmt #==================================================== Really appreciate anyone's help! Best _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
