mysql syslog how to purge/shrink?

[fletch]

Hi all - these syslog mysql files are blowing up my disk space - can someone recommend how to purge/shrink them back down?


[root@cacti-03 syslog]# du -skh *
8.0K db.opt
16K syslog_alert.frm
0 syslog_alert.MYD
8.0K syslog_alert.MYI
16K syslog.frm
16K syslog_incoming.frm
1.3G syslog_incoming.MYD
202M syslog_incoming.MYI
1.2G syslog.MYD
399M syslog.MYI
16K syslog_remove.frm
0 syslog_remove.MYD
8.0K syslog_remove.MYI
16K syslog_reports.frm
0 syslog_reports.MYD
8.0K syslog_reports.MYI

thanks
http://vmadmin.info

[TheWitness]

Well, it looks like the Syslog plugin has hosed you. If you are running a very old Syslog Plugin Version, you should consider getting 1.22 from SVN. However, before that, you can remove the Syslog Incoming table (1.3G) by simply running the following below:

Code: Select all

msyql -e "truncate syslog_incoming" syslog

If you don't mind loosing the Syslog data, then run the following:

Code: Select all

msyql -e "truncate syslog" syslog

The new Syslog does a better job at managing the table sizes. So, that will get you out of a jam. However, if you really want to get out of a jam, do the step from above, upgrade to MySQL 5.1/5.5 (Insure Strict Mode is Off), and then reinstall Syslog 1.22, at which time you can go with partitioned tables which will allow Cacti to perform well without I/O issues that led to this.

TheWitness

[fletch]

Worked like a charm!
thanks Witness,

Fletch.

[brononius]

I'm having a bit the same issue.
The syslog db is filling up bigtime. After one day, about 100MB?
Of course, this can be normal, since a lot of logs are generated by the server.

But is there a way to limit this?

• For example overwrite once it hits 1GB?
• Or is it possible to truncate all data from fe 'before last 7 days'?