An introduction to MySQL optimization, including designing indexes for queries, taking advantage of clustered indexes and how to avoid indexing too much.
by Simon Hamp
How we used PHP, MySQL and Sphinx to process massive XML feeds of millions of products and make them searchable.