Programming Books C Java PHP Python Learn more Browse Programming Books
  • List Price: $54.99
  • Save: $27.29 (50%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 20, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
Qty:1
  • List Price: $54.99
  • Save: $23.19 (42%)
FREE Shipping on orders over $35.
Only 14 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
High Performance MySQL: O... has been added to your Cart
Trade in your item
Get a $10.45
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

High Performance MySQL: Optimization, Backups, and Replication Paperback – April 2, 2012

ISBN-13: 978-1449314286 ISBN-10: 1449314287 Edition: Third Edition

Buy New
Price: $31.80
Rent
Price: $27.70
47 New from $27.72 17 Used from $21.90
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$13.06
Paperback
"Please retry"
$31.80
$27.72 $21.90
Amazon%20Web%20Services
Interested in Cloud Computing? Run virtually everything in the AWS Cloud. Web Apps, Big Data, and more. Get started for free.

Frequently Bought Together

High Performance MySQL: Optimization, Backups, and Replication + MySQL (5th Edition) (Developer's Library)
Price for both: $64.27

Buy the selected items together

NO_CONTENT_IN_FEATURE
Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 828 pages
  • Publisher: O'Reilly Media; Third Edition edition (April 2, 2012)
  • Language: English
  • ISBN-10: 1449314287
  • ISBN-13: 978-1449314286
  • Product Dimensions: 9.2 x 7 x 1.7 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (29 customer reviews)
  • Amazon Best Sellers Rank: #53,444 in Books (See Top 100 in Books)

Editorial Reviews

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.


More About the Author

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

Customer Reviews

4.6 out of 5 stars
5 star
22
4 star
5
3 star
1
2 star
0
1 star
1
See all 29 customer reviews
Excellent Book, the explanation is very clear.
maborak
I have read several chapter on the 2nd edition of the book, but that one i just borrow from my friends.
Mohd Naim
If you want to be a mysql expert, this is your book !!
Mferpan

Most Helpful Customer Reviews

7 of 7 people found the following review helpful By Peter J. on September 24, 2012
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Ignacio A. Ruiz Reyes on April 1, 2012
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Dan McKinnon VINE VOICE on July 12, 2012
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Penn Name on January 16, 2014
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Don Wilson on March 18, 2014
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Djames on November 1, 2013
Format: Kindle Edition Verified Purchase
This is the first technical book that I can to read the first to the last page. Thanks this book I could to understand important stuffs about MySQL administration, configs composition, profiling and benchmarks. I could to change a database using MyISAM as engine for a newer version using InnoDB and I earned a lot of performance, it's unbelievable!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By just bought this on October 12, 2013
Format: Paperback Verified Purchase
i wound up in a spot where google wasn't helping and stackoverflow turned up blank. thankfully i had this laying around from school, and it helped me narrow my thoughts and come up with the right questions.

chapters (don't mind my spelling): mysql architecture and history; benchmarking mysql; profiling server performance; optimizing schema and data types; indexing for high performance; query performance optimization; advanced mysql features; optimizing server settings; operating system and hardware optimization; replication; scaling mysql; high availability; mysql in the cloud; application level optimization; backup and recovery; tools for mysql users.
appendixes: forks and variants of mysql; mysql server status; transferring large files; using explain; debugging locks; using sphinx with mysql.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Andy P. on April 1, 2013
Format: Kindle Edition Verified Purchase
As the demands on a website increase, so does the need for deeper knowledge, particularly when so much contradictory advice pervades the technical forums. I didn't rate it five stars mainly because while it's a trove of valuable information, it's not particularly well-organized in the pedantic sense. Still--if your on-line presence is growing, you need this book on the shelf.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


What Other Items Do Customers Buy After Viewing This Item?