Sunday, January 27, 2013

Fixing MySQL Database corruption

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.

Friday, January 25, 2013

Quick Tips on InnoDB Performance Tuning

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.