Hi Ken,
Thanks for your reply. Here are the software and hardware details.
rsyslog version is
-bash-4.1# /sbin/rsyslogd -v
rsyslogd 5.8.10, compiled with:
FEATURE_REGEXP: Yes
FEATURE_LARGEFILE: No
GSSAPI Kerberos 5 support: Yes
FEATURE_DEBUG (debug build, slow code): No
32bit Atomic operations supported: Yes
64bit Atomic operations supported: Yes
Runtime Instrumentation (slow code): No
See http://www.rsyslog.com for more information.
Mysql version
-bash-4.1# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Server version: 5.1.69-log Source distribution
server: Tyrone (make), running with cent os
-bash-4.1# uname -a
Linux localhost.localdomain 2.6.32-279.14.1.el6.x86_64 #1 SMP Tue Nov 6
23:43:09 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
4 processors (core)
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 58
model name : Intel(R) Xeon(R) CPU E3-1220 V2 @ 3.10GHz
stepping : 9
cpu MHz : 1600.000
cache size : 8192 KB
-bash-4.1# vmstat
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu-----
r b swpd free buff cache si so bi bo
in cs us sy id wa st
0 0 0 14212576 62620 444372 0 0 8 14 67 466
1 0 99 1 0
it is a dedicated server, so no applications run other than mine.
top - 20:49:02 up 1:28, 3 users, load average: 0.00, 0.00, 0.00
Tasks: 167 total, 1 running, 166 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni, 99.8%id, 0.2%wa, 0.0%hi, 0.0%si,
0.0%st
Mem: 16306500k total, 2094304k used, 14212196k free, 62644k buffers
Swap: 8224760k total, 0k used, 8224760k free, 444468k cached
Thanks
Mahesh
On Wed, Jun 12, 2013 at 7:52 PM, [email protected] <[email protected]> wrote:
> On Wed, Jun 12, 2013 at 07:44:50PM +0530, Mahesh V wrote:
> > Hello,
> >
> > The software i work, has syslog facility enabled for debug logs.
> > It generates a huge amount of logs (12000 lines in 2 minutes) - about 100
> > log entries per second and this is put into a mysql backend.
> > However, I see that after about 2 minutes of run, my application stalls
> > and if I disable (delete the SystemEvents table in Syslog database), my
> > application continues fine.
> > My my.cnf and rsyslog.conf is attached along.
> > Any ideas?
> >
> > Thanks
> > Mahesh
>
>
> Hi Mahesh,
>
> You sent a lot of software configuration information, but none on your
> DB hardware and I/O configurations. It sounds like you do not have enough
> capacity there, but this is complete speculation without the actual
> details.
>
> Cheers,
> Ken
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
> http://www.rsyslog.com/professional-services/
> What's up with rsyslog? Follow https://twitter.com/rgerhards
> NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad
> of sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you
> DON'T LIKE THAT.
>
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE
THAT.