Umar205523 Posted January 3, 2021 Share Posted January 3, 2021 Hi, I logged in to my community AdminCP and received the notification (see attached image) the server doesn’t meet recommendations that InnoDB Tables are using compact row format. I have self hosted forums. I contacted my hosting and asked them to change InnoDB Tables to use dynamic and they said this is only possible under a dedicated hosting plan which is out of my budget. My site is 8 years old and I always had IP Forums with no problems. Given the situation, I would like to request that please don’t make this requirement mandatory or customers like myself will have no option other than to migrate to other platforms. I am very sad right now. I don’t want to move from IP but this message is something that I can’t do anything. My hosting is with FatCow. thanks. Link to comment Share on other sites More sharing options...
Nathan Explosion Posted January 3, 2021 Share Posted January 3, 2021 (edited) Your host thinks you want to change this at the server level, which is not what is required. All you have to do is modify your own database tables, not the server itself. So check if the tables can already be modified. Loads of information here: Edited January 3, 2021 by Nathan Explosion SUBRTX, Umar205523 and MEVi 1 2 Link to comment Share on other sites More sharing options...
bfarber Posted January 4, 2021 Share Posted January 4, 2021 (1) You can make this change yourself, as noted above. (2) This is a recommendation, not a requirement. Umar205523 1 Link to comment Share on other sites More sharing options...
Umar205523 Posted January 4, 2021 Author Share Posted January 4, 2021 Thank you! What a relief! Jordan Miller 1 Link to comment Share on other sites More sharing options...
IP-Gamers Posted January 29, 2021 Share Posted January 29, 2021 ALTER TABLE NAMETABLE engine=MyISAM; set global storage_engine=MYISAM Link to comment Share on other sites More sharing options...
CoffeeCake Posted January 29, 2021 Share Posted January 29, 2021 5 hours ago, L4D2Noob said: ALTER TABLE NAMETABLE engine=MyISAM; set global storage_engine=MYISAM This would change the engine to MyISAM, not InnoDB, and would not address the row format that the message displays. I would not recommend going to MyISAM from InnoDB to make this message go away. You run a much higher risk of data loss and corruption with MyISAM over InnoDB. IP-Gamers 1 Link to comment Share on other sites More sharing options...
IP-Gamers Posted February 5, 2021 Share Posted February 5, 2021 Well, so far so good... Link to comment Share on other sites More sharing options...
Recommended Posts