LiquidFractal Posted September 7, 2021 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?
Lucas James Posted September 8, 2021 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
LiquidFractal Posted September 9, 2021 Author 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
Marc Posted September 9, 2021 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
Recommended Posts