[rsyslog] mysql inserts and message queues

Rory Toma rory at ooma.com
Wed Jul 30 03:14:52 CEST 2008


I have enabled mysql and disk message queues as per below:

$ModLoad immark.so # provides --MARK-- message capability
$ModLoad imuxsock.so # provides support for local system logging (e.g. 
via logger command)
$ModLoad imklog.so # kernel logging (formerly provided by rklogd)
$ModLoad ommysql.so
$ModLoad imudp.so  # provides UDP syslog reception
$UDPServerRun 514 # start a UDP syslog server at standard port 514

$WorkDirectory /var/rsyslog

$ActionQueueType LinkedList
$ActionQueueFileName dbq
$ActionResumeRetryCount -1

*.*    :ommysql:127.0.0.1,Syslog,syslogwriter,writeme
# *.*    /var/log/messages


The question I have is... does the disk queue drain w/o me having to 
intervene? I currently have 323 queue files (I was adding some keys and 
playing with tuning mysql... kind of slowed it down) and the number of 
queue files is not going down.

thx


More information about the rsyslog mailing list