High Performance MySQL and over 500,000 other books are available for Amazon Kindle � Amazon�s new wireless reading device. Learn more


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
High Performance MySQL: Optimization, Backups, Replication, and More
 
 
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, Replication, and More [Paperback]

Baron Schwartz , Peter Zaitsev , Vadim Tkachenko , Jeremy D. Zawodny , Arjen Lentz , Derek J. Balling
4.8 out of 5 stars  See all reviews (4 customer reviews)
RRP: �38.50
Price: �20.52 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: �17.98 (47%)
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
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Want guaranteed delivery by Thursday, February 10? Choose Express delivery at checkout. See Details

Formats

Amazon Price New from Used from
Kindle Edition �16.19  
Paperback �20.52  

Frequently Bought Together

High Performance MySQL: Optimization, Backups, Replication, and More + High Performance Web Sites: Essential Knowledge for Front-End Engineers + Building Scalable Web Sites
Price For All Three: �50.13

Show availability and delivery details

Buy the selected items together

Customers Who Bought This Item Also Bought


Product details

  • Paperback: 712 pages
  • Publisher: O'Reilly Media; 2 edition (18 Jun 2008)
  • Language English
  • ISBN-10: 0596101716
  • ISBN-13: 978-0596101718
  • Product Dimensions: 23.2 x 17.8 x 3.7 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 11,096 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, and more.

Product Description

Product Description

Now that MySQL has proven to be a robust product for large, demanding environments, both programmers and administrators want more information on how to get the most out of it. "High Performance MySQL" goes beyond the basics to explain how MySQL works "under the hood" so that experienced users can understand why it's fast and, conversely, what can slow it down. In this new edition, you'll learn how to maximize the speed and robustness of MySQL through advanced configuration, and methods to optimize everything from schemas, queries, server settings and applications to operating systems, and hardware - topics that typical MySQL books don't cover very well. Other requirements for scaling MySQL, such as replication, backups, and load balancing, are thoroughly discussed as well.This is not a book on MySQL theory - it's a collection of hands-on methods for solving real-world problems, by authors who have the experience to back it up. "High Performance MySQL" includes: clustering solutions; impacts of new features of MySQL 5.0/5.1 , including stored procedures, partitioned databases, triggers, and views; expanded comparisons of storage engines and optimization techniques specific to each one; federation (scaling by dividing data among different servers or different clusters); optimization of subqueries; use of the new information schema to retrieve data about the server and your databases; and, optimization of advanced querying features, such as full text searches and the use of cursors. With this book, you'll discover good practices for large demanding environments, and learn about MySQL's weaknesses and how to work around them. "High Performance MySQL" offers the advanced solutions you need to ensure a smoothly functioning database-driven website.

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.



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/



Arjen Lentz was born in Amsterdam but has lived in Queensland Australia since the turn of the millennium, sharing his life these days with his beautiful daughter Phoebe and black cat Figaro. Originally a C programmer, Arjen was employee #25 at MySQL AB (2001-2007). After a brief break in 2007, Arjen founded Open Query (http://openquery.com.au), which develops and provides its own data management training and consulting services in the Asia Pacific region and beyond. Arjen also regularly speaks at conferences and user groups. In his abundant spare time Arjen indulges in cooking, gardening, reading, camping, and exploring the RepRap. Arjen's weblog is at http://arjen-lentz.livejournal.com/



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 is
on the Program Committee for the 2008 LISA 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 (4 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/.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

High Performance MySQL: Optimization, Backups, Replication, and More
88% buy the item featured on this page:
High Performance MySQL: Optimization, Backups, Replication, and More 4.8 out of 5 stars (4)
�20.52
MySQL (Developer's Library)
4% buy
MySQL (Developer's Library) 4.7 out of 5 stars (15)
�20.32
Essential PHP Security
3% buy
Essential PHP Security 4.4 out of 5 stars (9)
�11.59
Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites
3% buy
Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites 5.0 out of 5 stars (7)
�15.96

 

Customer Reviews

4 Reviews
5 star:
 (3)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.8 out of 5 stars (4 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Create your own review
Most Helpful Customer Reviews

6 of 6 people found the following review helpful:
4.0 out of 5 stars A definite read for mysql developers, 30 Dec 2008
By 
E. Jaoude "JaoudeStudios.com" (Surrey, England) - See all my reviews
(REAL NAME)   
This review is from: High Performance MySQL: Optimization, Backups, Replication, and More (Paperback)
This book is not for beginners! This book is aimed at experienced developers who wish to take their mysql skills to the next level.

If you think you know it all, then you probably dont and this book is worth every penny! It will teach you how to choose the correct engine, optimise & bench mark your work to make sure you get the best out of your system. Its not easy and there is plenty to take in.

Excellent book - I gave it 4/5 because I felt that it went into too much details in some unimportant areas and skimmed over other areas that I thought were more important - however, this is probably just a personal preference. So might deserve closer to 4.8/5 :)


3 of 3 people found the following review helpful:
5.0 out of 5 stars Still the de-facto reference for serious use of MySQL IMHO, 19 Dec 2008
By 
I. Fallon (UK) - See all my reviews
(REAL NAME)   
This review is from: High Performance MySQL: Optimization, Backups, Replication, and More (Paperback)
The first edition of this book was a real find - at last a non-introductory book about MySQL that covers its use in more serious applications, the pros and cons of the variety of DB engines and coverage of other enterprise issues like backup and replication.

4yrs on after the 1st edition I was delighted to see an updated version of this book. The new book is more than double the thickness of the original, covering MySQL right up to v5.1. The good news is that the high density of detailed useful information packed into the original book has been maintained in this edition.

You really get the sense the authors know MySQL like the back of their hands, both in theory and practice and are passionate about getting their knowledge across in the book to help in your real-world applications.

This book is not for beginners learning databases, MySQL or SQL, but must surely be the de-facto reference for performance and enterprise use of MySQL.


2 of 2 people found the following review helpful:
5.0 out of 5 stars Detailed, 15 Jan 2010
By 
Kaj Str�m (Finland) - See all my reviews
(REAL NAME)   
This review is from: High Performance MySQL: Optimization, Backups, Replication, and More (Paperback)
I'm about halfway through reading this book and I've found it extremely enlighting. Though I am not working with applications that require performance of the level this book is referring to, it has taught me lot.

I finally have a clear picture of indexes and I should work with them, designing queries to use indexes and their sometimes not so obvious features. I generally have found this book to be detailed enough, in many cases there are explanation how MySQL works giving you the necessary info on how to design your schema and queries. I personally find it more pleasing to know why I should implement something in a certain way and not just how. This book offers both.

So, even though you might not be after that "High Performance", there's no need to pass this book, it will explain a great deal of MySQL's inner workings and give you tools to a secure and efficient database handling.

Share your thoughts with other customers: Create your own review
 
 
Most Recent Customer Reviews

5.0 out of 5 stars One of the most useful book on the topic
Finally something everybody who manages MySQL databases would like to read. It goes in deep details and covers almost all aspect of the performance issues when dealing with large...
Published 13 months ago by Sergio Paternoster

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
Only search this product's forum
   
Related forums


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges