Beginning MySQL Database Design and Optimization


Getting the design of your database right has a huge impact on a number of issues. Primarily performance, but it can also affect other areas like the flexibility of your database and how it integrates with the application-level solution, such as PHP or Perl, that you’re using.Beginning MySQL Database Design and Optimization by Jon Stephens and Chad Russell covers the whole gamut of database design from choosing the right data types to the right database type and index. I talked to the authors about the book, MySQL 5.0, and database design.This book has a slightly different feel to it than other MySQL titles I’ve read recently. Can you tell us what the primary motivation for the title was? Read on…