Ebooks

High Performance MySQL 2nd Ed ~tqw~ darksiderg

• 
• 
• Rate this torrent +  |  -

Torrent info

Torrent Files List

Torrent description

*******************************************************************************
High Performance MySQL 2nd Ed.
*******************************************************************************

-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 5,908,984 bytes

-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~

-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
Now that MySQL has proven to be a robust product for large, demanding
environments, both programmers and administrators want more information on how
to get the most out of it. High Performance MySQL goes beyond the basics to
explain how MySQL works "under the hood" so that experienced users can
understand why it's fast and, conversely, what can slow it down. In this new
edition, you'll learn how to maximize the speed and robustness of MySQL through
advanced configuration, and methods to optimize everything from schemas,
queries, server settings and applications to operating systems, and hardware —
topics that typical MySQL books don't cover very well. Other requirements for
scaling MySQL, such as replication, backups, and load balancing, are thoroughly
discussed as well. This is not a book on MySQL theory — it's a collection of
hands-on methods for solving real-world problems, by authors who have the
experience to back it up. High Performance MySQL includes: Clustering solutions
Impacts of new features of MySQL 5.0/5.1, including stored procedures,
partitioned databases, triggers, and views Expanded comparisons of storage
engines and optimization techniques specific to each one Federation (scaling by
dividing data among different servers or different clusters) Optimization of
subqueries Use of the new information schema to retrieve data about the server
and your databases Optimization of advanced querying features, such as full text
searches and the use of cursors With this book, you'll discover good practices
for large demanding environments, and learn about MySQL's weaknesses and how to
work around them. High Performance MySQL offers the advanced solutions you need
toensure asmoothly functioning database-driven website.

Table Of Contents

Foreword
Preface
1. MySQL Architecture
2. Finding Bottlenecks: Benchmarking and Profiling
3. Schema Optimization and Indexing
4. Query Performance Optimization
5. Advanced MySQL Features
6. Optimizing Server Settings
7. Operating System and Hardware Optimization
8. Replication
9. Scaling and High Availability
10. Application-Level Optimization
11. Backup and Recovery
12. Security
13. MySQL Server Status
14. Tools for High Performance
A. Transferring Large Files
B. Using EXPLAIN
C. Using Sphinx with MySQL
D. Debugging Locks
Index

Product Details

* ISBN: 0596101716
* ISBN-13: 9780596101718
* Format: Paperback, 708pp
* Publisher: O'Reilly Media, Incorporated
* Pub. Date: June 2008
* Edition Description: REV
* Edition Number: 2

-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader

related torrents