MonitorWare Knowledge Base

[shredman]

hello,

i have installed and configured successfully phplogcon with rsyslog and mysqldb on my debian lenny server. the database is filled with logs of 4 days and I wonder me why it takes so long to login to phplogcon webinterface? Sometimes it takes up to 30 seconds to login. The browsing between the syslog pages is also lame. Is it possible to speedup login and browsing ? maybe with indexing of syslog db tables ?

Short question to /etc/rsyslog.d/mysql.conf. I excluded some logs with this settings. Is it ok so ? Dont like the mass of debug messages from cyrus

$ModLoad ommysql
$RepeatedMsgReduction on
:msg, contains, "pam_unix(cron:session)" ~
:msg, contains, "checkpointing" ~
if $syslogseverity == '7' and $syslogfacility == '2' then ~
*.*;authpriv.info;cron.none :ommysql:localhost,Syslog,rsyslog,password

Thanks

regards
Frank

[rgerhards]

Hi Frank,

phpLogCon does not define indexes by default. This is done because which indexes are useful depends very much on your searches (but, granted, it would make sense to think about one or two indexes that are useful in any case...). So I'd expect that adding indexes can solved the performance issue you see.

On the rsyslog.conf question: from the rsyslog POV, there is no problem. But I can't tell you if it does for you what you want

HTH
Rainer

[Burn]

what size is your database?