Hacker News Reader

This is changing because MyISAM is not really a true database (in the ACID compliant sense of the term). I guess I would have assumed they were MyISAM too but they don't perform differently enough at low usage levels that you would notice it right? How big was this was application?

View on HN

About 5 million pageviews / month. The website is quite processing intensive.

That's only two pageviews a second, on average.

We can agree that traffic rarely comes in at an average rate.

Assuming the standard bell curve it's six pageviews a second, at peak.

And that's apparently spread across four read-only slaves, too. I'm more inclined to blame the code than the database in this case.

No, it is not the code. It is InnoDB's default buffer pool set to 8MB that cause my website to be so slow ...

Reply on news.ycombinator.com