Storage engines are software components which help DBMS to create, read, update and delete. We can also change storage engine for database.
By default mysql 5.5 and later storage engine is InnoDB.
We can change the default storage engines in my.cnf file. In this file we have to update default-storage-engine:
Here “name” should be your required storage engine. After that restart mysql database.
By default mysql 5.5 and later storage engine is InnoDB.
We can change the default storage engines in my.cnf file. In this file we have to update default-storage-engine:
Code:
default-storage-engine=name