- Use promo code PRIMEBOOKS18 to save $5.00 when you spend $20.00 or more on Books offered by Amazon.com. Enter code PRIMEBOOKS18 at checkout. Here's how (restrictions apply)
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.
To get the free app, enter your mobile phone number.
Pro MySQL (The Expert's Voice in Open Source) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who bought this item also bought
Special offers and product promotions
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().
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
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.
The rest of the book goes into more advanced topics (system architecture, benchmarking and profiling, security, replication and clustering) as well as giving more detail and explanation to topics that may only be briefly covered in other MYSQL books (stored procedures, functions, and views).
If you already know the basics of MYSQL and want to really advance your knowledge with "real-world" scenarios, this is the book for you.