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.