Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Storage Manager (STM) > Verification of sufficient disk space before upgrading Storage Manager

Verification of sufficient disk space before upgrading Storage Manager

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 21 Votes: 0 Revisions: 9

Verify there is sufficient free disk space on the Storage Manager Server before upgrading. There must be as much free space as the largest table in your database.

The database can be found at the following location:

  • Windows - <installed>\Program Files\SolarWinds\Storage Manager Server\mysql\data\storage directory</installed>
  • Linux -<installed>/Storage_Manager_Server/mysql/data/storage_manager directory</installed>

Note: This is the default location of where the temporary database tables are created.

Sort the files within the database subdirectory making note of the largest table (*.MYD) in the folder. Storage Manager will build temporary database tables from the actual database. If you have insufficient disk space you will need to point the temporary database tables to a drive that has sufficient disk space.

To change the location of where the temporary database tables are stored, go to the following location:

  • Windows - <installed>:\Program Files\SolarWinds\Storage Manager Server\mysql</installed>
  • Linux – <installed>/Storage_Manager_Server/mysql</installed>

Using a text editor open the file called my.cnf. Once the file is open, search for the string #tmpdir=.  Remove the # (comment) and change it to a drive that has sufficient space.

Example: Changing to E:\ drive will look like tmpdir=E:\

Save the file and restart the mysql service.

  • Windows- Restart the mysql service via services.msc
  • Linux – Run the command /etc/init.d/storage_manager_server restart database
Last modified
03:49, 23 Jun 2016

Tags

Classifications

Public