High Performance MySQL : optimization, backups, replication & load balancing / Jeremy D. Zawodny and Derek J. Balling.

Format:

Book

Author/Creator:

Zawodny, Jeremy D.

Contributor:

Balling, Derek J.

Language:

English

Subjects (All):

Query languages (Computer science).

SQL (Computer program language).

Physical Description:

1 online resource (304 p.)

Edition:

First edition.

Other Title:

MySQL

Place of Publication:

Sebastopol, California : O'Reilly Media, Inc., 2004.

Language Note:

English

System Details:

text file

Summary:

As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics. Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmark

Contents:

High Performance MySQL; Things to Reference as You Read the Rest of the Book; Places to Tune Your Application; Scaling Upward After Making Changes; Make Sure All That Work Isn&t for Naught; The Miscellany; Software Versions and Availability; Conventions Used in This Book; Using Code Examples; How to Contact Us; Acknowledgments; From Derek; 1. Back To Basics; 1.2. Configuration Files; 1.2.2. File Format; 1.2.3. Sample Files; 1.2.4. Reconfiguration; 1.3. The SHOW Commands; 1.3.2. SHOW PROCESSLIST; 1.3.3. SHOW STATUS; 1.3.4. SHOW INNODB STATUS; 2. Storage Engines (Table Types)

2.2. Locking and Concurrency2.2.2. Lock Granularity; 2.2.2.2. Page locks; 2.2.2.3. Row locks; 2.2.3. Multi-Version Concurrency Control; 2.3. Transactions; 2.3.2. Isolation Levels; 2.3.2.2. Read committed; 2.3.2.3. Repeatable read; 2.3.2.4. Serializable; 2.3.3. Deadlocks; 2.3.4. Transaction Logging; 2.3.5. Transactions in MySQL; 2.3.5.2. Implicit commits; 2.3.5.3. Isolation levels; 2.3.5.4. Mixing storage engines in transactions; 2.3.5.5. Simulating transactions; 2.4. Selecting the Right Engine; 2.4.1.2. Backups; 2.4.1.3. Special features; 2.4.2. Practical Examples

2.4.2.2. Read-only or read-mostly tables2.4.2.3. Order processing; 2.4.2.4. Stock quotes; 2.4.2.5. Bulletin boards and threaded discussion forums; 2.4.2.6. CD-ROM applications; 2.4.3. Table Conversions; 2.4.3.2. Dump and reimport; 2.4.3.3. CREATE and SELECT; 2.5. The Storage Engines; 2.5.1.2. Other stuff; 2.5.2. Compressed MyISAM Tables; 2.5.3. RAID MyISAM Tables; 2.5.4. MyISAM Merge Tables; 2.5.5. InnoDB Tables; 2.5.5.2. Locking and concurrency; 2.5.5.3. Special features; 2.5.6. Heap (In-Memory) Tables; 2.5.7. Berkeley DB (BDB) Tables; 3. Benchmarking; 3.2. Benchmarking Strategies

3.3. Benchmarking Tools3.3.2. MySQL super-smack; 3.3.2.2. Configuration; 3.3.3. MyBench: A Home-Grown Solution; 4. Indexes; 4.1.1.2. Multicolumn indexes; 4.1.1.3. Index order; 4.1.1.4. Indexes as constraints; 4.1.1.5. Clustered and secondary indexes; 4.1.1.6. Unique indexes versus primary keys; 4.1.1.7. Indexing NULLs; 4.2. Index Structures; 4.2.2. Hash Indexes; 4.2.3. R-Tree Indexes; 4.3. Indexes and Table Types; 4.3.2. Heap Tables; 4.3.3. BDB Tables; 4.3.4. InnoDB Tables; 4.3.5. Full-Text Indexes; 4.3.6. Index Limitations; 4.3.6.2. Regular expressions; 4.3.6.3. Poor statistics or corruption

4.3.6.4. Too many matching rows4.4. Index Maintenance; 4.4.2. Refreshing Index Statistics; 5. Query Performance; 5.1.2. Parsing, Analysis, and Optimization; 5.1.3. Using EXPLAIN; 5.1.4. Execution; 5.2. Optimizer Features and Oddities; 5.2.2. Index-Based Ordering; 5.2.3. Impossible Queries; 5.2.4. Full-Text Instead of LIKE; 5.3. Identifying Slow Queries; 5.4. Influencing MySQL with Hints; 5.4.2. Index Usage; 5.4.3. Result Sizes; 5.4.4. Query Cache; 5.5. Stupid Query Tricks; 5.5.2. Unions Instead of ORs; 6. Server Performance Tuning; 6.1.2. Memory; 6.1.3. Network; 6.2. RAID

6.2.2. Hardware Versus Software

Notes:

Includes index.

Description based on print version record.

ISBN:

9780596516857

0596516851

9780596555160

0596555164

OCLC:

609840822