<br><br><div class="gmail_quote">On Nov 26, 2007 7:05 PM, John Handelaar <<a href="mailto:john@userfrenzy.com">john@userfrenzy.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Nov 26, 2007 7:09 PM, Khalid Baheyeldin <<a href="mailto:kb@2bits.com">kb@2bits.com</a>> wrote:<br>> What I normally do (not for this benchmark, but for tuning) is:<br>><br></div><div class="Ih2E3d">
> Add skip-innodb, which saves some 100MB of RAM for the MySQL.<br><br></div>That's a borderline-reckless thing to say around here.<br><br>Not using InnoDB is one thing -- and good luck with that when you've<br>
got lots of users, lots of comments, and some forums -- but actually<br>removing the option at the server strikes me as more than a little<br>foolish.<br></blockquote><div> <br>If one is not using the feature, why bother keeping in memory?
<br><br>How about this for size:<br>
<br>
16,000 nodes<br>
124,000 comments<br>
26,000 users<br>
650,000 page views a day (peak day over 930,000)<br clear="all">All running on a single box: dual core Opteron and 2GB of RAM.<br><br>Yes, all MyISAM!<br><br>Is that enough?<br></div></div>-- <br>Khalid M. Baheyeldin<br>
<a href="http://2bits.com">2bits.com</a><br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.