Come sappiamo InnoDB è un tipo di motore più sicuro ma un po piu lento rispetto a MyISAM, alcune tabelle tipo pagamenti, utenti o altre strettamente sensibili consiglio di tenerle in InnoDB, le altre si possono anche convertire con un semplice comando SQL in PhpMyAdmin.

vBulletin 4 ha 231 rabelle circa ecco il codice per convertire le tabelle:

Codice:
alter table access engine=MyISAM;
alter table action engine=MyISAM;
alter table ad engine=MyISAM;
alter table adcriteria engine=MyISAM;
alter table adminhelp engine=MyISAM;
alter table administrator engine=MyISAM;
alter table adminlog engine=MyISAM;
alter table adminmessage engine=MyISAM;
alter table adminutil engine=MyISAM;
alter table album engine=MyISAM;
alter table albumupdate engine=MyISAM;
alter table announcement engine=MyISAM;
alter table announcementread engine=MyISAM;
alter table attachment engine=MyISAM;
alter table attachmentcategory engine=MyISAM;
alter table attachmentcategoryuser engine=MyISAM;
alter table attachmentpermission engine=MyISAM;
alter table attachmenttype engine=MyISAM;
alter table attachmentviews engine=MyISAM;
alter table avatar engine=MyISAM;
alter table bbcode engine=MyISAM;
alter table bbcode_video engine=MyISAM;
alter table block engine=MyISAM;
alter table blockconfig engine=MyISAM;
alter table blocktype engine=MyISAM;
alter table blog engine=MyISAM;
alter table blog_attachment engine=MyISAM;
alter table blog_attachmentviews engine=MyISAM;
alter table blog_category engine=MyISAM;
alter table blog_categorypermission engine=MyISAM;
alter table blog_categoryuser engine=MyISAM;
alter table blog_custom_block engine=MyISAM;
alter table blog_custom_block_parsed engine=MyISAM;
alter table blog_deletionlog engine=MyISAM;
alter table blog_editlog engine=MyISAM;
alter table blog_featured engine=MyISAM;
alter table blog_groupmembership engine=MyISAM;
alter table blog_grouppermission engine=MyISAM;
alter table blog_hash engine=MyISAM;
alter table blog_moderation engine=MyISAM;
alter table blog_moderator engine=MyISAM;
alter table blog_pinghistory engine=MyISAM;
alter table blog_rate engine=MyISAM;
alter table blog_read engine=MyISAM;
alter table blog_relationship engine=MyISAM;
alter table blog_search engine=MyISAM;
alter table blog_searchresult engine=MyISAM;
alter table blog_subscribeentry engine=MyISAM;
alter table blog_subscribeuser engine=MyISAM;
alter table blog_summarystats engine=MyISAM;
alter table blog_tachyentry engine=MyISAM;
alter table blog_text engine=MyISAM;
alter table blog_textparsed engine=MyISAM;
alter table blog_trackback engine=MyISAM;
alter table blog_trackbacklog engine=MyISAM;
alter table blog_user engine=MyISAM;
alter table blog_usercss engine=MyISAM;
alter table blog_usercsscache engine=MyISAM;
alter table blog_userread engine=MyISAM;
alter table blog_userstats engine=MyISAM;
alter table blog_views engine=MyISAM;
alter table blog_visitor engine=MyISAM;
alter table bookmarksite engine=MyISAM;
alter table cache engine=MyISAM;
alter table cacheevent engine=MyISAM;
alter table calendar engine=MyISAM;
alter table calendarcustomfield engine=MyISAM;
alter table calendarmoderator engine=MyISAM;
alter table calendarpermission engine=MyISAM;
alter table cms_article engine=MyISAM;
alter table cms_category engine=MyISAM;
alter table cms_grid engine=MyISAM;
alter table cms_layout engine=MyISAM;
alter table cms_layoutwidget engine=MyISAM;
alter table cms_navigation engine=MyISAM;
alter table cms_node engine=MyISAM;
alter table cms_nodecategory engine=MyISAM;
alter table cms_nodeconfig engine=MyISAM;
alter table cms_nodeinfo engine=MyISAM;
alter table cms_permissions engine=MyISAM;
alter table cms_rate engine=MyISAM;
alter table cms_sectionorder engine=MyISAM;
alter table cms_widget engine=MyISAM;
alter table cms_widgetconfig engine=MyISAM;
alter table cms_widgettype engine=MyISAM;
alter table contentpriority engine=MyISAM;
alter table contenttype engine=MyISAM;
alter table cpsession engine=MyISAM;
alter table cron engine=MyISAM;
alter table cronlog engine=MyISAM;
alter table customavatar engine=MyISAM;
alter table customprofilepic engine=MyISAM;
alter table datastore engine=MyISAM;
alter table deletionlog engine=MyISAM;
alter table discussion engine=MyISAM;
alter table discussionread engine=MyISAM;
alter table editlog engine=MyISAM;
alter table event engine=MyISAM;
alter table externalcache engine=MyISAM;
alter table faq engine=MyISAM;
alter table filedata engine=MyISAM;
alter table forum engine=MyISAM;
alter table forumpermission engine=MyISAM;
alter table forumprefixset engine=MyISAM;
alter table forumread engine=MyISAM;
alter table groupmessage engine=MyISAM;
alter table groupmessage_hash engine=MyISAM;
alter table groupread engine=MyISAM;
alter table holiday engine=MyISAM;
alter table humanverify engine=MyISAM;
alter table hvanswer engine=MyISAM;
alter table hvquestion engine=MyISAM;
alter table icon engine=MyISAM;
alter table imagecategory engine=MyISAM;
alter table imagecategorypermission engine=MyISAM;
alter table indexqueue engine=MyISAM;
alter table infraction engine=MyISAM;
alter table infractionban engine=MyISAM;
alter table infractiongroup engine=MyISAM;
alter table infractionlevel engine=MyISAM;
alter table language engine=MyISAM;
alter table mailqueue engine=MyISAM;
alter table moderation engine=MyISAM;
alter table moderator engine=MyISAM;
alter table moderatorlog engine=MyISAM;
alter table notice engine=MyISAM;
alter table noticecriteria engine=MyISAM;
alter table noticedismissed engine=MyISAM;
alter table package engine=MyISAM;
alter table passwordhistory engine=MyISAM;
alter table paymentapi engine=MyISAM;
alter table paymentinfo engine=MyISAM;
alter table paymenttransaction engine=MyISAM;
alter table phrase engine=MyISAM;
alter table phrasetype engine=MyISAM;
alter table picturecomment engine=MyISAM;
alter table picturecomment_hash engine=MyISAM;
alter table picturelegacy engine=MyISAM;
alter table plugin engine=MyISAM;
alter table pm engine=MyISAM;
alter table pmreceipt engine=MyISAM;
alter table pmtext engine=MyISAM;
alter table pmthrottle engine=MyISAM;
alter table podcast engine=MyISAM;
alter table podcastitem engine=MyISAM;
alter table poll engine=MyISAM;
alter table pollvote engine=MyISAM;
alter table post engine=MyISAM;
alter table postedithistory engine=MyISAM;
alter table posthash engine=MyISAM;
alter table postlog engine=MyISAM;
alter table postparsed engine=MyISAM;
alter table prefix engine=MyISAM;
alter table prefixpermission engine=MyISAM;
alter table prefixset engine=MyISAM;
alter table product engine=MyISAM;
alter table productcode engine=MyISAM;
alter table productdependency engine=MyISAM;
alter table profileblockprivacy engine=MyISAM;
alter table profilefield engine=MyISAM;
alter table profilefieldcategory engine=MyISAM;
alter table profilevisitor engine=MyISAM;
alter table ranks engine=MyISAM;
alter table reminder engine=MyISAM;
alter table reputation engine=MyISAM;
alter table reputationlevel engine=MyISAM;
alter table route engine=MyISAM;
alter table rssfeed engine=MyISAM;
alter table rsslog engine=MyISAM;
alter table searchcore engine=MyISAM;
alter table searchcore_text engine=MyISAM;
alter table searchgroup engine=MyISAM;
alter table searchgroup_text engine=MyISAM;
alter table searchlog engine=MyISAM;
alter table session engine=MyISAM;
alter table setting engine=MyISAM;
alter table settinggroup engine=MyISAM;
alter table sigparsed engine=MyISAM;
alter table sigpic engine=MyISAM;
alter table smilie engine=MyISAM;
alter table socialgroup engine=MyISAM;
alter table socialgroupcategory engine=MyISAM;
alter table socialgroupicon engine=MyISAM;
alter table socialgroupmember engine=MyISAM;
alter table spamlog engine=MyISAM;
alter table stats engine=MyISAM;
alter table strikes engine=MyISAM;
alter table style engine=MyISAM;
alter table stylevar engine=MyISAM;
alter table stylevardfn engine=MyISAM;
alter table subscribediscussion engine=MyISAM;
alter table subscribeevent engine=MyISAM;
alter table subscribeforum engine=MyISAM;
alter table subscribegroup engine=MyISAM;
alter table subscribethread engine=MyISAM;
alter table subscription engine=MyISAM;
alter table subscriptionlog engine=MyISAM;
alter table subscriptionpermission engine=MyISAM;
alter table tachyforumcounter engine=MyISAM;
alter table tachyforumpost engine=MyISAM;
alter table tachythreadcounter engine=MyISAM;
alter table tachythreadpost engine=MyISAM;
alter table tag engine=MyISAM;
alter table tagcontent engine=MyISAM;
alter table tagsearch engine=MyISAM;
alter table template engine=MyISAM;
alter table templatehistory engine=MyISAM;
alter table templatemerge engine=MyISAM;
alter table thread engine=MyISAM;
alter table threadrate engine=MyISAM;
alter table threadread engine=MyISAM;
alter table threadredirect engine=MyISAM;
alter table threadviews engine=MyISAM;
alter table upgradelog engine=MyISAM;
alter table user engine=MyISAM;
alter table useractivation engine=MyISAM;
alter table userban engine=MyISAM;
alter table userchangelog engine=MyISAM;
alter table usercss engine=MyISAM;
alter table usercsscache engine=MyISAM;
alter table userfield engine=MyISAM;
alter table usergroup engine=MyISAM;
alter table usergroupleader engine=MyISAM;
alter table usergrouprequest engine=MyISAM;
alter table userlist engine=MyISAM;
alter table usernote engine=MyISAM;
alter table userpromotion engine=MyISAM;
alter table usertextfield engine=MyISAM;
alter table usertitle engine=MyISAM;
alter table visitormessage engine=MyISAM;
alter table visitormessage_hash engine=MyISAM;