If you ask a DBA about his worst nightmare then most probably his answer would be “Database Corruption”. There is nothing worst than losing your years of hard earned data. In MySQL you still have the chances of getting your data back using its inbuilt utilities. This article can help you surely in recovery of your corrupt database.
Sunday, January 27, 2013
Friday, January 25, 2013
Tuning of any database is required in order to optimize its performance. A well-tuned database performs faster and maximizes the use of system resources. If your database is not optimized, it will response poorly and eventually effect your business. Similarly if you are using MySQL for storing your data then don't forget to optimize it. MySQL provides different storage engines and each storage engine has unique design and properties. So it is important to optimize each storage engine according to its design. I will discuss performance tuning tips for InnoDB.