Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the worlds most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQLs advanced features, this book is for you. The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you wont find anywhere else. Essential advanced SQL is also covered, with discussion of subqu...