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.
Share Knowledge about MySQL Corruption & Repair Methods
Article about causes and resolution methods for Different MySQL corruption scenarios
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
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.
Subscribe to:
Posts (Atom)