MyISAM Table Maintenance

MyISAM Table Maintenance and Crash Recovery

MyISAM Table Maintenance, that’s a default storage engine for MySQL server and InnoDB is also a storage engine. This supports three different storage format. we check and repair crashed table when using the MyISAM engine in MySQL. so

Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you’re using. The third, compressed format, can use to create only with the myisampack utility. so

Check Out: Install MySQL 5.6 Database Server Using Repository In Linux

myisamchk can be used to repair, check and optimize database tables. and it’s secure. so

MyISAM table maintenance can use the below SQL queries

  1. Check table

CHECK TABLE table_name FAST QUICK;

If the check table corrupted, the problem mostly occurs in indexes but not in the data part.

Check Out: Different Ways of Finding Table Size In Mysql Server

  1. Repair table syntax

Repair [no_write_to_binlog | LOCAL] TABLE  tbl_name [, tbl_name]… [QUICK] [EXTENDED] [USE_FRM] 

Eg. REPAIR TABLE tbl_name;

Repair table repairs corrupted table, for certain storage engines only and this statement needs to select and inserts privileges for the table. so

Check Out: Installation of MySQL Workbench 8.0.16 On Ubuntu

  1. Optimize table syntax so

OPTIMIZE  [no_write_to_binlog | LOCAL] TABLE  tbl_name [, tbl_name]…

Eg. OPTIMiZE TABLE tbl_name; so

That’s it mysql repair crashed table

LEAVE A REPLY

Please enter your comment!
Please enter your name here