Tag Archives: optimize

Running optimization on MyISAM Engine truncated the whole table !

Web development is always full of surprises whether you are developing website, maintaining databases or trying to save yourself from hack attempts.Recently We encountered a strange behavior of MyISAM engine in mysql5.4+ version when We tried to optimized the table containing around 50GB of data but it truncated showing this . mysql> select count(1) from templates; +----------+ | count(1) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) We lost almost 53GB data of templates which were uploaded by users. Luckily we had backup of that mysql instance, so we... Read More