High Performance MySQL and over 2 million other books are available for Amazon Kindle . Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Like New See details
Price: 25.95

or
 
   
Trade in Yours
For a 12.50 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading High Performance MySQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

High Performance MySQL: Optimization, Backups, and Replication [Paperback]

Baron Schwartz , Peter Zaitsev , Vadim Tkachenko
4.8 out of 5 stars  See all reviews (4 customer reviews)
Price: 35.50 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 6 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Tuesday, 15 July? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition 16.06  
Paperback 35.50  
Trade In this Item for up to 12.50
Trade in High Performance MySQL: Optimization, Backups, and Replication for an Amazon Gift Card of up to 12.50, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

2 April 2012 1449314287 978-1449314286 3

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

  • Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
  • Implement improvements in replication, high availability, and clustering
  • Achieve high performance when running MySQL in the cloud
  • Optimize advanced querying features, such as full-text searches
  • Take advantage of modern multi-core CPUs and solid-state disks
  • Explore backup and recovery strategies—including new tools for hot online backups

Special Offers and Product Promotions

  • Spend 30 and get Norton 360 21.0 - 3 Computers, 1 Year 2014 for 24.99. Here's how (terms and conditions apply)

Frequently Bought Together

High Performance MySQL: Optimization, Backups, and Replication + MySQL High Availability: Tools for Building Robust Data Centers + MySQL Administrator's Bible
Price For All Three: 99.50

Some of these items are dispatched sooner than the others.

Buy the selected items together

Customers Who Bought This Item Also Bought


Product details

  • Paperback: 828 pages
  • Publisher: O'Reilly Media; 3 edition (2 April 2012)
  • Language: English
  • ISBN-10: 1449314287
  • ISBN-13: 978-1449314286
  • Product Dimensions: 23.2 x 17.9 x 4.4 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 153,867 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

Book Description

Optimization, Backups, and Replication

About the Author

Baron Schwartz is Chief Performance Architect at Percona. He createstools and techniques to make MySQL easier to use and more dependable,and speaks regularly at conferences worldwide. He lives in Virginia with his family.

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. He serves as CEO of Percona, while keeping touch with his technical roots by continuing to do consulting for key customers.

Vadim Tkachenko is the CTO and co-founder of Percona, and an authoron the MySQLPerformanceBlog.com and SSDPerformanceBlog.com blogs. Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.


What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

3 star
0
2 star
0
1 star
0
4.8 out of 5 stars
4.8 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars 'MySQL magic' even for the database novice. 11 Sep 2012
Format:Kindle Edition|Verified Purchase
I have been using MySQL databases for a long time but the level of effort I'd previously put into the design and performance was low compared to the effort put into the applications using them. My initial concern with this book was it may have been too technical for me to make practical use of.

While some parts do require a number of visits before they 'sink in' and make sense, I have to say this book is ideal for sorting both the silly 'start up' database designer problems as well as being a potentially good reference for the more established database user. I say 'potentially' as I'm not an 'established database designer' so can only assume the books usefulness for such a person.

I have not completed the entire book, after all I see it as reference work, but what I have read has changed my view that making even the most basic database more efficient doesn't necessarily require massive effort.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excelled Book very useful 9 Dec 2012
Format:Paperback|Verified Purchase
Have been using mysql for a while, needed to brush up my skills and purchased this book. Enjoyed reading it, made some book marks and have been dipping into and out of the book.

Already been able to make some measured inprovements to systems we are running.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Great! 3 Oct 2012
Format:Paperback|Verified Purchase
This book covers most aspects I was looking for. It's well written and well printed! I couldn't recommend it enough!
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Excellent 20 Jun 2012
Format:Paperback|Verified Purchase
I really like this book. It's written in a pleasant but informative style and the authors are real experts.
Good Stuff !
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.6 out of 5 stars  28 reviews
7 of 7 people found the following review helpful
5.0 out of 5 stars This is THE MySQL performance book. Period. 2 April 2012
By Ignacio A. Ruiz Reyes - Published on Amazon.com
Format:Paperback
Every chapter is very well crafted, with a precise balance between theory and practice, and full of invaluable nuggets, sometimes transcending the MySQL arena and applicable to any database! Such cases are Chapter-Benchmarking MySQL and Chapter 3-Profiling Server Performance, very solid foundations for the reading ahead.

All over the text, authors propose tools, examples of use and proven diagnostic techniques, that will greatly improve your performance firefighter skills and enhance your knowledge of MySQL internals. Nevertheless, what gives this book the five star is taking into consideration the physical part of database structures in play when speaking about performance, which is something most authors don't include; plus treatment on MySQL high availability and cloud features, which we'll increasingly see on customers.

There is something that kind of bugged me at times and was references to a specific commercial MySQL offering and tools, but after taking a look to that company web-site, found that is a great contributor to the MySQL community and you can actually use the tools!
5 of 5 people found the following review helpful
5.0 out of 5 stars Outstanding MySQL Reference Book 12 July 2012
By Dan McKinnon - Published on Amazon.com
Format:Paperback
'High Performance MySQL: Optimization, Backups, and Replication' is a nearly 800 page reference books that shines for doing exactly what the title says. Topics included are:

- benchmarking
- optimizing schemas
- indexing
- optimizing queries
- optimizing the server
- replication
- backup/recovery

Wonderfully written and the kind of reference material that you don't find lots of days nowadays in the computer book market. For anyone that is a MySQL developer or admin, you will be very wise to pick up this great book!!

***** HIGHLY RECOMMENDED
3 of 3 people found the following review helpful
4.0 out of 5 stars Well written, well organized, excellent reference 24 Sep 2012
By Peter J. - Published on Amazon.com
Format:Paperback
I've worked a lot with MySQL, over the past few years. I'm completely self-taught, however, and obviously, I've had gaps to deal with. While Google is dandy in a pinch, a book like this really fills in the blanks and provides a far more comprehensive understanding. Granted, if you're just starting out with MySQL, this is probably not the best book for you. Just looking at it from a learner's perspective, you'd better have at least a basic grasp under your belt or this book is going to be a tough one to tackle. If you've got a good background in it though, and are looking to be a real expert in the field, I'd definitely recommend this book. Even if you've already read the second edition, this third edition is definitely worth the purchase as the information is updated and the authors really expand previously presented topics. My overall take: It's well written, well organized and easy to reference when needed.
2 of 2 people found the following review helpful
5.0 out of 5 stars Super in-depth. Essentially a textbook for the dedicated professional. 16 Jan 2014
By Penn Name - Published on Amazon.com
Format:Paperback|Verified Purchase
You'd be hard-pressed to find the kind of in-depth information this book contains anywhere else. This is in-depth information on complicated settings of storage engines and examples about handling race conditions and other advanced performance topics.
1 of 1 people found the following review helpful
5.0 out of 5 stars Best book on MySQL 18 Mar 2014
By Don Wilson - Published on Amazon.com
Format:Paperback|Verified Purchase
This is a perfect book if you're looking to improve your skills on MySQL. I'd recommend this book if you're at an intermediate level of MySQL knowledge and looking to improve on overall query performance and fine tune MySQL settings. It's a great addition to my bookshelf. Each subsequent edition adds lots of material - I currently own the 1st edition and the 3rd edition and the latter is over twice as thick as the first edition.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback