1 Reply Latest reply on Mar 8, 2012 3:10 PM by DanielleH

    LUN Ranking Top Ten Views missing


      Hi guys,

      If you ever get the below screen when clicking on the PERFORMANCE tab of a storage array:

      then the reason for this is that STM is installed on a non-US operating system.
      The official resolution is to run a repair and optimization query on the database.

      Here's how it's done:

      Windows OS, STM v5.1.x

      Stop the MySQL Service. This will automatically stop the Storage Manager Services.

      Using CMD Prompt as Administrator, browse to the directory:
      C:\Program Files\SolarWinds\Storage Manager Server\mysql\data\storage

      and run the command:
      for %i in (*.MYI) do ..\..\bin\myisamchk --defaults-file=..\..\my.cnf -c -r -a -v %i

      Allow the repair to complete. This may take some time depending on the size of the database.

      Start the MySQL Service. Start all the Storage Manager services.


      Unix based OS, STM 5.1.x

      Stop all STM services: /usr/bin/storage_manager_server stop

      Change to the mysql data directory (assuming it is installed in: /usr/Storage_Manager_Server/mysql/data/storage) cd /usr/Storage_Manager_Server_Server/mysql/data/storage

      Run a full repair: ../ ../bin/myisamchk -v -r -a *.MYI

      Start all services: /usr/bin/storage_manager_server start


      In addition to this you must change the following after first stopping the services:

      Change the regional settings to English United States

      Click on Customize this format... and ensure that punctuation is full stop and not comma on line 1:

       Copy this setting to all user accounts (a server reboot will most likely be needed in order for the changes to take effect):