[consulting] Drupal server requirements

[Laura Scott]

 From what I've been reading, just doing that change can create havoc  
without attention to other mysql settings. Has anyone determined what  
would be optimal for a demanding Drupal site with many modules and db  
calls (e.g., something with the complexity of CivicSpace and upwards  
of 25k page views a day)?

I've seen abstract discussion, things to "look at", but no real  
recommendations or framework (e.g., default is X, but Y is better,  
yet avoid Z; or on paramater foo, lower is better, but be sure bar is  
higher)....

Does anyone have any insights here?

Laura

On Mar 27, 2006, at 1:22 PM, Khalid B wrote:

> Hi Lists.
>
> John is a long time member and contributor, and I am sure that his  
> comments
> were not directed at anyone in particular. He has a very high  
> traffic Drupal
> site and had to struggle to get the scalability he needs, and this  
> is why
> he concluded that MyISAM is a bottleneck.
>
>> where during the install process are we supposed to "[not] let  
>> Drupal's installer use
>> MyISAM"?
>
> You have to change the database/database.mysql file to remove all
>
> ) TYPE=MyISAM;
>
> and replace it with
>
> ) TYPE=InnoDB;
>
> Then create the tables.
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting