[development] drupal on postgresql benchmark

Khalid Baheyeldin kb at 2bits.com
Tue Nov 27 00:34:58 UTC 2007


On Nov 26, 2007 7:05 PM, John Handelaar <john at userfrenzy.com> wrote:

> On Nov 26, 2007 7:09 PM, Khalid Baheyeldin <kb at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20071126/b26de11f/attachment.htm 


More information about the development mailing list