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
1PLs Company - #1Payday.Loans Agency - Loans online and near me $100-$2500 (Same Day)
Powered by MySQL
 
Home / Table Types or Storage Engines / Question No: 165

What is the fastest storage engine in MySQL?

I am newbie to MySQL and do not know much about MySQL storage engines or table types.  Actually, I need speed so I want to know: what is the fastest storage engine or table type in MySQL?

Answer No: 165

MySQL has MEMORY storage engine. Since MEMORY tables are stored in memory, they offer an extremely fast response time. However, it is pertinent to note that anything stored in memory is highly volatile and goes to disappear if MySQL crashes or is shut down. Although MEMORY tables certainly serve an important purpose, you might want to consider other optimization methods if speed is your goal. Some important points are as following:

  • Taking time to properly design your tables, always choosing the best possible datatype and storage engine.
  • Be diligent in optimizing your queries and MySQL server configuration, and of course never skimp on the server hardware.
  • Take advantage of other MySQL features, such as Query Caching.

Related MySQL FAQs to the Above FAQ

How-to-get-storage-engines-available-on-MySQL-server How to get storage engines available on MySQL server?

What-is-default-table-type-of-MySQL What is default table type of MySQL?

How-to-change-the-default-storage-engine-of-MySQL How to change the default storage engine of MySQL?

How-to-convert-a-table-from-one-type-to-another-in-MySQL How to convert a table from one type to another in MySQL?

What-are-transaction-safe-tables-and-not-transaction-safe-tables-in-MySQL What are transaction-safe tables and not transaction-safe tables in MySQL?

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

© 2023  www.mysqlfaqs.net
All rights reserved.