![]() ![]() Then, you can rebuild the DataStore and reduce its size. You must also export your configuration and performance data after you have trimmed it down. Trimming out performance data from your DataStore does not shrink the size of your DataStore on disk alone. Step 2 - Export your Configuration and Performance Data Once the archiving process is completed, the entry Finished Archiving should appear in the file /logs/uptime.log. The archived files will be placed in the directory /archives. When Uptime Infrastructure Monitor restarts, it should start archiving data. Stop and then restart the Uptime Infrastructure Monitor Data Collector using the following commands: Starting (or restarting) and Stopping Uptime Infrastructure Monitor.To reduce the amount of data that Uptime Infrastructure Monitor keeps in the DataStore, make the the number of months smaller than the current number. ![]() ![]() #Mysql shrink database archive#Change the archive policy to the number of months that you want to retain - for example one month.To trim out performance data using the archive policy use the steps below. For trimming specific performance data please refer to the following articles: Manually trim performance data from a MySQL DataStore, Manually trim performance data from a MS SQL DataStore, or Manually trim performance data from an Oracle DataStore. #Mysql shrink database manual#The most simplistic method is to change your Uptime Infrastructure Monitor archive policy to the number of months that you would like to maintain but you can also run manual SQL commands to remove very specific sets of data. There are a few different ways to trim out historical performance data from your DataStore. #Mysql shrink database free#Removing performance data will not shrink the DataStore but it will free up space within the DataStore tablespace, this will stop the DataStore from growing until all of the space used for the trimmed data has been filled with new performance data. In order to shrink your DataStore you will need to remove some portions of your historical performance data. Step 1 - Trim out Performance Data that You No Longer Need The process of reducing your DataStore size follows the general steps that are outlined in this article. Step 2 - Export your Configuration and Performance DataĪt times it may be necessary to reduce the disk space that your MySQL DataStore consumes on your monitoring station.Step 1 - Trim out Performance Data that You No Longer Need.Those users can manage database growth using the steps available in Archiving the DataStore or by manually trimming performance data from your MySQL DataStore. Do not use this procedure if you are using Uptime Infrastructure Monitor 7.8.6. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |