High Performance MySQL 3rd Edition (häftad)
Häftad (Paperback)
Antal sidor
3 Rev ed
230 x 180 x 42 mm
1280 g
Antal komponenter
High Performance MySQL 3rd Edition (häftad)

High Performance MySQL 3rd Edition

Optimization, Backups, Replication, and More

Häftad Engelska, 2012-04-17
Skickas inom 2-5 vardagar.
Fri frakt inom Sverige för privatpersoner.
How can you bring out MySQLs full power? With High Performance MySQL, youll 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 MySQLs principles in action. With this book, youll 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 strategiesincluding new tools for hot online backups
Visa hela texten

Passar bra ihop

  1. High Performance MySQL 3rd Edition
  2. +
  3. Effective MySQL Backup and Recovery

De som köpt den här boken har ofta också köpt Effective MySQL Backup and Recovery av Ronald Bradford (häftad).

Köp båda 2 för 698 kr


Har du läst boken? Sätt ditt betyg »

Bloggat om High Performance MySQL 3rd Edition

Övrig information

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.


Foreword; Preface; How This Book Is Organized; Software Versions and Availability; Conventions Used in This Book; Using Code Examples; Safari Books Online; How to Contact Us; Acknowledgments for the Third Edition; Acknowledgments for the Second Edition; Acknowledgments for the First Edition; Chapter 1: MySQL Architecture and History; 1.1 MySQLs Logical Architecture; 1.2 Concurrency Control; 1.3 Transactions; 1.4 Multiversion Concurrency Control; 1.5 MySQLs Storage Engines; 1.6 A MySQL Timeline; 1.7 MySQLs Development Model; 1.8 Summary; Chapter 2: Benchmarking MySQL; 2.1 Why Benchmark?; 2.2 Benchmarking Strategies; 2.3 Benchmarking Tactics; 2.4 Benchmarking Tools; 2.5 Benchmarking Examples; 2.6 Summary; Chapter 3: Profiling Server Performance; 3.1 Introduction to Performance Optimization; 3.2 Profiling Your Application; 3.3 Profiling MySQL Queries; 3.4 Diagnosing Intermittent Problems; 3.5 Other Profiling Tools; 3.6 Summary; Chapter 4: Optimizing Schema and Data Types; 4.1 Choosing Optimal Data Types; 4.2 Schema Design Gotchas in MySQL; 4.3 Normalization and Denormalization; 4.4 Cache and Summary Tables; 4.5 Speeding Up ALTER TABLE; 4.6 Summary; Chapter 5: Indexing for High Performance; 5.1 Indexing Basics; 5.2 Benefits of Indexes; 5.3 Indexing Strategies for High Performance; 5.4 An Indexing Case Study; 5.5 Index and Table Maintenance; 5.6 Summary; Chapter 6: Query Performance Optimization; 6.1 Why Are Queries Slow?; 6.2 Slow Query Basics: Optimize Data Access; 6.3 Ways to Restructure Queries; 6.4 Query Execution Basics; 6.5 Limitations of the MySQL Query Optimizer; 6.6 Query Optimizer Hints; 6.7 Optimizing Specific Types of Queries; 6.8 Case Studies; 6.9 Summary; Chapter 7: Advanced MySQL Features; 7.1 Partitioned Tables; 7.2 Views; 7.3 Foreign Key Constraints; 7.4 Storing Code Inside MySQL; 7.5 Cursors; 7.6 Prepared Statements; 7.7 User-Defined Functions; 7.8 Plugins; 7.9 Character Sets and Collations; 7.10 Full-Text Searching; 7.11 Distributed (XA) Transactions; 7.12 The MySQL Query Cache; 7.13 Summary; Chapter 8: Optimizing Server Settings; 8.1 How MySQLs Configuration Works; 8.2 What Not to Do; 8.3 Creating a MySQL Configuration File; 8.4 Configuring Memory Usage; 8.5 Configuring MySQLs I/O Behavior; 8.6 Configuring MySQL Concurrency; 8.7 Workload-Based Configuration; 8.8 Completing the Basic Configuration; 8.9 Safety and Sanity Settings; 8.10 Advanced InnoDB Settings; 8.11 Summary; Chapter 9: Operating System and Hardware Optimization; 9.1 What Limits MySQLs Performance?; 9.2 How to Select CPUs for MySQL; 9.3 Balancing Memory and Disk Resources; 9.4 Solid-State Storage; 9.5 Choosing Hardware for a Replica; 9.6 RAID Performance Optimization; 9.7 Storage Area Networks and Network-Attached Storage; 9.8 Using Multiple Disk Volumes; 9.9 Network Configuration; 9.10 Cho...