High performance MySQL [electronic resource] / Baron Schwartz, Peter Zaitsev, Vadim Tkachenko.
2012Edition: 3rd edDescription: 1 online resource (xxviii, 793 p.) : illSubject(s): Genre/Form: Additional physical formats: Print version:: High performance MySQL.Online resources:
Description based on print version record.
First ed. by Jeremy D. Zawodny and . 2004.
Includes index.
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.