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

Links

 graphing MySQL statistics with MRTG





feedback