Beginning MySQL Database Design and Optimization

by Stephens, Jon

• ISBN13: 9781590593325
• ISBN10: 1590593324
• Format: Paperback
• Copyright: 2004-11-30
• Publisher: Apress

Summary

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. The book 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.

Table of Contents

About the Authors	ix
About the Technical Reviewer	xi
Acknowledgments	xiii
Introduction	xv
Review of MySQL Basics	1	(44)
How to Connect to MySQL	2	(3)
Identifiers and Naming Conventions	5	(9)
Queries Review	14	(29)
Summary	43	(1)
What's Next	44	(1)
MySQL Column and Table Types	45	(68)
Why Datatypes Matter	46	(2)
MySQL Column Types	48	(55)
MySQL Table Types	103	(7)
Summary	110	(2)
What's Next	112	(1)
Keys, Indexes, and Normalization	113	(58)
Beyond the Spreadsheet Syndrome	114	(3)
Rules for Relational Databases	117	(4)
Normalization and Data Modeling	121	(13)
Keys, Indexes, and Constraints	134	(30)
Common Problems and Errors	164	(5)
Summary	169	(1)
What's Next	170	(1)
Optimizing Queries with Operators, Branching, and Functions	171	(68)
Replacing Program Logic with SQL Logic: A Demonstration	172	(6)
MySQL Operators	178	(15)
MySQL Functions	193	(38)
Branching: Making Choices in Queries	231	(5)
Our Demonstration Revisited	236	(1)
Summary	237	(1)
What's Next	237	(2)
Joins, Temporary Tables, and Transactions	239	(34)
Joins	240	(23)
Temporary Tables	263	(4)
Transactions	267	(3)
Summary	270	(1)
What's Next	271	(2)
Finding the Bottlenecks	273	(42)
Configuration Issues	274	(31)
Application Logic	305	(7)
Summary	312	(2)
What's Next	314	(1)
MySQL Programming	315	(102)
Overview of MySQL APIs	316	(20)
PHP and the mysql Extension	336	(15)
PHP 5 and mysqli	351	(50)
Perl-DBI	401	(6)
Python and MySQLdb	407	(6)
Summary	413	(2)
What's Next	415	(2)
Looking Ahead	417	(72)
MySQL 4.1	417	(12)
MySQL 5.0	429	(52)
MySQL 5.1	481	(3)
Other Expected Improvements	484	(2)
Summary	486	(3)
Index	489