Getting started with MySQL Limit and Offset Creating databases Backup using mysqldump Table Creation INSERT Error codes Stored routines (procedures and functions)Reserved Words String operations DELETE VIEW Indexes and Keys Date and Time Operations Comment Mysql LOAD DATA INFILE PREPARE Statements ALTER TABLE Joins UPDATE Change Password JSON MySQL Admin TRIGGERS Pivot queries Configuration and tuning Converting from MyISAM to InnoDB SELECT Create New User Group By UNION Drop Table Data Types Performance Tuning Events ENUM Install Mysql container with Docker-Compose Arithmetic Character Sets and Collations MyISAM Engine Many-to-many Mapping table Using Variables Log files Partitioning Clustering Security via GRANTs Backticks mysqlimport MySQL LOCK TABLE MySQL Unions ORDER BY MySQL client Mysql Performance Tips Temporary Tables Transaction Customize PS1 Dealing with sparse or missing data Dynamic Un-Pivot Table using Prepared Statement NULL Replication Connecting with UTF-8 Using Various Programming language.SSL Connection Setup Handling Time Zones Time with subsecond precision Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...Full-Text search Extract values from JSON type Regular Expressions Recover and reset the default root password for MySQL 5.7+One to Many JOINS: Join 3 table with the same name of id.Server Information Recover from lost root password

MyISAM Engine

Remarks:

Over the years, InnoDB has improved to the point where it is almost always better than MyISAM, at least the currently supported versions. Bottom line: Don't use MyISAM, except maybe for tables that are truly temporary.

One advantage of MyISAM over InnoDB remains: It is 2x-3x smaller in space required on disk.

When InnoDB first came out, MyISAM was still a viable Engine. But with the advent of XtraDB and 5.6, InnoDB became "better" than MyISAM in most benchmarks.

Rumor has it that the next major version will eliminate the need for MyISAM by making truly temporary InnoDB tables and by moving the system tables into InnoDB.

ENGINE=MyISAM

CREATE TABLE foo (
     ...
) ENGINE=MyISAM;

Contributors

Topic Id: 4710

Example Ids: 16542

This site is not affiliated with any of the contributors.