High Performance MySQL

✍ Scribed by Zaitsev, Peter;Tkachenko, Vadim;Schwartz, Baron;Zawodny, Jeremy D

• Publisher: O'Reilly Media
• Year: 2012
• Tongue: English
• Edition: 3e edition
• Category: Library

✦ Synopsis

MySQL architecture and history -- Benchmarking MySQL -- Profiling server performance -- Optimizing schema and data types -- Indexing for high performance -- Query performance optimization -- Advanced MySQL features -- Optimizing server settings -- Operating system and hardware optimization -- Replication -- Scaling MySQL -- High availability -- MySQL in the cloud -- Application-level optimization -- Backup and recovery -- Tools for MySQL users -- Forks and variants of MySQL -- MySQL server status -- Transferring large files -- Using EXPLAIN -- Debugging locks -- Using Sphinx with MySQL.

✦ Table of Contents

MySQL architecture and history --
Benchmarking MySQL --
Profiling server performance --
Optimizing schema and data types --
Indexing for high performance --
Query performance optimization --
Advanced MySQL features --
Optimizing server settings --
Operating system and hardware optimization --
Replication --
Scaling MySQL --
High availability --
MySQL in the cloud --
Application-level optimization --
Backup and recovery --
Tools for MySQL users --
Forks and variants of MySQL --
MySQL server status --
Transferring large files --
Using EXPLAIN --
Debugging locks --
Using Sphinx with MySQL.

✦ Subjects

COMPUTERS--Programming Languages--SQL;Relational databases;SQL (Computer program language);Database management;Electronic books;MySQL (Electronic resource);COMPUTERS -- Programming Languages -- SQL