High Performance MySQL optimization, backups, replication & load balancing
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 Za...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media, Inc
2004.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627190406719 |
Tabla de Contenidos:
- 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
