Other sellers on Amazon
Used (8) from   £11.90
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer – no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Baron Schwartz
Follow
Baron Schwartz
Follow
Something went wrong. Please try your request again later.

High Performance MySQL Paperback – 13 April 2012

by Baron Schwartz (Author)
See all formats and editions

There is a newer edition of this item:

High Performance MySQL: Proven Strategies for Running MySQL at Scale
High Performance MySQL: Proven Strategies for Running MySQL at Scale
£38.52
(40)
In stock
High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries, and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential.
Previous slide of product details
  1. ISBN-10
    1449314287
  2. ISBN-13
    978-1449314286
  3. Edition
    3rd
  4. Publisher
    O'Reilly Media, Inc, USA
  5. Publication date
    13 April 2012
  6. Language
    English
  7. Dimensions
    17.78 x 4.37 x 23.34 cm
  8. Print length
    775 pages
  9. See all details
Next slide of product details

Product description

About the Author

Baron Schwartz is a software engineer who lives in Charlottesville, Virginia and goes by the online handle of "Xaprb," which is his first name typed in QWERTY on a Dvorak keyboard. When he's not busy solving a fun programming challenge, he relaxes with his wife Lynn and dog Carbon. He blogs about software engineering at http://www.xaprb.com/blog/. A former manager of the High Performace Group at MySQL AB, Peter Zaitsev now runs the mysqlperformanceblog.com site. He specializes in helping administrators fix issues with Web sites handling millions of visitors a day, dealing with terabytes of data using hundreds of servers. He is used to making changes and upgrades both to hardware to software (such as query optimization) in order to find solutions. He also speaks frequently at conferences. Vadim Tkachenko was a Performance Engineer in at MySQL AB. As an expert in multithreaded programming and synchronization, his primary tasks were benchmarks, profiling, and finding bottlenecks. He also worked on a number of features for performance monitoring and tuning, and getting MySQL to scale well on multiple CPUs.

Product details

  • Publisher ‏ : ‎ O'Reilly Media, Inc, USA; 3rd edition (13 April 2012)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 775 pages
  • ISBN-10 ‏ : ‎ 1449314287
  • ISBN-13 ‏ : ‎ 978-1449314286
  • Dimensions ‏ : ‎ 17.78 x 4.37 x 23.34 cm
  • Customer reviews:

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Baron Schwartz

    Baron Schwartz

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read author blogs and more

    See more on the author's page
  2. Baron Schwartz

    Baron Schwartz

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Baron is a prominent MySQL performance expert, community leader, speaker, author, and software engineer. After earning a degree in Computer Science and spending several years as a software engineer, Baron grew and led Percona's consulting team and practice to international prominence, then founded VividCortex to give developers and operations teams deep visibility into the behavior and performance of production database systems. Although he is most recognized for his MySQL expertise, Baron understands and appreciates many types of databases, and participates actively in several database communities as a speaker and advocate, as evidenced by his Oracle ACE award among others.

    See more on the author's page
Next page

Customer reviews

4.7 out of 5 stars
4.7 out of 5
139 global ratings

Customers say

Customers find the book very useful and well-written. They also say it's well printed and recommend it.

AI-generated from the text of customer reviews

Select to learn more
UsefulnessWriting style
5 customers mention ‘Usefulness’5 positive0 negative

Customers find the book very useful and recommend it for advanced MySQL users.

"...'start up' database designer problems as well as being a potentially good reference for the more established database user...." Read more

"A splendidly practical book...." Read more

"Excellent book! Highly recommend for advanced MySQL users" Read more

"...Good Stuff !" Read more

4 customers mention ‘Writing style’4 positive0 negative

Customers find the writing style well-written, informative, and easy to read. They also say the authors are real experts.

"...The book is written in a friendly conversational manner but does not hesitate from deep dives into the intricacies of InnoDB." Read more

"This book is extraordinarily good, and very easy reading too. It's my go-to source these days." Read more

"This book covers most aspects I was looking for. It's well written and well printed! I couldn't recommend it enough!" Read more

"I really like this book. It's written in a pleasant but informative style and the authors are real experts.Good Stuff !" Read more

Top reviews from United Kingdom

A. B. Smith
5.0 out of 5 stars 'MySQL magic' even for the database novice.
Reviewed in the United Kingdom on 11 September 2012
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.
4 people found this helpful
Helpful
 Report
Paul Archer
5.0 out of 5 stars Excelled Book very useful
Reviewed in the United Kingdom on 9 December 2012
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.
3 people found this helpful
Helpful
 Report
Richard Adams
4.0 out of 5 stars It also has much useful information about backup and recovery techniques as well
Reviewed in the United Kingdom on 11 March 2018
Verified Purchase
A splendidly practical book. I am a back-end developer and this book has greatly helped me understand why some queries are so slow, how to create correct indexes, understand EXPLAIN plans and how to measure and interpret slow query log data that has revealed just exactly what our ORM framework is actually doing.
It also has much useful information about backup and recovery techniques as well.

Although written in 2012 I have found it very useful with MySQL 5.6 and 5.7 although I expect some of the details of InnoDB have advanced since the book was written, and the chapter on Databases in the Cloud may be a little dated.

The book is written in a friendly conversational manner but does not hesitate from deep dives into the intricacies of InnoDB.
One person found this helpful
Helpful
 Report
Anthony Garratt
5.0 out of 5 stars Five Stars
Reviewed in the United Kingdom on 2 September 2016
Verified Purchase
This book is extraordinarily good, and very easy reading too. It's my go-to source these days.
One person found this helpful
Helpful
 Report
Klemen
5.0 out of 5 stars Five Stars
Reviewed in the United Kingdom on 15 May 2017
Verified Purchase
Excellent book! Highly recommend for advanced MySQL users
Helpful
 Report
Irina
5.0 out of 5 stars Five Stars
Reviewed in the United Kingdom on 16 June 2017
Verified Purchase
This is a must-read
Helpful
 Report
A. Menino-Barlow
5.0 out of 5 stars Great!
Reviewed in the United Kingdom on 3 October 2012
Verified Purchase
This book covers most aspects I was looking for. It's well written and well printed! I couldn't recommend it enough!
One person found this helpful
Helpful
 Report
Steven Cholerton
4.0 out of 5 stars Excellent
Reviewed in the United Kingdom on 20 June 2012
Verified Purchase
I really like this book. It's written in a pleasant but informative style and the authors are real experts.
Good Stuff !
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Emanuele Pietrobono
5.0 out of 5 stars High Performance MySQL
Reviewed in Italy on 14 September 2022
Verified Purchase
Ottimo
Report
Leopold Linhart
5.0 out of 5 stars Ausgezeichet, prime, indispensable!
Reviewed in Germany on 10 November 2017
Verified Purchase
Das Buch ist kein MySQL-Manual für Vorgeschrittene, sondern eine Referenz für DBA's und vielleicht, aber eher nicht, Entwickler. Es geht darin nicht um tweaks zum High-Performance-Gebrauch der Syntax, um besonders "schlauen" Code, zu schreiben, oder "verzwickte" Aufgaben "elegant" zu lösen, sondern auf über 800 Seiten und ca. 1,4 kg Papier um das Drehen nur jedestmöglichen Schräubchens, um die Performance zu verbessern und als DBA den Entwicklern Architekturrichtlinien vorgeben zu können.

Das Buch ist dabei nicht bloß eine Hilfe, sondern deckt erschöpfend bis in den letzten Winkel alle Möglichkeiten der aktuellen MyPHP-Version ab.

MySQL oder MariaDB sind mittlerweile bei kleineren Anwendungen im kommerziellen und kostenpflichtigen Bereich eine Alternative zu Oracle, und eine Auseinandersetzung damit lohnt sich. Wussten Sie übrigens, dass der Schöpfer beider Systeme zwei Töchter hat? Die ältere heißt My, die jüngere Maria. "MySQL" ist also nicht eine syntaktische Wortschöpfung wie in Codebeispielen, wo es schnell mal "myVar" heißt, sondern eine hommage wie die von Herrn Benz, der seine Automarke nach seiner Tochter Mercedes benannt hat:-)
5 people found this helpful
 Report
Stephane Grenier
5.0 out of 5 stars Book title is a perfect match
Reviewed in Canada on 4 February 2016
Verified Purchase
This book is specific to MySQL and how to get the absolute best performance out of it. There is a lot of information and you should definitely be reading this book if you plan on using MySQL in a production environment.
Report
Amazon Customer
5.0 out of 5 stars Imprescindible
Reviewed in Spain on 22 September 2014
Verified Purchase
Quizá el mejor libro de MySQL que haya leído nunca, tanto para seniors como para iniciados en la materia. Se nota que el autor no solo tiene un conocimiento muy avanzado en la materia sino también, y he aquí lo difícil, que lo sabe transmitir a un público muy amplio.
Report
Joshua Prunier
5.0 out of 5 stars A must have for any MySQL DBA or developer!
Reviewed in the United States on 8 September 2012
Verified Purchase
I am extremely pleased with my purchase of High Performance MySQL, 3rd edition. I own the 2nd edition and my company recently upgraded to 5.5 so getting the 3rd edition was a no brainer. The book is extremely well organized and more information has been added to every single chapter. The new chapter on MySQL in the cloud is a timely welcome addition. The section on solid stage storage is also an example of how the contents have been updated to reflect the latest technology and trends. The book is full of real world scenarios and solutions the folks at Percona have encountered over the years. They do a great job of noting where features and functionality differs between 5.5 and 5.1 and also make reference to known features coming in 5.6. The level of detail contained within is much deeper than you will find in the online documentation and the authors do a great job of making clear the circumstances where features, configurations, engines and hardware may help or hurt with your specific application.

If you are brand new to MySQL this is probably not the right choice for you. The information is presented in a very accessible way though and if you are coming from another RDBMS or have a decent technical background and are committed to learning more MySQL, I recommend it highly. The book is definitely biased towards Linux which the authors admit in the foreward. But even if you are running a WAMP stack you will still find tons of useful information inside. I'm constantly pulling this book off my shelf to look up something real quick; either to confirm a thought or see if the experts have anything else to add on the subject. I can't wait for the 4th edition covering 5.6!
Report