Maximize Your MySQL Database: New Book From Apress

Julie Miller writes “Berkeley, CA—19 October 2004—Every designer wants to make the most of out of his database. But time restraints and a limited knowledge of the tips and tricks often lead to slow, poorly designed, and non-intuitive databases. Even the most ambitious and talented designer often throws her hands up in the air when trying to delve into the intricacies of MySQL.

To help programmers capitalize on valuable MySQL tips, Apress has published Beginning MySQL Database Design and Optimization: From Novice to Professional.

According to the authors, “all too many developers—even seasoned ones—often end up throwing away MySQL’s speed and other advantages due to poorly designed, inefficient databases. In many cases, they create extra work for their application (as well as themselves) due to poor choices throughout the scope of the database creation and through the way they perform operations to retrieve their data.â€

Russell and Stephens want to help every developer optimize his database, and have written the book around four general themes: fundamentals, design and performance issues, the effective use of MySQL with applications, and preparing for forthcoming MySQL releases. The authors offer keen insight regarding query optimization, table indexes, operators, indexes, normalization, and joins. Considerable focus is given to minimizing redundancy and streamlining configuration and networking issues. The third section ensures compatibility and correct configurations. Finally, there is a discussion of preparing for and transitioning to MySQL versions 4.1 and 5.

Highlights of Beginning MySQL Database Design and Optimization:

*Provides a thorough grounding in datatype, table type, and normalization to help designers create more compact and efficient databases
*Includes an overview of API’s for using MySQL with the most common Open Source programming languages, including Perl, Python, PHP 4 and PHP 5
*Introduces the latest features in MySQL 4.1 and 5 to help developers prepare their upgrade path

To read more about Beginning MySQL Database Design and Optimization or the authors, or to view a table of contents and sample chapter, please select this title in our online catalog at

Apress Authors: The Expert’s Voice(tm)

Jon Stephens has contributed as an author to seven previous books on Web development and related technologies, including Usable Shopping Carts, Professional PHP Web Services, Professional JavaScript (Second Edition), and Professional PHP 4 Web Development Solutions, and has served as a technical reviewer of a dozen or so more on a number of development topics, including PHP, MySQL, XML, JavaScript, and Visual Basic. His work has also appeared in International PHP magazine. Stephens was also one of the original developers of phpUDDI, a PHP Web Services library that has since been incorporated into PEAR as PEAR::UDDI. Originally from the USA, Jon now resides in Brisbane, Australia.

Chad Russell is currently a contract software developer for staffing industry software leader LiquidMedium, LLC and founder of Russell Information Technologies, Inc. (RIT), an enterprise software startup. Chad has worked on numerous enterprise-level projects over the past 5 years, primarily developing and integrating PHP and MySQL-based applications. He is currently busy with RIT developing enterprise-level, cross-platform software solutions and providing IT consulting. Chad, who resides in Jacksonville, Florida, is very active in his church where he has been a member for 23 years. His hobbies include music (playing bass guitar), writing, fishing, hunting, and programming.


About Apress

All Apress titles are available at bookstores nationwide, online booksellers, and from Springer New York, Inc. at 800-777-4643; fax 201.348.4505. Contact us for more information at

For a review copy, author interview, cover file, or more information about Apress’ innovative approach to publishing, contact Julie Miller at 510-549-5930, extension 126, or write to

Apress L.P., based in Berkeley, California, is a fast-growing publisher of technical books devoted to meeting the needs of information technology professionals. Apress is dedicated to publishing titles of the highest quality and has compiled a team of authors that reads like a veritable “Who’s Who” of the computing industry.

Beginning MySQL Database Design and Optimization: From Novice to Professional
Chad Russell and Jon Stephens
Published October 2004 * ISBN: 1-59059-332-4 * $44.99 US * 520 pages