MyISAM is the default storage engine for MySQL databases. However, MyISAM tables get corrupted very easily because of any of the following reasons:
STM v5, v5.6.2 and v5.7.2
To avoid and/or resolve this issue, manually run a myISAMCHK in Linux STM by doing the following steps:
Connect to the Linux box/appliance via any of the following means:
a. Remote Desktop Protocol
d. Terminal Session
Login with ROOT and its accompanying ROOT level password.
Navigate to /etc/init.d/ and stop all SW related services aka : stop storage manager service.
Navigate to /opt/Storage Manager Server/mariadb/bin/.
Run the following syntax: ./myisamchk --defaults-extra-file=../my.cnf --check --analyze -r -v ../data/storage/*.MYI
As there are about 920 odd tables in the MYSQL db, the MYISAMDBCHK will scan the tables and look for the existence of crashed tables. If it finds any, the following steps will be performed automatically:
a. Temporarily copy the crashed table and place it side by side next to the original table.
b. Repair the indexes in the copy and do an outright replacement. It will then dump the original table indexes, reloading it with the newly repaired table index.
Note: You will know when it is done when the cursor is sitting at the XioMon tables.
Search for the existence of any TMD files (or any files with the TMD file extension). MYISAMDBCHK temporarily outputs a TMD file when it creates temporary indexes.
If any TMD files exist, it means that for whatever reason, the MYISAMDBCHK couldn't fix a particular table's indexes. Another search should be done in this case.
Press the up arrow and re-run ./myisamchk --defaults-extra-file=../my.cnf --check --analyze -r -v ../data/storage/*.MYI.
After ensuring that there are no more TMD files, navigate back to /etc/init.d/.
Turn on the SW STM Services from etc/init.d/ aka: restart Storage Manager Server.