Optimizing for MySQL

On this page I collect tips & tricks on how to optimize your system for running MySQL. Some tips are in general usefull for optimizing your system.

SysAdmin tips

DBA tips

Use 'explain'. More to follow.
set autocommit to 0 and only commit when really ncessary.

Must reads


 graphing MySQL statistics with MRTG

The Lotter allows you to participate in lotteries from all over the world!