Save Big On Open-Box & Preowned: Buy "High Performance MySQL” from Amazon Warehouse Deals and save 80% off the $39.95 list price. Product is eligible for Amazon's 30-day returns policy and Prime or FREE Shipping. See all Open-Box & Preowned offers from Amazon Warehouse Deals.
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 email address or mobile phone number.
High Performance MySQL 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Customers Who Viewed This Item Also Viewed
Special Offers and Product Promotions
About the Author
Jeremy Zawodny and his two cats moved from Northwest Ohio to Silicon Valley in late 1999 so he could work for Yahoo!--just in time to witness the .com bubble bursting first-hand. He's been at Yahoo!® ever since, helping to put MySQL and other Open Source technologies to use in fun, interesting, and often very big ways. Starting with the popular and high-traffic Yahoo! Finance site, he worked to make MySQL part of the site's core infrastructure in large batch operations as well as real-time feed processing and serving content directly on the site. He then helped to spread "the MySQL religion" to numerous other groups within Yahoo!, including News, Personals, Sports, and Shopping. Nowadays he acts as Yahoo!'s MySQL guru, working with Yahoo!'s many engineering groups to get the most out of their MySQL deployments.
In 2000, he began writing for Linux Magazine and continues to do so today as a columnist and contributing editor. After over a year of active participation on the MySQL mailing list, he got the idea to write a book about MySQL. (How hard could it be, really?) You can still find him answering questions on the list today. Since 2001, Jeremy has been speaking about MySQL at various conferences (O'Reilly's Open Source Conference, PHPCon, The MySQL User Conference, etc.) and user groups in locations as far away as Bangalore, India. His favorite topics are performance tuning, replication, clustering, and backup/recovery. In more recent times, he's rediscovered his love of aviation, earning a Private Pilot Glider license in early 2003. Since then he's spent far too much of his free time flying gliders out of Hollister, California and Truckee, near Lake Tahoe. He hopes to soon earn his Commercial Pilot license and then go on to become a certified flight instructor someday. Occasional MySQL consulting also helps to pay for his flying addiction.
Jeremy rambles almost daily about technology and life in general on his weblog: www.jeremy.zawodny.com/blog/
Derek J. Balling has been a Linux system administrator since 1996. He has helped build and maintain server infrastructure for companies like Yahoo, and institutions like Vassar College. He has also written articles for The Perl Journal and a number of online magazines, and served on the Program Committee for the 2008 LISA (Large Installation System Administration) Conference. He is currently employed as the Data Center Manager for Answers.com.
When not working on computer-related issues, Derek enjoys spending time with his wife Debbie, and their posse of animals (four cats and a dog). He also makes his opinion known on current events or whatever is annoying him lately on his blog at http://blog.megacity.org/.
More About the AuthorsDiscover books, learn about writers, read author blogs, and more.
Top Customer Reviews
I think this book filled my knowledge gap on MySQL perfectly. Actually, this book could easily bear different title, such as "MySQL concepts guide" or something like that. You'll probably read the book in a couple of days, thanks to the author's clear writing style.
Let me give you an example. Some technical topics are difficult to explain in a few sentences, like the one on letter I (Isolation) from ACID rules for 'safe' transactions. Just compare the explanation on "phantom reads" from this book with the one you'll find in Oracle Concepts Manual (freely available on-line from OTN). Now, which one did you understand on the first pass? ;-)
Thanks to clear and short explanations, right from the beginning of the book, I learned some important technical facts about MySQL that I could easily put in perspective with my Oracle background. For example:
-"All InnoDB tables have primary keys"
-"InnoDB tables are similar to Oracle index-organized tables."
-"MySQL will only ever use one index per table per query!"
-"MySQL doesn't cache rows for MyISAM tables, only indexes...as opposed to InnoDB"
-"...counts are very fast on MyISAM tables and slow on InnoDB tables..."
Obviously the chapters that I liked the most in this book are the ones that covers core things very well:
"2. Storage Engines",
"4.Read more ›
Jeremy provided some pretty detailed and easy to understand examples, with decently comprehensive descriptions which did help answer some of the questions I had.
I'd suggest this book to anyone who wants to understand the principles of Storage and Replication techniques in MySQL4. This book is definitely a kick in the right direction, but does not take you too far, so I'd say this is for intermediate users.
MySQL5 has many new storage and replication features not mentioned in this book, some of which resolve a lot of the 'problematic' storage and replication issues that this book discusses, thus making SOME of the content irrelevant (or obsolete) to MySQL5. However, the overall principles remain the same, and can be applied to either version.
If you're using MySQL4, then this book is for you!
If you're using MySQL5, you may want to wait for a revised edition of this book.
I sure hope Jeremy is working on a revised version for MySQL5! *hint*hint* =)
Database architecture is where it really begins. Zawodny and Balling did a great job explaining the different storage engines along with their advantages and disadvantages, working with transactions, how to get the most of your database through indexing and how to optimize query performance.
Zawodny and Balling also did an excellent job on covering server tuning. It just wasn't a turtorial on 'this is how you should modify your configuration files.' The authors whent into great detail in explaining different hardware configurations, what to look for in RAID configurations and different filesystems, and how to solve various bottlenecks.
For the most part, the authors reserved a complete 60 pages of the book for Replicaiton and Load Balancing configurations. The authors provided several scenarios to choose from along with the advantages and disadvantages of each.
Most Recent Customer Reviews
Really great reference for MySQL, although is quite complex sometimes, I need to read it a couple more of times to finish learning some of the great points explained here.Published 13 months ago by Franco Risso
A good reference for a DBA, maybe too complicated for a developer or occasional user. Well, not complicated in dealing with technical stuff but complicated in the way it is... Read morePublished on October 5, 2011 by Ionel Condor
The book itself is a fine book, but I'm giving this one star to help warn people off. Only buy this if you know what you're getting - an outdated edition. Read morePublished on May 12, 2011 by E. DeMenthon
Firstly, I feel a bit tricked by Amazon since it did not explicitly say or even indicate in description that this was an older version of the book and that it was on MySQL 4. Read morePublished on January 17, 2011 by Juris
High Performance MySQL opens with a quick chapter describing various MySQL installation options including binary packages and compiling from source code. Read morePublished on March 1, 2008 by Dave Walz-Burkett
I'm Certified MySQL Associate and preparing for the next exams (Developer and Admin)... and I must say I didn't liked the book.
It offered nothing new for me... Read more
Having written LAMP-based web applications, I read High Performance MySQL hoping to gain a deeper understanding of how MySQL operates at a relatively low level and how to deal with... Read morePublished on February 4, 2008 by Conrad Shultz
This is an overall solid book, covering all aspects of running a MySQL database, from the impact of various flavors of hardware to architecting database clusters. Read morePublished on December 18, 2007 by Ulas Kirazci
A great overview of MySQL, with a cursory introduction to virtually every field a DBA will encounter over the years. Read morePublished on August 13, 2007 by Ilya Grigorik