[Cialug] MySQL Optimization

[Nathan C. Smith]

Tell us more about how it is slow.  
What kind of application is it?

Are the queries big (do you have a sample) do you have a ton of indexes on
your tables (they can slow down inserts) do you have any indexes on the
tables?  How many tables are you using in a query?  A lot of times rewriting
a query alone can make the DB faster.

Are you accessing it with PHP - through common libraries?

Dave- I'm surprised you didn't just say fix it with PGSQL.

-Nate

-----Original Message-----
From: Tony Bibbs [mailto:tony at tonybibbs.com] 
Sent: Tuesday, January 10, 2006 9:32 AM
To: Central Iowa Linux Users Group
Subject: [Cialug] MySQL Optimization


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
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug