You are here: Home Members egon MySQL Optimization

MySQL Optimization

by Cole Tuininga last modified Mar 09, 2009 01:44 PM
Cole shares some of the highlights of things he learned at a MySQL Optimization class. (POSTPONED from March due to snow.)
When Apr 13, 2009
from 07:00 PM to 09:00 PM
Where UNH Durham, Morse Hall Conference Room 301
Contact Name
Add event to calendar vCal
iCal

Cole's company (Dynamic Network Services, Inc) sent him to MySQL Optimization class with the understanding that he'd do a presentation on some of the lessons learned. They have graciously permitted him to give this same presentation to the NHLUG. This talk will assume some familiarity with MySQL and database concepts. Topics will include:

 * General tips/tricks
 * Data Types
 * Indexes
 * General Server Settings
 * Selecting Between MyISAM and InnoDB
 * Optimizing for MyISAM
 * Optimizing for InnoDB
Document Actions