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

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
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

List Price: CDN$ 57.99
Price: CDN$ 36.33 & FREE Shipping. Details
You Save: CDN$ 21.66 (37%)
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 4 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Wednesday, August 6? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $26.41  
Paperback CDN $36.33  

Book Description

April 2 2012 1449314287 978-1449314286 Third Edition

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

Frequently Bought Together

High Performance MySQL: Optimization, Backups, and Replication + MySQL (5th Edition) + Effective MySQL Optimizing SQL Statements
Price For All Three: CDN$ 92.24

Show availability and shipping details

  • In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • MySQL (5th Edition) CDN$ 32.75

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • Effective MySQL Optimizing SQL Statements CDN$ 23.16

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping on orders over CDN$ CDN$ 25. Details


Customers Who Bought This Item Also Bought


Product Details


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

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
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. April 1 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 July 12 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 Sept. 24 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. Jan. 16 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 March 18 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.

Look for similar items by category


Feedback