Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted April 13, 20223 yr Hi there, We are doing some tuning of our MariaDB and we noticed that the DB engine used by IPB is currently set to MYISAM. We'd like to update this to INNODB but we don't want to do it without making sure we won't break our IPB or any support requirements. Can you let us know if there are any special requirements to updating all our IPB tables to INNODB? Or whether we are simply OK to do it using the following standard command for each table: ALTER TABLE <databasename>.<tablename> engine=InnoDB; Many thanks!
April 13, 20223 yr Community Expert Solution Not only is there no issue with doing this, we would actually recommend using INNODB. So after taking backups of course, you would indeed update them.