Recently we upgraded version of MySQL on the database server, Almost all of our tables are in MyISAM but in my.ini we have set
--default-storage-engine=InnoDB
But now we want to change this setting to MyISAM because previously we were using MyISAM as a default engine
--default-storage-engine=MyISAM
Is changing default-storage-engine on the fly is a good practice? Will it work? Even if it works, Will there be any major performance issues?
It's the legacy application for which we are using this database that is the reason almost all tables are using the MyISAM engine. We are not using DB transactions anywhere in the application.
MySQL Version : 8.0 OS: Windows Server