Automotive Holiday Deals Books Holiday Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Adele egg_2015 All-New Amazon Fire TV Grocery Gifts Under $50 Amazon Gift Card Offer bf15 bf15 bf15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Black Friday Deals Outdoor Deals on HTL

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Pro MySQL (The Expert's Voice in Open Source) 1st Edition

9 customer reviews
ISBN-13: 978-1590595053
ISBN-10: 159059505X
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$10.85 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$34.40 On clicking this link, a new layer will be open
More Buying Choices
24 New from $30.38 29 Used from $1.89
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks
$34.40 FREE Shipping on orders over $35. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • Pro MySQL (The Expert's Voice in Open Source)
  • +
  • MySQL Administrator's Bible
  • +
  • MySQL Cookbook: Solutions for Database Developers and Administrators
Total price: $119.41
Buy the selected items together

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more

Editorial Reviews

About the Author

Jay Pipes is the North American community relations manager at MySQL. Coauthor of Pro MySQL (Apress, 2005), Jay has also written articles for Linux Magazine and regularly assists software developers in identifying how to make the most effective use of MySQL. He has given sessions on performance tuning at the MySQL Users Conference, RedHat Summit, NY PHP Conference, OSCON, and Ohio LinuxFest, among others. He lives in Columbus, Ohio, with his wife, Julie, and his four animals. In his abundant free time, when not being pestered by his two needy cats and two noisy dogs, he daydreams in PHP code and ponders the ramifications of __clone().

Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • Paperback: 768 pages
  • Publisher: Apress; 1st edition (July 27, 2005)
  • Language: English
  • ISBN-10: 159059505X
  • ISBN-13: 978-1590595053
  • Product Dimensions: 7 x 1.7 x 9.2 inches
  • Shipping Weight: 2.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #1,510,615 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful By Frank Stepanski on August 28, 2006
Format: Paperback
For people like me who have a good understanding of MYSQL, the next logical step would be this book. I already know about stored procedures, transactions and the basics of triggers, but I want to learn more about these topics in more "real-world" scenarios in how to develop larger, enterprise-wide applications. Also I want to know more about other advanced topics that I may not even know to think about. If this sounds like you as well, then read on...

The author starts in with reviewing how business requirements and the software development cycle can be part of database development. This a great chapter for people like me who would like to learn how different approaches are taken from different IT perspectives in a team environment (business analysts, application developers, and project managers) This chapter gives you a good understanding of how the other side thinks.

The next chapter focuses on the importance of proper indexing and strategies as pertaining to data storage. Because once your databases reach to the multiple gigabits of storage space, you need to very focused on how long each request takes. A few seconds here and there begin to add up and can cause serious issues if not taken into consideration early in your database design. Like me who only deals with small to an occasional medium-size database I never really had to think about this before.

The next chapter focuses on transaction processing in MYSQL which is one of the more difficult concepts for many and I am in the process now of reading it. I really like the author's explanations and examples. Each point is explained thoroughly and in an easy to read manner.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
7 of 7 people found the following review helpful By Harold McFarland HALL OF FAMEVINE VOICE on September 17, 2005
Format: Paperback
Written for those who already have some familiarity with MySQL and want a deeper understanding of the database system the authors take them on a detailed tour of MySQL Server version 5.0. They include many techniques that are not found in most other texts and that by itself makes this a valuable book. The authors do make the assumption that the reader already has some knowledge of relational databases and how they should work.

The book starts by examining business requirements and how software is developed from an initial requirements assessment through object and data modeling, diagramming, and completing the design of the database. The second chapter details indexing and how to use it efficiently to increase data lookup speed. The third chapter provides a detailed discussion of transaction processing. These three chapters form the foundation on which the deeper discussions in later chapters are all based.

One of the areas that I have not found discussed in any significant detail in other books is the internal system architecture of MySQL. In chapters 4 and 5 the authors examine the internal structure and the different storage engines and data types MySQL uses with a concentration on the InnoDB and MyISAM storage engines. The rest of the book covers more traditional fare such as subqueries and derived tables, benchmarking and profiling, writing SQL queries that are efficient and produce the information you want, stored procedures, stored functions, views, and triggers.

Of course they go over installation and configuration in detail as well as security, backup and restoration, replication, clustering, and troubleshooting. The authors have included lots of illustrations, tables, and examples that really help make complex MySQL concepts easy to understand. Pro MySQL is highly recommended for readers who already have a good understanding of MySQL past the beginners level and into the intermediate level.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 10 people found the following review helpful By Michael Hillyer on December 6, 2005
Format: Paperback
I am pleased to see a new trend emerging in the MySQL books I get to review, and that is a trend toward more advanced books that assume the reader is already familiar with how to create a table and construct a basic SELECT query. Pro MySQL by Mike Kruckenberg and Jay Pipes is a shining example of this new trend. This book cuts through the basics to provide in-depth information on not only how to use MySQL, but on how the MySQL server actually works.

One example of this is their chapter on Index Concepts. Rather than focus on the basics of how to create an index, this book gives you depth by talking about seek times, buffering, and the actual structure of things such as a B-Tree index. As a result you not only know that an index on a certain column will improve performance, you also know why.

This book is also the first I have seen that takes a chapter to really dig into the MySQL source code and illustrate some of the internal workings of the MySQL server, such as the client protocol, complete with flow charts and diagrams. The System Architecture chapter is a great place to start if you are looking to understand the server internals or modify the MySQL source code.

There is a nice SQL Scenarios chapter that covers some common use cases for things such as finding duplicate and orphan records, retrieving random rows (properly), working with GIS data, and (my favorite) working with hierarchical data. The authors cover the Nested Set model nicely (which I have previously written and presented about), covering the basics of using nested sets. This provides a good starting point from which one could easily jump the Celko's Trees and Hierarchies book.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Pro MySQL (The Expert's Voice in Open Source)
This item: Pro MySQL (The Expert's Voice in Open Source)
Price: $34.40
Ships from and sold by

Want to discover more products? Check out this page to see more: computer programs