MyISAM vs InnoDB – Difference Between MyISAM and InnoDB Storage Engines

MyISAM vs InnoDB. What’s the difference between MyISAM and InnoDB storage engine. No doubt, MySql is one of the most used databases worldwide. The great thing about MySql is the flexibility to choose storage engines.

In MySql, every storage engine is designed for a specific purpose to address/solve application problems. The two popular storage engines of MySql (MyISAM and InnoDB) are widely used worldwide. So let’s check what’s the difference between MyISAM and InnoDB storage engines.

How to Select NULL Values in MySql

How to select null values in MySql. Misunderstanding NULL is a common mistake beginner do while writing a MySql query. While writing a query in MySql most of them compare column name with NULL. In MySql NULL is nothing or in simple word it is an Unknown Value so if you use comparison operator for NULL values you’ll get an empty result.

In this tutorial, We are going to learn how to write a query to select NULL values in MySql.

How to Increase File Size Import Limit in phpMyAdmin

How to increase file size import limit in phpMyAdmin. This is the common question asked by most of the people that, I get an error message when I am importing a file more than 2MB using phpMyAdmin.

I assume you have LAMP and phpMyAdmin installed on your system and your importing MySql database.

In your default setting, you’ll get following error message when you try to upload  a file more than 2MB.

Error : No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration…

How to Optimize WordPress Database

In this blog post we are going to discuss how to optimize WordPress database and improve page loading time. WordPress is one of the most used CMS worldwide. It is one of the most awesome blogging platform. For any successful website/blog performance is the key factor. Optimizing database can definitely make a huge difference in load time. So let’s check what is optimization and how to optimize wordpress database.