I accidently deleted your reply, so I am replying to my message
4-5 messages/secshould not be any problem at all.
since writing a copy of the sql commands to a file doesn't show anything
strange, the next step will be to try and run it in debug mode to see if
it logs anything strange as you start having problems.
the next step after that will probably be to do a strace of the thread
that is using all the CPU
I don't see where you mention what version of rsyslog you are using.
David Lang
On Mon, 9 May 2011, [email protected] wrote:
Date: Mon, 9 May 2011 10:56:30 -0700 (PDT)
From: [email protected]
Reply-To: rsyslog-users <[email protected]>
To: rsyslog-users <[email protected]>
Subject: Re: [rsyslog] help : CPU high load of rsyslog writing to Oracle
given that it only happens after a few messages, I would suspect that there
is something odd with the messages.
could you try writing the messages to a file using the Oracle template and
then look and see if there is anything odd about the messages when it goes
nuts?
the other option is to get a debug dump, but unless it happens right away,
that is likely to be a large dump.
David Lang
On Mon, 9 May 2011, bxu wrote:
Date: Mon, 9 May 2011 10:48:50 -0500
From: bxu <[email protected]>
Reply-To: rsyslog-users <[email protected]>
To: [email protected]
Subject: [rsyslog] help : CPU high load of rsyslog writing to Oracle
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
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com
