Optimizing MySQL

Posted by robbiebow on 6 December, 2006 under geek | Be the First to Comment

One of the best ways to speed up any system that relies on a database is to optimize the database. So that’s what I did the other night for MySQL 5.0.24 running on a Windows box with a 3.2GHz processor and 2GB of RAM. The server uses a mixture of table types (InnoDB and MyISAM) and gets hit a lot with queries against tables that don’t change an awful lot. The resultant my.ini config should give you some ideas on how to optimize MySQL in a similar situation