Syslog plugin make Cacti very slow

[chhuan]

After I enabled syslog plugin the cacti became extremely slow. It takes > 5 minutes to reload the page. If I disable syslog plugin everything will back to normal.

I've noticed following error message in /var/log/syslog. Could it be the reason ??

Code: Select all

May 19 18:55:37 MYS-JBCO-S023 rsyslogd: message repeated 208 times: [db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 18:58:53 MYS-JBCO-S023 rsyslogd: db error (2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
May 19 18:58:53 MYS-JBCO-S023 rsyslogd: db error (2002): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
May 19 19:00:00 MYS-JBCO-S023 rsyslogd: db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 19:11:32 MYS-JBCO-S023 rsyslogd: message repeated 78 times: [db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 19:14:11 MYS-JBCO-S023 rsyslogd: db error (1016): Can't open file: './syslog/SystemEvents.frm' (errno: 24)
May 19 19:14:15 MYS-JBCO-S023 rsyslogd: db error (1016): Can't open file: './syslog/SystemEvents.frm' (errno: 24)
May 19 19:14:16 MYS-JBCO-S023 rsyslogd: db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 19:14:17 MYS-JBCO-S023 rsyslogd: message repeated 3 times: [db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 19:14:17 MYS-JBCO-S023 rsyslogd: db error (1016): Can't open file: './syslog/SystemEvents.frm' (errno: 24)
May 19 19:14:18 MYS-JBCO-S023 rsyslogd: db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 19:20:55 MYS-JBCO-S023 rsyslogd: message repeated 62 times: [db error (1146): Table 'syslog.SystemEvents' doesn't exist
May 19 19:24:10 MYS-JBCO-S023 rsyslogd: db error (1016): Can't open file: './syslog/SystemEvents.frm' (errno: 24)
May 19 19:24:13 MYS-JBCO-S023 rsyslogd: db error (1016): Can't open file: './syslog/SystemEvents.frm' (errno: 24)
May 19 19:24:15 MYS-JBCO-S023 rsyslogd: db error (1146): Table 'syslog.SystemEvents' doesn't exist

[phalek]

Did you follow the Syslog plugin install guide here ?

http://docs.cacti.net/plugin:syslog.config

[chhuan]

Did you follow the Syslog plugin install guide here ?

http://docs.cacti.net/plugin:syslog.config

Yes I've followed the guid.

I've also see this message in my phpmyadmin when I open table syslog_removed

Code: Select all

#23 - Out of resources when opening file './syslog/syslog_removed#P#d20130520.MYD' (Errcode: 24)

[cigamit]

A quick google comes up with this
http://chrisjohnson.blogsite.org/mysql- ... -on-linux/

[chhuan]

Guys:

It seems somehow Cacti working fine now. Thank you all for your help.