High Performance MySQL Optimization, Backups, Replication, and More
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 integrit...
| Autor principal: | |
|---|---|
| Otros Autores: | , , , , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly Media
2008.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627503606719 |
Tabla de Contenidos:
- High Performance MySQL, 2nd Edition; Preface; Building a Solid Foundation; Tuning Your Application; Scaling Upward After Making Changes; Making Your Application Reliable; Miscellaneous Useful Topics; Software Versions and Availability; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Acknowledgments for the Second Edition; From Peter; From Vadim; From Arjen; Acknowledgments for the First Edition; From Derek; 1. MySQL Architecture; Optimization and Execution; Concurrency Control; Lock Granularity; Row locks; Transactions; Deadlocks
- Transaction LoggingTransactions in MySQL; Mixing storage engines in transactions; Implicit and explicit locking; Multiversion Concurrency Control; MySQL&s Storage Engines; MyISAM features; Compressed MyISAM tables; The MyISAM Merge Engine; The InnoDB Engine; The Memory Engine; The Archive Engine; The CSV Engine; The Federated Engine; The Blackhole Engine; The NDB Cluster Engine; The Falcon Engine; The solidDB Engine; The PBXT (Primebase XT) Engine; The Maria Storage Engine; Other Storage Engines; Selecting the Right Engine; Considerations; Practical Examples; Read-only or read-mostly tables
- Order processingStock quotes; Bulletin boards and threaded discussion forums; CD-ROM applications; Storage Engine Summary; Table Conversions; Dump and import; CREATE and SELECT; 2. Finding Bottlenecks: Benchmarking and Profiling; Benchmarking Strategies; Benchmarking Tactics; Getting Accurate Results; Running the Benchmark and Analyzing Results; Benchmarking Tools; Single-Component Tools; Benchmarking Examples; sysbench; The sysbench file I/O benchmark; The sysbench OLTP benchmark; Other sysbench features; dbt2 TPC-C on the Database Test Suite; MySQL Benchmark Suite; Profiling
- A PHP profiling exampleMySQL Profiling; Finer control over logging; How to read the slow query log; Log analysis tools; Profiling a MySQL Server; Profiling Queries with SHOW STATUS; SHOW PROFILE; Other Ways to Profile MySQL; When You Can&t Add Profiling Code; Operating System Profiling; Advanced Profiling and Troubleshooting; 3. Schema Optimization and Indexing; Real Numbers; String Types; BLOB and TEXT types; Using ENUM instead of a string type; Date and Time Types; Bit-Packed Data Types; Choosing Identifiers; Special Types of Data; Indexing Basics; Hash indexes; Spatial (R-Tree) indexes
- Full-text indexesIndexing Strategies for High Performance; Prefix Indexes and Index Selectivity; Clustered Indexes; Inserting rows in primary key order with InnoDB; Covering Indexes; Using Index Scans for Sorts; Packed (Prefix-Compressed) Indexes; Redundant and Duplicate Indexes; Indexes and Locking; An Indexing Case Study; Avoiding Multiple Range Conditions; Optimizing Sorts; Index and Table Maintenance; Updating Index Statistics; Reducing Index and Data Fragmentation; Normalization and Denormalization; Pros and Cons of a Denormalized Schema; A Mixture of Normalized and Denormalized
- Cache and Summary Tables
