Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically realized using a database. For open source and many other projects, the MySQL database is a very popular choice: it's free; it's fast, robust, and scalable; and it runs on all of the major platforms, allowing maximal use of available hardware resources. However, it's easy to throw away My SQL's speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of efficient, single query are some of the common mistakes.
MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If you're building or maintaining any significant application and are using MySQL, this book is for you.
By:
Chad Russell,
Jon Stephens
Imprint: APress
Country of Publication: United States
Edition: Softcover reprint of the original 1st ed.
Dimensions:
Height: 235mm,
Width: 178mm,
Spine: 20mm
Weight: 979g
ISBN: 9781590593325
ISBN 10: 1590593324
Pages: 520
Publication Date: 28 October 2004
Audience:
General/trade
,
ELT Advanced
Format: Paperback
Publisher's Status: Active
1 Review of MySQL Basics.- 2 MySQL Column and Table Types.- 3 Keys, Indexes, and Normalization.- 4 Optimizing Queries with Operators, Branching, and Functions.- 5 Joins, Temporary Tables, and Transactions.- 6 Finding the Bottlenecks.- 7 MySQL Programming.- 8 Looking Ahead.
Chad Russell is a programmer and network administrator who owns his own Internet hosting company. He previously has written on MySQL, PHP, and other topics.
