High Performance MySQL : Optimization, Backups, Replication, and More

Format:

Book

Author/Creator:

Schwartz, Baron.

Contributor:

Zaitsev, Peter.

Tkachenko, Vadim.

Zawodny, Jeremy D.

Lentz, Arjen.

Balling, Derek J.

Language:

English

Subjects (All):

MySQL (Electronic resource).

Client/server computing.

Database management.

Mysql (Computer Program Language).

SQL server.

SQL (Computer program language).

Relational databases.

Local Subjects:

Client/server computing.

Database management.

Mysql (Computer Program Language).

SQL server.

Physical Description:

1 online resource (712 p.)

Edition:

2nd ed.

Place of Publication:

Sebastopol : O'Reilly Media, 2008.

Language Note:

English

System Details:

text file

Summary:

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 integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, op

Contents:

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

Notes:

Description based upon print version of record.

Description based on publisher supplied metadata and other sources.

ISBN:

9780596154264

0596154267

9780596554750

0596554753

OCLC:

609840807