[consulting] Drupal server requirements

[Scott Trudeau]

It's been awhile since I've tuned a MySQL installation, and I've  
never tuned a server for Drupal, but I learned a lot by just reading  
the sample my.cnf files, so I might start there.  There's a lot of  
context involved in determining an optimal config. Also, searching  
for "tuning MySQL" in Google provided some helpful results, including  
this one:

	http://drupal.org/node/51263

Scott

On Mar 27, 2006, at 4:55 PM, Laura Scott wrote:

> 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
>
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting
>
>