Thread

I’m working on a site getting 30k hits on peak days and I’m worried about the effects of MyISAM doing table level locking on exp_session updates. From a performance perspective, would it be better to set the exp_session table to InnoDB because it only does row level locking? I’m a database noob so I was hoping some EE veterans could shed some light on this. Thanks!

bumped.

To be honest, 30k hits a day isn’t all that much in the grand scheme of a high traffic website.  If you average that over 16 hours, you aren’t looking at 1 hit a second.  Typically, a server will be setup to be optimized for MyISAM or InnoDB, and it’s generally not the best idea to mix them in an application.  I would leave it alone, and look into high-performance hosting with administrators who really know how to tune MySQL before making changes to table storage engines that have been heavily tested in the lifespan of ExpressionEngine 😉

-greg

Thanks Greg! We tried to push for EngineHosting but it got shot down. Sounds like the DB isn’t the best place to trim a few milliseconds 😊

I have the same question, how about 600,000k day?  I’m looking at those numbers.  We are seriously looking at innodb

thanks