Page History

Article Contents

• Overview
• Step 1 - Trim out Performance Data that You No Longer Need
• Step 2 - Export your Configuration and Performance Data
• Step 3 - Rebuild your DataStore

...

Overview

At times it may be necessary to reduce the disk space that your MySQL DataStore consumes on your monitoring station. The process of reducing your DataStore size follows the general steps that are outlined in this article.

...

1. Run the following commands to delete the Uptime Infrastructure Monitor DataStore:

   On Linux systems:

   Code Block
   > mysql -uuptime -puptime -P3308 --protocol=tcp mysql> use uptime; mysql> drop database uptime; mysql> exit; > /etc/init.d/uptime_datastore stop

   On Windows systems:

   Code Block
   > mysql -uuptime -puptime -P3308 --protocol=tcp mysql> use uptime; mysql> drop database uptime; mysql> exit; > net stop "up.timeUptime Data Store"

   
   

2. Delete the following files from your DataStore directory:

   No Format
   ibdata1 ib_logfile0 ib_logfile1

   
   

3. Run the following commands to restart your database and rebuild your DataStore: 

   On Linux systems: 

   Code Block
   > /etc/init.d/uptime_datastore start > mysql -uuptime -puptime -P3308 --protocol=tcp mysql> create database uptime; mysql> exit; > mysql -uuptime -puptime -P3308 --protocol=tcp -A -N -f uptime < export.txt

   On Windows systems:

   Code Block
   > net start "up.timeUptime Data Store" > mysql -uuptime -puptime -P3308 --protocol=tcp mysql> create database uptime; mysql> exit; > mysql -uuptime -puptime -P3308 --protocol=tcp -A -N -f uptime < export.txt

   
   

4. Run the following commands to restart the remaining Uptime Infrastructure Monitor processes: 

   On Linux systems:

   Code Block
   language text
   /etc/init.d/uptime_core start /etc/init.d/uptime_httpd start /etc/init.d/uptime_controller start

   On Windows systems:

   Code Block
   language text
   > net start "up.timeUptime Data Collector" > net start "up.timeUptime Web Server" > net start "up.timeUptime Controller"