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.
Thoughts on “MySQL Storage Engines – InnoDB and MyISAM”
Telling how to change between the two engines.
Thanks for pointing that out. I’ve corrected it for you.
Hi Tim, sorry but link is not active… 🙁
thanks for replying. Here’s a link to an article explaining how to add the web of trust logo to your site. Please keep in mind this only works with certificates purchased through InMotion Hosting.
[url=https://www.inmotionhosting.com/support/website/how-to/how-do-i-show-the-secure-seal-for-my-site]Adding the secure seal to my website[/url]
If you need further assistance please feel free to contact us.
Hi Tim, i obtaind such certificate through Inmotion, but i would like to place an image that says SSL secure or similar… i have seen it around, but how do I get it…Thankx!