Skip to content
Advertisement

Why default ‘mysql’ database created using MyISAM engine instead of InnoDB?

I am using MySQL version 5.6 which has the default MySQL engine as InnoDB, that is if you don’t specify an engine while creating tables, it is created using InnoDB.

But today, i noticed that the default mysql database is created using ‘MyISAM’ instead of InnoDB.

Any clue, why is it so?

JavaScript

Here is my cnf file:

JavaScript

Here is the mysqldump of one of these tables:

JavaScript

Advertisement

Answer

14.5.4 Converting Tables from MyISAM to InnoDB

Important

Do not convert MySQL system tables in the mysql database (such as user or host) to the InnoDB type. This is an unsupported operation. The system tables must always be of the MyISAM type.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement