Empty Haloe

brononi · Joined: 29 Aug 2006 Posts: 24

I think that we've got to much information in our syslog db.
When i try to open haloe, i takes about 10 minutes before it opens, and when i select some else, it takes again more then 10 minutes.

Is there a way to empty the data that is in there? I think there's to much in there. we made a mistake and sent all our firewall logs to the machine, so i think it was a little bit to much...

The rest of the machine is working fine...

harner · Cacti User Joined: 17 Oct 2006 Posts: 71 Location: PA, USA

We had the same issue, and ever since I rebuilt Cacti on a new server we just cannot get the syslog plugin to work again. I've played with exceptions and everything and it doesn't seem to improve performance. I'm hesitant to even troubleshoot Haloe since I'm afraid it's going to be useless after a few weeks of data.

chrisgapske · Posted: Wed Jun 04, 2008 9:45 am Post subject:

Try this.
http://forums.cacti.net/viewtopic.php?t=25876&highlight=

Try to optimize the syslog mysql table.

OPTIMIZE TABLE table_name[,table_name]

That helped me..

brononi · Joined: 29 Aug 2006 Posts: 24

I just need to run this command?

-> OPTIMIZE TABLE table_name[,table_name]

Thanks in advance!!!