Monday, May 13, 2013

Should you migrate from MyISAM to Innodb?


Most frequent question asked by MyISAM users is, should they switch to innodb storage engine or continue working with MyISAM storage engine. Although both engines have their own pros and cons but Innodb is the best choice you can make for your database. Let's discuss why.

Tuesday, March 19, 2013

Commands to Analyze, Check, Optimize and Repair MySQL tables


There are some useful table maintenance commands that every MySQL user should aware about. These are the most basic and effective commands. You can use these commands to check the consistency of all the tables. If your table becomes corrupt then these commands are helpful in recovery of corrupt table. So let's discuss each command one by one.

Sunday, March 17, 2013

MySQL back to basics: Commands for newbie users


Here is the list of most basic and useful commands for MySQL newbie user. These commands are used time and again.

Wednesday, March 6, 2013

Tips on securing MySQL database

Security of any database is very important and MySQL is no different. Here I am describing some basic security tips that every DBA should follow to protect MySQL database.

Monday, February 25, 2013

How to repair damaged MySQL database when everything else fails

Have your MySQL database got corrupted? Are you tired of trying every possible solution and nothing works or worse and you don’t have even updated backup of your database. Don’t stress! Your data is safe. You can try an amazing third party tool named Stellar Phoenix database repair for MySQL. It repairs damaged innodb and myisam tables in all possible cases of corruption. Using this tool you can repair damaged database created on both Windows and Linux OS.

Tuesday, February 19, 2013

MySQL keeps crashing!! What to do?

MySQL crashes due to various reasons like hardware problem, unexpected system shutdown, power failure and many more. Before things get out from the hand, you should try to find out the reason of MySQL crash and fix it on time. You can try below steps when MySQL crashes.

Thursday, February 7, 2013

Tips to optimize MySQL query performance

The most common issue that bothers MySQL users is slow performance of database. There is nothing worst than having a slow database that takes forever to open. To optimize the overall performance of your database, you first need to optimize the queries. Because badly design queries not only degrade the performance of database but also consume more resources. So first try to find out the bad queries that can impact your database and then optimize them.

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.