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? -- Khalid M. Baheyeldin 2bits.com http://2bits.com Drupal optimization, development, customization and consulting.