What is the default storage engine used?

User, date	Message
Written by westmatrix 6 years ago Category: General 82 posts since Wed, 11 Apr 07	What is the default engine used in HeidiSQL I am creating tables and so on but keep InnoDB instead of MyISAM. How to check and or change to MyISAM option? Cheers
Written by ansgar 6 years ago 3975 posts since Fri, 07 Apr 06	You can specify the engine when you create a table using the pulldown menu on the top right of the dialog. Afterwards you can change a tables engine easily by - going to "Database" tab - rightclick the table you want to change - chose "Change type" - click on the desired engine If you do not specify the engine at creation time, the used engine depends on what's the default on the server. Run this query via the Query-tab to find out what's the default: SHOW VARIABLES LIKE "storage_engine" Most servers still have MyISAM as default. But I think you can change that default value on the server, adding a line to the my.cnf : storage_engine=INNODB
	Please login to leave a reply, or register at first. Username: Password: Remember me

User, date

Message

Written by westmatrix
6 years ago
Category: General
82 posts since Wed, 11 Apr 07

What is the default engine used in HeidiSQL
I am creating tables and so on but keep InnoDB instead of MyISAM.
How to check and or change to MyISAM option?

Cheers

Written by ansgar
6 years ago
3975 posts since Fri, 07 Apr 06

You can specify the engine when you create a table using the pulldown menu on the top right of the dialog.

Afterwards you can change a tables engine easily by
- going to "Database" tab
- rightclick the table you want to change
- chose "Change type"
- click on the desired engine

If you do not specify the engine at creation time, the used engine depends on what's the default on the server. Run this query via the Query-tab to find out what's the default:

SHOW VARIABLES LIKE "storage_engine"

Most servers still have MyISAM as default. But I think you can change that default value on the server, adding a line to the my.cnf :

storage_engine=INNODB

Please login to leave a reply, or register at first.