I've misplaced most of my MySQL tuning links, but the section on
performance tuning in the O'Reilly book is an excellent place to start.

Mainly you need to be concerned with buffer and cache sizing and that
your tables are properly normalized and indexed.

This might help you find more:
log_slow_queries = /var/log/mysql/slow_query.log
# log-queries-not-using-indexes=true
long_query_time = 1
table_cache     = 256
query_cache_size = 10M


On 09/10/2010 10:29 AM, Scott Downing wrote:
> 
> 
> I was wondering if anyone knew of any decent articles about performance
> tuning MySql, I'm more interested in dedicated servers. Most articles I
> find assume you're running a million other things and want MySql to play
> nicely with them, I want MySql to be the priority.
> 
> -Scott
> 
> 
> 
> _______________________________________________
> TCLUG Mailing List - Minneapolis/St. Paul, Minnesota
> tclug-list at mn-linux.org
> http://mailman.mn-linux.org/mailman/listinfo/tclug-list