High Performance MySQL 3rd Edition (häftad)

Fler böcker inom

Programmeringsspråk & skriptspråk

Format: Häftad (Paperback)
Språk: Engelska
Antal sidor: 793
Utgivningsdatum: 2012-04-17
Upplaga: 3 Rev ed
Förlag: O'REILLY & ASSOCIATES
Illustratör/Fotograf: Illustrations
Illustrationer: Illustrations
Dimensioner: 230 x 180 x 42 mm
Vikt
Antal komponenter: 1
ISBN: 9781449314286

High Performance MySQL 3rd Edition

Name: High Performance MySQL 3rd Edition
Price: 511.00 SEK
Availability: OutOfStock
Author: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
ISBN: 9781449314286

Optimization, Backups, Replication, and More

av Baron Schwartz, Peter Zaitsev, Vadim Tkachenko

Häftad, Engelska, 2012-04-17

511

Bevaka

Spara som favorit

Tillfälligt slut – klicka "Bevaka" för att få ett mejl så fort boken går att köpa igen.

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

Database Design and Modeling with PostgreSQL and MySQL

Alkin Tezuysal, Ibrar Ahmed, Peter Zaitsev

Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercisesKey FeaturesGet to grips with fundamental-to-advanced database design and modeling conce...

368

Ladda ned

Laddas ned direkt
One-dimensional Functional Equations

Genrich Belitskii, Vadim Tkachenko

The monograph is devoted to the study of functional equations with the transformed argument on the real line and on the unit circle. Such equations systematically arise in dynamical systems, differential equations, probabilities, singularities of ...

1101

Köp

Skickas inom vardagar.

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...