On Nov 26, 2007 7:05 PM, John Handelaar <
john@userfrenzy.com> wrote:
On Nov 26, 2007 7:09 PM, Khalid Baheyeldin <
kb@2bits.com> wrote:
> What I normally do (not for this benchmark, but for tuning) is:
>
> Add skip-innodb, which saves some 100MB of RAM for the MySQL.
That's a borderline-reckless thing to say around here.
Not using InnoDB is one thing -- and good luck with that when you've
got lots of users, lots of comments, and some forums -- but actually
removing the option at the server strikes me as more than a little
foolish.
If one is not using the feature, why bother keeping in memory?
How about this for size:
16,000 nodes
124,000 comments
26,000 users
650,000 page views a day (peak day over 930,000)
All running on a single box: dual core Opteron and 2GB of RAM.
Yes, all MyISAM!
Is that enough?