High Performance MySQL et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus

Vous l'avez déjà ? Vendez votre exemplaire ici
Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

Commencez à lire High Performance MySQL sur votre Kindle en moins d'une minute.

Vous n'avez pas encore de Kindle ? Achetez-le ici ou téléchargez une application de lecture gratuite.

High Performance MySQL [Anglais] [Broché]

Baron Schwartz , Peter Saitzev , Vadim Tkachenko , Jeremy D. Zawodny , Arjen Lentz , Derek J. Balling
4.7 étoiles sur 5  Voir tous les commentaires (3 commentaires client)

Voir les offres de ces vendeurs.


Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 21,62  
Broché --  
Il y a une édition plus récente de cet article:
High Performance MySQL 3e High Performance MySQL 3e 5.0 étoiles sur 5 (1)
EUR 37,98
En stock.

Offres spéciales et liens associés

Détails sur le produit

  • Broché: 710 pages
  • Editeur : O'Reilly Media, Inc, USA; Édition : 2nd Revised edition (1 juillet 2008)
  • Langue : Anglais
  • ISBN-10: 0596101716
  • ISBN-13: 978-0596101718
  • Dimensions du produit: 23,4 x 17,8 x 4,3 cm
  • Moyenne des commentaires client : 4.7 étoiles sur 5  Voir tous les commentaires (3 commentaires client)
  • Classement des meilleures ventes d'Amazon: 77.597 en Livres anglais et étrangers (Voir les 100 premiers en Livres anglais et étrangers)
  •  Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?

En savoir plus sur les auteurs

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Dans ce livre (En savoir plus)
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Rechercher dans ce livre:

Quels sont les autres articles que les clients achètent après avoir regardé cet article?

Commentaires en ligne 

3 étoiles
2 étoiles
1 étoiles
4.7 étoiles sur 5
4.7 étoiles sur 5
Commentaires client les plus utiles
5.0 étoiles sur 5 La référence 17 novembre 2011
Par Olivier
Ce livre est véritablement une référence pour qui doit administrer un (ou plusieurs) serveur(s) MySQL et veut en tirer les meilleures performances.
Vous pouvez retrouver les auteurs sur un blog réputé : [...]
Attention toutefois : cette édition (la 2e) date de juin 2008. Une troisième édition est prévue pour janvier/février 2012.
Avez-vous trouvé ce commentaire utile ?
4.0 étoiles sur 5 Review of the book 21 mars 2011
Par Gregory
The book is a good source of information. The overall content is of high-quality and tends to explain things to people with no experience, thus covering a broader audience. This said, do not get me wrong, while things are explained for all levels, it sometimes assumes a high-level of knowledge in some topics therefore if you want to understand you sometimes need to go a step further on your own.

What I am not happy with is that the book is too much "theory" orientated and do not walk you through how to do things with the tools in a practical way. For instance, the replication explain you how to gather data (methodology) but you have no example of scp, rsync or LVM snapshot illustrated.

If you buy this book, you will have all the theory but you will have to practice on your own and will have to document yourself on how to do a lot of things. I will probably keep it on my desk as it turns to be one of the only few book out there that will cover most topics.
Avez-vous trouvé ce commentaire utile ?
7 internautes sur 10 ont trouvé ce commentaire utile 
Cette édition-ci, datée de 2008, a été entièrement réécrite par les auteurs de mysqlperformanceblog.com, des experts s'il en est.
Avez-vous trouvé ce commentaire utile ?
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.6 étoiles sur 5  29 commentaires
36 internautes sur 36 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Turbo Charging MySQL 13 novembre 2008
Par Sean P. Hull - Publié sur Amazon.com
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 internautes sur 16 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Huge improvement over 1st edition 4 octobre 2008
Par James Byers - Publié sur Amazon.com
Format:Broché|Achat authentifié par Amazon
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 internautes sur 10 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Amazing must have 29 décembre 2008
Par K. Anderson - Publié sur Amazon.com
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 internautes sur 3 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Excellent book for advanced users 1 septembre 2008
Par Vadim Berezniker - Publié sur Amazon.com
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.
3 internautes sur 3 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Outstanding 6 décembre 2008
Par CA Hofmeyr - Publié sur Amazon.com
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!
Ces commentaires ont-ils été utiles ?   Dites-le-nous
Rechercher des commentaires
Rechercher uniquement parmi les commentaires portant sur ce produit

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Première publication:
Aller s'identifier

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon

Rechercher des articles similaires par rubrique


Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?