How do I reduce the size of an RTM database?

If your RTM database is running out of free space on the hard disk, it may be because the retention period of the database is configured incorrectly. The following procedure allows you to reduce the size of the RTM database.

1. Use the RTM data purge script.
   1. If necessary move some files to another disk to make some free space on the hard disk.

      rm -rf /tmp/* 

   2. Go to Console > Configuration > RTM Settings. Click the Maint tab.
   3. Modify the Database Maintenance Time to the nearest convenient time to start the RTM data purge process.
   4. Decrease the following parameters accordingly:
      1. Detail Job Data Retention Period
      2. Summary Job Data Retention Period
      3. Daily Statistics Retention Period
   5. Set Optimization Schedule to Daily.
   6. Click Save to save your changes.
   7. If the preceding step failed to work, manually start the RTM data purge process using the following commands:

      cd cacti/plugins/grid/ 
      php -e poller_grid.php -fm 

2. If step 1 failed to reduce the size of RTM database, manually purge the cacti tables one by one in the order of the size of each cacti table.
   1. Make some free space first. If necessary move some files to another disk to make more free space

      rm -rf /tmp/* 

   2. Take down the original size of cacti table files

      ls -l /var/lib/mysql/cacti/<table name>.*

      For example:

      ls -l /var/lib/mysql/cacti/grid_job_daily_stats.* 

   3. Run the following statements on MySQL database

      select min(<column of attribute timestamp>), max(<column of attribute timestamp&gt;) 
      from <table name>; delete from <table name> where <column of attribute timestamp> < timestamp 
      '<date>'; 
      -- you decide the date accordingly 
      commit; 
      optimize table <table name>; 
      commit; 

      For example:

      select min(date_recorded), max(date_recorded) from grid_job_daily_stats; 
      
      delete from grid_job_daily_stats where date_recorded < timestamp '<>date',
      - you decide the date, say '2013-8-12';  
      commit;  
      optimize table grid_job_daily_stats;  
      commit;
      

   4. Check if the size of cacti table files reduces. For example:

      ls -l /var/lib/mysql/cacti/grid_job_daily_stats.*