Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Storage Manager (STM) > STM - Knowledgebase Articles > Manually run a myisamchk in STM - Windows

Manually run a myisamchk in STM - Windows

Table of contents

Overview

MyISAM is the default storage engine for MySQL databases. However, MyISAM tables get corrupted very easily because of any of the following reasons:

  • common wear and tear
  • AV software is trying to read/write the DB at the same time
  • another software is actively scanning the same subdirectory as <install path>\mariadb\data\storage\ subdir

Environment

STM v5, v5.6.2 and v5.7.2

Steps

To avoid and/or resolve this issue, manually run a myISAMCHK in Windows STM by doing the following steps:

Windows STM:

  1. Stop the Mariadb service. 

    Note: All other SW services are dependent upon the Mariadb service being run so they will stop automatically; this behavior is expected.

  2. Open Windows Explorer and copy the entire path: C:\Program Files\SolarWinds\Storage Manager Server\mariadb\data\storage

  3. Open CMD as an Administrator.
  4. Paste the copied path in Step 2 and change the directory to: C:\Program Files\SolarWinds\Storage Manager Server\mariadb\data\storage
  5. Run the following: for %i in (*.MYI) do ..\..\bin\myisamchk --defaults-extra-file=..\..\my.cnf --check --analyze -r -v %i

 

Last modified

Tags

Classifications

Public