Umar205523 Posted January 3, 2021 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.
Nathan Explosion Posted January 3, 2021 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
bfarber Posted January 4, 2021 Posted January 4, 2021 (1) You can make this change yourself, as noted above. (2) This is a recommendation, not a requirement. Umar205523 1
Umar205523 Posted January 4, 2021 Author Posted January 4, 2021 Thank you! What a relief! Jordan Miller 1
IP-Gamers Posted January 29, 2021 Posted January 29, 2021 ALTER TABLE NAMETABLE engine=MyISAM; set global storage_engine=MYISAM
CoffeeCake Posted January 29, 2021 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
Recommended Posts