[Cialug] MySQL Optimization

[Tony Bibbs]

Ok, I'm not a complete n00b to MySQL but despite my best efforts I'm in 
dire need of optimizing an installation I have.  I've got a site that is 
running terribly slow despite having a dedicated database server.  The 
load on the database server loves to stay at 2 or better.

I'm looking for someone with experience optimizing these bad-boys who'd, 
preferrably, be willing to work for beer (bourbon and whisky available, 
too).  Of course...I was drinking the Turkey when I made my last stab at 
optimizations which may explain the current state ;-)

Anyway, if any of you have experience and would be willing to help 
please email me off list.  Oh, and for the benefit of the group...maybe 
when we get this all figured out we'll have enough for a presentation at 
one of the upcoming meetings.

--Tony