[Cialug] MySQL Optimization

[Dave Weis]

David Champion wrote:
> I usually make sure I have indexes on any fields used in join 
> conditions, where conditions, and order by or group by expressions. But 
> as he says, too many indexes can slow things down. Mysql has an 
> "explain" function to show what indexes are being used by a query.

Even if you don't have too many indexes, having more indexes than your 
buffer cache can hold will cause memory starvation for the database even 
if the machine has plenty free.


dave