[development] Re: enterprise needs

Darrel O'Pry dopry at thing.net
Mon Feb 27 17:42:07 UTC 2006


On Mon, 2006-02-27 at 11:22 -0600, Chris Johnson wrote:
> Somewhere in the list of diminishing returns of optimizations to make are also 
> these two items, which were mentioned in my Drupal Enterprise-wide session in 
> Vancouver:
> 
> 1.  Tune your MySQL or PostgreSQL database.  There are lots of knobs that can 
> be twiddled, and just a couple of them can make a big difference.
> 
> 2.  Tune your operating system for the task at hand -- e.g. web server or 
> database server, or some hybrid if on the unfortunate end.
> 
> 
> Yes, it is true these things are general to all kinds of applications, not 
> just Drupal.
> 
> 
> Kieran recently posted a large PHP snippet that helped with tuning MySQL. 
> It's highly worthwhile as a starting point; I've already used it to tweak my 
> MySQL tuning for my non-Drupal database applications.
> 
> 
> ..chrisxj


Ohh... I keep thinking wouldn't it be nice to have a Drupal mysql tuning
module.



More information about the development mailing list