Introduction
Storage engines are MySQL components that handle the SQL operations for different table types. For MySQL & MariaDB 10.2 and higher, the default storage engine is InnoDB. However, the default engine may be changed within the MySQL configuration.
Procedure
In order to change the default storage engine, the default-storage-engine option may be used within my.cnf (/etc/my.cnf):
Example:
default-storage-engine=name
Replace "name" with the storage engine of your choice. The change will take effect once MySQL has been restarted.
MariaDB has an excellent resource for choosing the right storage engine for you here.
Comments
0 comments
Article is closed for comments.