| Description |
1 online resource ([712] pages) : illustrations |
|
text file |
| Contents |
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. |
| Summary |
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to thei. |
| Subject |
MySQL (Electronic resource)
|
|
MySQL (Electronic resource) |
|
MySQL (Electronic resource) |
|
SQL (Computer program language)
|
|
SQL (Langage de programmation) |
|
SQL (Computer program language) |
|
SQL (Computer program language) |
| Added Author |
Schwartz, Baron.
|
|
Zawodny, Jeremy D.
High performance MySQL.
|
| Other Form: |
Print version: High performance MySQL. 2nd ed. Beijing ; Farnham : O'Reilly, 2008 9780596101718 (OCoLC)213111589 |
| ISBN |
9780596101718 |
|
0596101716 |
|
9780596154264 |
|
0596154267 |
|
9780596516857 |
|
0596516851 |
|
9780596555160 |
|
0596555164 |
| Standard No. |
9780596101718 |
|
More Resources