Server Requirement -InnoDB Table - Dynamic

[Umar205523]

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]

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

[bfarber]

(1) You can make this change yourself, as noted above.

(2) This is a recommendation, not a requirement.

[Umar205523]

Thank you! What a relief!

[IP-Gamers]

ALTER TABLE NAMETABLE engine=MyISAM;

set global storage_engine=MYISAM

 

[CoffeeCake]

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]

Well, so far so good...