InMotion Hosting Support Center

In this article, we'll cover what a MySQL storage engine is and discuss the basics between the most popular two - InnoDB and MyISAM.

What is a MySQL Storage Engine?

A MySQL Storage Engine is a particular set of methods used to store and manage information in a database. Each storage engine offers a different way to store, index, and lock data. These differences are beneficial in some circumstances, but not others, and this is why you may have a need to change storage engines. One of the sophisticated features of MySQL is its ability to allow you to use more than one storage engine. In this article, we'll cover the basics between the two more popular storage engines, MyISAM and InnoDB.

Both MyISAM and InnoDB are supported by InMotion Hosting.

MyISAM vs. InnoDB

Discussing the ins and outs of database storage engines can be an exhausting task, especially if you're not very familiar with storage engines in the first place. Because of this, we've outlined some of the easier to understand differences between MyISAM and InnoDB

  • InnoDB has many more features and is a bit more complicated than MyISAM. As such, InnoDB uses more system resources (such as RAM) than MyISAM.
  • InnoDB is better for write-intensive websites, those sites that heavily utilize inserts and updates. MyISAM is better suited for read-intensive sites, those that heavily use select.
  • As InnoDB supports transactions, it is better suited for situations in which data and backups are essential, such as with banking applications.
Was this article helpful?

Related Questions

Here are a few questions related to this article that our customers have asked:
Drupal 7 - unstable InnoDB can't be restored
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

n/a Points
2015-01-19 12:10 pm
Telling how to change between the two engines.

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

1 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!