MySQL

Optimizing MySQL always has been a hot topic for many developers and DBA's. I always took a lot for granted and never really bothered with optimizing MySQL other then trying to make the best query's I could. Over the years I've learned a lot more about MySQL and so my journey went into trying to optimize my MySQL server(s). After a lot of trial and error on development machines, it's time for the real deal The first thing to do is use your favorite search engine and learn the basics, you'll mostly find these phrases: 'good queries', key_buffer_size (or key_buffer), Key_read_requests and Key_reads and memory.

I'm going to talk mostly about MySQL 5 and MySQL 5.1 database tuning. The basics apply to all version but in 5 and 5.1 there are additional parameters not available in previous versions. I'm asuming you are familair with terms as: web servers, indexes, MyISAM, InnoDB, tables, databases, Linux file system (most I talk about applies to windows builds also)