What is the default storage engine used?
I am creating tables and so on but keep InnoDB instead of MyISAM.
How to check and or change to MyISAM option?
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 :
Please login to leave a reply, or register at first.