On Wed, 15 Nov 2006 22:41, Steve Holdoway wrote: > > > Performance tuning with mySQL.
> The best way to improve the performance of a database is to rewrite the > application code to be more efficient. The rest is a few percent here or > there. > > Developers are a DBA's worst enemy. > > Steve Are you having problems with selects? Using the sql statement; EXPLAIN select_statement; will provide information about how MySQL will execute the select statement. Read more at; http://dev.mysql.com/doc/refman/5.0/en/explain.html Also the ANALYSE TABLE statement could be worth a look. Cheers Ross Drummond
