Warning |
---|
Do not use this procedure if you are using Uptime Infrastructure Monitor 7.8.6. Those users can manage database growth using the steps available in Archiving the DataStore or by manually trimming performance data from your MySQL DataStore. |
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.
...
- 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"
Delete the following files from your DataStore directory:
No Format ibdata1 ib_logfile0 ib_logfile1
- 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
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"