High Performance MySQL: Optimization, Backups, And Replication de Baron SchwartzHigh Performance MySQL: Optimization, Backups, And Replication de Baron Schwartz

High Performance MySQL: Optimization, Backups, And Replication

deBaron Schwartz, Peter Zaitsev, Vadim Tkachenko

Couverture souple | 2 avril 2012 | Anglais

Détails sur le prix et l’achat

75,20 $ en ligne 
84,50 $ prix courant rabais 11 %
Obtenez 376 points privilègeᴹᴰ

Les prix et les offres peuvent différer de ceux en magasin

Quantité :

En stock en ligne

Cet article est admissible à l’EXPÉDITION GRATUITE pour les commandes de 25 $ et plus.

En vente en magasin


How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

  • Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
  • Implement improvements in replication, high availability, and clustering
  • Achieve high performance when running MySQL in the cloud
  • Optimize advanced querying features, such as full-text searches
  • Take advantage of modern multi-core CPUs and solid-state disks
  • Explore backup and recovery strategies—including new tools for hot online backups
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 Degr...
Titre :High Performance MySQL: Optimization, Backups, And ReplicationFormat :Couverture soupleDimensions :826 pages, 9,19 × 7 × 1,72 poPublié le :2 avril 2012Publié par :O'Reilly MediaLangue :Anglais

Les ISBN ci-dessous sont associés à ce titre :

ISBN - 10 :1449314287

ISBN - 13 :9781449314286


Table des matières

  • Foreword
  • Preface
  • Chapter 1: MySQL Architecture and History
  • Chapter 2: Benchmarking MySQL
  • Chapter 3: Profiling Server Performance
  • Chapter 4: Optimizing Schema and Data Types
  • Chapter 5: Indexing for High Performance
  • Chapter 6: Query Performance Optimization
  • Chapter 7: Advanced MySQL Features
  • Chapter 8: Optimizing Server Settings
  • Chapter 9: Operating System and Hardware Optimization
  • Chapter 10: Replication
  • Chapter 11: Scaling MySQL
  • Chapter 12: High Availability
  • Chapter 13: MySQL in the Cloud
  • Chapter 14: Application-Level Optimization
  • Chapter 15: Backup and Recovery
  • Chapter 16: Tools for MySQL Users
  • Forks and Variants of MySQL
  • MySQL Server Status
  • Transferring Large Files
  • Using EXPLAIN
  • Debugging Locks
  • Using Sphinx with MySQL
  • Colophon