HI,

I am thinking of changing MySQL engines for a D6 site, on shared web hosting, from MyISAM to InnoDB using DB Tuner. I have a couple questions.

  • Are there any issues with the site being on shared hosting where I cannot start/stop the DB server? Just being paranoid...
  • Almost all the sites traffic is anonymous users who cannot create content and the site uses the Boost module for caching. Will switching to InnoDB improve the site's performance? I'm seeing some odd performance issues when content is being added and I'm making every effort to speed things up...

Thanks,

eric

Comments

mikeytown2’s picture

mikeytown2 commented

If there is only one user, making the switch to InnoDB won't gain much; epically if you don't have full control over the my.conf file.