High performance MySQL

• Main Authors: Schwartz, Baron (Author), Zaitsev, Peter (Author), Tkachenko, Vadim (Author)
• Format: Book
• Language: English
• Published: Sebastopol : O'Reilly, 2012
• Edition: 3rd ed.
• Subjects: MySQL (databázový systém); databázové systémy; správa databází; relační databáze; MySQL; database management systems; database administration; relational databases; příručky; handbooks, manuals, etc
• ISBN: 9781449314286
• Physical Description: xxviii, 793 s. : il. ; 24 cm

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
• Hight 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