High Performance MySQL
Subtitle: Optimization, Backups, Replication, and Load-balancing
Publisher: O'Reilly Media, Inc.; O'Reilly
Published: June 15, 2008
Language: eng
Format: Paperback
Number of pages: 684
ISBN-13: 9780596101718
Copyright date: 2008
Subjects: SQL; Computers; Computers - Languages / Programming; Computer Books: Languages; Data Modeling & Design; Database Management - Database Mining; Programming Languages - SQL; Computers / Languages / Programming; Computers / Programming Languages / SQL; Computers/Data Modeling & Design; Computers/Database Management - Database Mining; replication, backup, performance, optimization, MySQL, SQL, load-balancing, cluster, failover, disaster recovery, database
Description: Second Edition
Table of contents: label: Foreword
title: Foreword
pagenum: ix; label: Preface
title: Preface
pagenum: xi; label: Chapter 1
title: MySQL Architecture
pagenum: 1; label: Chapter 2
title: Finding Bottlenecks: Benchmarking and Profiling
pagenum: 32; label: Chapter 3
title: Schema Optimization and Indexing
pagenum: 80; label: Chapter 4
title: Query Performance Optimization
pagenum: 152; label: Chapter 5
title: Advanced MySQL Features
pagenum: 204; label: Chapter 6
title: Optimizing Server Settings
pagenum: 265; label: Chapter 7
title: Operating System and Hardware Optimization
pagenum: 305; label: Chapter 8
title: Replication
pagenum: 343; label: Chapter 9
title: Scaling and High Availability
pagenum: 409; label: Chapter 10
title: Application-Level Optimization
pagenum: 457; label: Chapter 11
title: Backup and Recovery
pagenum: 472; label: Chapter 12
title: Security
pagenum: 521; label: Chapter 13
title: MySQL Server Status
pagenum: 557; label: Chapter 14
title: Tools for High Performance
pagenum: 583; label: Appendix A
title: Transferring Large Files
pagenum: 603; label: Appendix B
title: Using Explain
pagenum: 607; label: Appendix C
title: Using Sphinx with MySQL
pagenum: 623; label: Appendix D
title: Debugging Locks
pagenum: 650; label: Index
title: Index
pagenum: 659