LiquidFractal Posted September 7, 2021 Share Posted September 7, 2021 Is it possible to configure a database from its creation to use only innoDB tables, even if 3rd-party Invision apps/plugins want to create myISAM? Link to comment Share on other sites More sharing options...
Lucas James Posted September 8, 2021 Share Posted September 8, 2021 You need to edit the /etc/my.cnf file with following parameter under the [mysqld] section: default-storage_engine=innodb Save the file and restart MySQL/MariaDB. LiquidFractal 1 Link to comment Share on other sites More sharing options...
LiquidFractal Posted September 9, 2021 Author Share Posted September 9, 2021 (edited) 8 hours ago, Lucas James said: You need to edit the /etc/my.cnf file with following parameter under the [mysqld] section: default-storage_engine=innodb Save the file and restart MySQL/MariaDB. Thank you Lucas. But can you tell me if this will also prevent myISAM tables from being written through the installation of 3rd-party apps/plugins (I ask because the variable mentions "default" storage engine)? And if so, might this prevent their installation or compromise their function? Edited September 9, 2021 by liquidfractal Link to comment Share on other sites More sharing options...
Nathan Explosion Posted September 9, 2021 Share Posted September 9, 2021 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 9, 2021 Share Posted September 9, 2021 7 hours ago, liquidfractal said: Thank you Lucas. But can you tell me if this will also prevent myISAM tables from being written through the installation of 3rd-party apps/plugins (I ask because the variable mentions "default" storage engine)? And if so, might this prevent their installation or compromise their function? tables are created using the default storage engine, so switching that will indeed have the desired effect LiquidFractal 1 Link to comment Share on other sites More sharing options...
Recommended Posts