Is there a way to force wordpress to use innodb engine?

Hey there, perhaps you weren’t aware but from MySQL version 5.5 and onward InnoDB is the default storage engine for MySQL. You can read about this more here if you want.

Hi asdrsn

i tried alot times to install wordpress with innodb but in all times the tables created with MyISAM engine!!
i read the page that you put it in your replay and i think the default engine starting exactly from MySQL 5.5.5 not 5.5!
Is there a difference between mysql V5.5 and V5.5.5 ?

sorry my English language not so good, Thanks

Hey there, no worries about the English, I understand you fine. If its no trouble I think the problem would be solved if you updated to the latest version of MySQL (version 5.7.5).

According to this, it says that InnoDB became the default storage from 5.5 and onward, so theoretically it should work with 5.5.4, but for a reason I can’t quite grasp, it isn’t working.

Thus why I think you should just update to the latest version of MySQL. It should work no problem.

Hi Adithya, thanks for your replay ??
hmmm , I’m on shared hosting (bluehost) so i think update MySQL feature not available for shared hosting. but i will ask the support.

Is there another way like “code” to insert it into wp-config.php file?

thanks a lot.

Talking to the Bluehost support, and asking them to update the version of MySQL for your account should do the trick. As far as I know there is no code you can insert to make the WordPress installer default to InnoDB, though I was able to find this. Its not an officially supported method but it might be of some use.

Hello , i asked Bluehost support, and they say “sorry just Admins can update MYSQL for shared hosting”.

thank you brother for your time and your help. ??

I’m sorry I couldn’t help you any further. Its possible a staff member maybe able to come and aid you.