Jetzt eintauschen
und EUR 1,60 Gutschein erhalten
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden

Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.
Den Verlag informieren!
Ich möchte dieses Buch auf dem Kindle lesen.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

High Performance MySQL: Optimization, Backups, Replication, and More [Englisch] [Taschenbuch]

Baron Schwartz , Peter Zaitsev , Vadim Tkachenko , Jeremy D. Zawodny , Arjen Lentz , Derek J. Balling
4.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)

Erhältlich bei diesen Anbietern.

Dieses Buch gibt es in einer neuen Auflage:
High Performance MySQL High Performance MySQL 5.0 von 5 Sternen (2)
EUR 35,95
Auf Lager.


1. Juli 2008
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. 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. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: * Emphasis throughout on both performance and reliability * Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine * Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views * A detailed discussion on how to build very large, highly scalable systems with MySQL * New options for backups and replication * Optimization of advanced querying features, such as full-text searches * Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

Hinweise und Aktionen

  • Studienbücher: Ob neu oder gebraucht, alle wichtigen Bücher für Ihr Studium finden Sie im großen Studium Special. Natürlich portofrei.

Kunden, die diesen Artikel angesehen haben, haben auch angesehen


  • Taschenbuch: 708 Seiten
  • Verlag: O'Reilly & Associates; Auflage: 2 (1. Juli 2008)
  • Sprache: Englisch
  • ISBN-10: 0596101716
  • ISBN-13: 978-0596101718
  • Größe und/oder Gewicht: 18 x 3,7 x 23,5 cm
  • Durchschnittliche Kundenbewertung: 4.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 115.154 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)

Mehr über die Autoren

Entdecken Sie Bücher, lesen Sie über Autoren und mehr



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.

Über den Autor und weitere Mitwirkende

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 PETER ZAITSEV, a former manager of the High Performace Group at MySQL AB, now runs the 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 TKANCHENKO 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: ARJEN LENTZ was born in Amsterdam, but now lives in Queensland Australia. Together with Harmony he has a beautiful daughter named Phoebe and a black cat named Figaro. Originally a C programmer, Arjen was employee #25 at MySQL AB (2001-2007), dealing with the MySQL Manual (2001-2004), global Community Relations (2004-2006), the MySQL Users Conference (2005-2006), teaching MySQL Training courses (2001-2007), and MySQL Support Engineering (2006-2007). After a brief break in 2007, Arjen founded Open Query (, which develops and provides its own MySQL and other open source training and consulting services in the Asia Pacific region and beyond, as well as open source business and community strategy advice. DEREK J. BALLING has been a Perl programmer and UNIX/Linux system administrator since 1996, having helped build two different ISPs from the ground up in the midwestern United States. He spent several years of his career at Yahoo!, working in their Infrastructure Group, where he worked on tools to help improve system uptime. He presently works as a system administrator at Vassar College. He has also written articles for The Perl Journal and a number of online magazines. When not working on computer-related issues, Derek relaxes with his two cats in his lakeside residence, and has recently taken up the sport of fencing. He also makes his opinion known on current events or whatever is annoying him lately on his blog at

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Eine digitale Version dieses Buchs im Kindle-Shop verkaufen

Wenn Sie ein Verleger oder Autor sind und die digitalen Rechte an einem Buch haben, können Sie die digitale Version des Buchs in unserem Kindle-Shop verkaufen. Weitere Informationen


5 Sterne
3 Sterne
2 Sterne
1 Sterne
4.0 von 5 Sternen
4.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
0 von 2 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Die Krux mit der Nebenläufigkeit 24. August 2011
Das Buch hat ziemlich alle Fragen, die ich zu MySQL hatte beantwortet. Es geht ausführlich auf die verschiedenen Aspekte der MySQL und auch der Hardware auf der MySQL läuft ein.

Was mich an dem Buch "von Profis für Profis" aber jedesmal auf's Neue ärgert, ist die Übersetzung.

Kannten Sie den Ausdruck "Nebenläufigkeit"? Nein? Ich auch nicht. Gemeint ist "Concurrency". In einem Fachbuch wie diesem erwarte ich mir auch den Fachausdruck "Concurrency". Und wenn er schon übersetzt werden muß, dann bitte korrekt mit "Gleichzeitigkeit". Aus "Views" werden "Sichten", nicht etwa "Ansichten" sondern schlicht "Sichten".

Dafür ziehe ich einen Stern ab. Anonsten liefert das Buch aber wirklich fundiertes Wissen zum Tuning von MySQL, deshalb insgesamt 4 Sterne.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf (beta) 4.6 von 5 Sternen  30 Rezensionen
36 von 36 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Turbo Charging MySQL 13. November 2008
Von Sean P. Hull - Veröffentlicht auf
Well, the first thing you want to do when you finish a book like this is go on and on about how impressed you are. This is one of the best database technology books I've read, and the best one on MySQL.

Digging into the book I would say I was an intermediate DBA. With 12 years experience on Oracle I was a seasoned DBA. And although I've used MySQL for about 10 years, I had not used all of the high end or newest 5.0 and 5.1 features. After reading this book, or while reading it, you'll be ready to dig into everything from MySQL master-master replication (not to be confused with multi-master), creating a logging server, optimizing your query cache, or even using some of the Google MySQL patches to add some much needed but missing feature to MySQL.

The book is organized pretty well. Keep in mind that this is not a beginner book. If you're looking for more general across the board MySQL book, I'd recommend the APress Pro MySQL by Kruckenberg and Pipes Pro MySQL (Expert's Voice in Open Source). It is also very good, but hits more of the beginning topics (as well as some advanced ones). So given the intermediate to advanced audience, this book dives right into benchmarking and profiling at the beginning.

Queries... those pesky SQL commands that you send to your database. They're so important to performance, yet so sadly misunderstood. This book devotes two chapters to the topic, one about schema and index optimization, and one about query performance. These two work together. You need to understand indexing to make best use of them, and how to write good queries to get only the data you need. The indexing chapter hit on index types supported by MyISAM, and ones for InnoDB. It talked about rebuilding, and when it's important, and statistics, and how they are different across the different storage engines. And this is a key point. Going into this book with my Oracle background, I had a lot of questions about how the optimizing engine aka the cost-based optimizer, works and interacts with the storage engines. It's all laid out here in clear detail. It was pretty obvious that these others are closely involved with the actual database development, and/or interviewed some of them to get the information correct. This is something I've had a hard time finding in other books, and really key to understanding how to optimize and tune queries. Where does the query cache sit, when and how are queries parsed, when does the optimizer pickup statistics, and how does it use them. You'll learn all the ins and outs of the explain facility, which you'll of course need to know to tune queries.

The next chapter on advanced features covered the query cache in detail, how to set it up, how to tune it, and how to monitor it. The chapter also covers UDFs, cursors, stored procedures, views, full-text searching, merge tables, partitioning and so on. One other topic it really investigated was distributed (XA) transactions. You might at first think these are an advanced topic that most users don't need to know about unless your application uses them. After all, who needs to query tables in a remote database when your application can connect and do that? Well it turns out MySQL is using XA transactions internally all the time within it's storage engine architecture. One case is when you have a transaction which uses two storage engines, ie tables with different storage engine attributes. But that's not all. MySQL also treats the binary log mechanism to be a storage engine in it's own right, so interaction between your InnoDB table transactions, and the binary log is effectively an XA transaction.

The next two chapters talk about server settings, and optimizing the OS and Hardware. All important topics, and given substantial coverage. Hand these chapters to your storage engine guru, system administrator or read them yourself if you wear all those hats!

A chapter on Replication, of course we expected to find a. What you'll be glad about is that it's 65 pages of the nuts and bolts of using replication after the five minutes it took you to set it up in MySQL. It'll help you keep your databases in sync, and help you identify them when they're not. What, my replication slaves might be out of sync? There is also coverage of the new row-based replication, and how it may help alleviate many of the current limitations of MySQL replication. There is also solid coverage of various replication topologies, from single master and many slaves, to distributed master, master-master, and how to create a logging server. You'll also learn why MySQL doesn't support multi-master replication, which is where both masters received updates, and are forced to resolve conflicts, and a whole host of new problems.

After that come a few chapters on topics outside the database tier, but equally important, from load balancing, to HA, tuning your webserver to caching and so on.

The finishing chapters include backup, security, and using the built-in server status commands. And finally a chapter on other tools for interacting with and monitoring your MySQL database.

Ok, great... a wonderful book. Any criticisms. Well I save those for last because they're really minor. If you read the book cover-to-cover you'll probably take notes like I did, so you'll be doing your own summarization. But at the end of various chapters, so chock full of new and very useful information, I sometimes wished there was exactly that, a summary of the topics, and quick list of bulletpoints. That would give one an easy way to look up advice for tuning specific areas and so on.

All-in-all though this book is really a tour de force for understanding MySQL database technology. Go get a copy!
16 von 16 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Huge improvement over 1st edition 4. Oktober 2008
Von James Byers - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
If you read the first edition and were underwhelmed, this is a vastly improved book. This second edition is entirely rewritten, more than twice as long, and covers a wide array of topics in depth, giving detailed advice and analysis in every chapter. The authors' advice on Innodb tuning, query optimization, and advanced replication issues is very strong. If you are responsible for a non-trivial MySQL installation, get this book.
10 von 10 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Amazing must have 29. Dezember 2008
Von K. Anderson - Veröffentlicht auf
If you have ever so much as sneezed near a MySQL statement you must read this book. I have been using MySQL and reading other books for at least a decade but had no idea how much I didn't know (had never thought of this way). This book is very well written, very useful and practical, detailed for complex concepts but high level for noob-esk items. At first I found the structure odd but after finishing I wouldn't change it. Even if you are not looking for 'performance' there is so much useful MySQL fundamentals clearly explained it is extremely useful. Just as a case in point, I lent it to a graphics designer whoes code is abstracted by an automated framework and it still helped him to make drastic improvements by more clearly understanding the impact his requests had. He has since not only purchased the book but passed it on to several others. Did I mention he was a graphics designer recommending a book about 'that database stuff'?

Hope this helps, best regards and may your coding be bug free...
3 von 3 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Outstanding 6. Dezember 2008
Von CA Hofmeyr - Veröffentlicht auf
The second edition of this book is far superior to any documentation or other books on MySQL that I have read. The content is extremely useful (see the table of contents), the writing is excellent and the explanations and diagrams are so lucid and elegant. The workarounds and other nifty pieces of advice are also valuable. I often couldn't put it down, which is unbelievable for a database text!
3 von 3 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Excellent book for advanced users 1. September 2008
Von Vadim Berezniker - Veröffentlicht auf
The title of this book is very appropriate. Great coverage on performance, reliability, backup & recovery. Definitely not an introductory book.

There were a couple of places where the writing was hard to follow, but I'm sure that'll be fixed in the next printing.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Erster Beitrag:
Eingabe des Log-ins

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen

Ähnliche Artikel finden

Ihr Kommentar