Back to OP5 Monitor FAQ

Database maintenance and removing old data

Related to Copied

mysql database maintenance op5 remove old data, removing old data, purge old data, purging old data.

Problem Copied

• MySQL database on OP5 is large, and the user would like to purge data from it and remove old data.

Possible Cause(s) Copied

• Standard use of MySQL database.

Possible Solution(s) Copied

• Use the mon log purge command.

  mon log purge removes data no longer in use.

  If –remove-older-than is specified, also removes log files and database entries older than . The difference is specified as a number, followed by a unit - ‘y’ for year, ’m’ for month, ‘w’ for week, ’d’ for day. For instance, to delete all logs older than 1 year: mon log purge –remove-older-than=1y

  This also purge the naemon log, so be fore-warned.