LiveG Posted July 21, 2023 Share Posted July 21, 2023 (edited) Hello, I have got this error in the support center. "InnoDB database tables typically perform more efficiently and reliably than other database engines such as MyISAM on most modern hosts when configured correctly. It is strongly encouraged to ensure all of your database tables are using the InnoDB storage engine and that your hosting provider has configured MySQL for InnoDB use. " I have indeed seen In the ACP SQL Toolbox that I have several MyISAM engines running for some tables, What is the safest what to the migration? Can I do it easily via the ACP or involve our system guy? Edited July 21, 2023 by LiveG Link to comment Share on other sites More sharing options...
Marc Stridgen Posted July 21, 2023 Share Posted July 21, 2023 This is something done on your MySQL instance, not within your admin CP. If you are unsure, you should indeed contact your hosting company to assist you LiveG 1 Link to comment Share on other sites More sharing options...
LiveG Posted July 21, 2023 Author Share Posted July 21, 2023 Ok, Thank you. does this action could be a show stopper for my form? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted July 21, 2023 Share Posted July 21, 2023 Only really if it causes you issues. But in our experience, at some point it will Link to comment Share on other sites More sharing options...
Miss_B Posted July 21, 2023 Share Posted July 21, 2023 You can also convert it yourself should your host will not help you with that. Have a look at this article. https://www.techandme.se/convert-myisam-to-innodb/ Don't forget to make first a backup of the database before the conversion. LiveG 1 Link to comment Share on other sites More sharing options...
LiveG Posted July 21, 2023 Author Share Posted July 21, 2023 Thak you! @Miss_B @Marc Stridgen Miss_B 1 Link to comment Share on other sites More sharing options...
alistairgd66 Posted November 1, 2023 Share Posted November 1, 2023 I converted them all to innoDB but I am still getting the warning message in the ACP. How can I troubleshoot this? Link to comment Share on other sites More sharing options...
DawPi Posted November 1, 2023 Share Posted November 1, 2023 For 99% there are MyISAM tables still. Double check all of them. For example via PhpMyAdmin. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted November 1, 2023 Share Posted November 1, 2023 If you still have that message, then you do indeed still have tables that are not INNODB somewhere Link to comment Share on other sites More sharing options...
alistairgd66 Posted November 1, 2023 Share Posted November 1, 2023 Screenshot below of all tables. I'm assuming other tables in the dbase used by other apps are irrelevant. And I assume all forum tables are prefixed the same ie ibf_ Link to comment Share on other sites More sharing options...
teraßyte Posted November 1, 2023 Share Posted November 1, 2023 The tables look fine. Just to double-check, is the warning message in ACP the same as before? The warning might have changed from the tables being MyISAM to the InnoDB tables using a COMPACT row format instead of DYNAMIC. Link to comment Share on other sites More sharing options...
alistairgd66 Posted November 1, 2023 Share Posted November 1, 2023 Thanks but I fixed the Compacts first, all clear. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted November 2, 2023 Share Posted November 2, 2023 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
Recommended Posts