MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 

When should we use innodb engine?

I am newbie to MySQL and don't know much about MySQL table engines.  Can you explain, when should we use InnoDB Engine?

Answer No: 185

InnoDB tables are ideal for the following scenarios, among others:

  • Update-intensive tables: The InnoDB storage engine is particularly adept at handling multiple simultaneous update requests.
  • Transactions: The InnoDB storage engine is the only standard MySQL storage engine that supports transactions, a requisite feature for managing sensitive data such as financial or user registration information.
  • Automated crash recovery: Unlike other storage engines, InnoDB tables are capable of automatically recovering from a crash. Although MyISAM tables can also be repaired after a crash, the process can take significantly longer.

As of version 3.23.44, InnoDB supports foreign keys, a feature not slated to be available to other storage engines until version 5.1.

Related MySQL FAQs to the Above FAQ

How-to-create-innodb-table-in-MySQL How to create innodb table in MySQL?

How-to-install-Innodb-Engine How to install Innodb Engine?

How-to-uninstall-Innodb-Engine How to uninstall Innodb Engine?

How-to-rename-a-database-with-full-Innodb-Tables How to rename a database with full Innodb Tables?

How-to-take-data-back-up-for-InnoDB-tables-like-copy-paste How to take data back up for InnoDB tables like copy paste?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.