MySQL administrator's bible

"With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of My...

Full description

Bibliographic Details
Main Author: Cabral, Sheeri
Other Authors: Murphy, Keith
Format: eBook
Language:English
Published: Indianapolis, IN Wiley Pub. 2009
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • Includes bibliographical references and index
  • pt. I. First Steps with MySQL
  • Ch. 1. Introduction to MySQL
  • Ch. 2. Installing and Upgrading MySQL Server
  • Ch. 3. Accessing MySQL
  • pt. II. Developing with MySQL
  • Ch. 4. How MySQL Extends and Deviates from SQL
  • Ch. 5. MySQL Data Types
  • Ch. 6. MySQL Index Types
  • Ch. 7. Stored Routines, Triggers, and Events
  • Ch. 8. MySQL Views
  • Ch. 9. Transactions in MySQL
  • pt. III. Core MySQL Administration
  • Ch. 10. MySQL Server Tuning
  • Ch. 11. Storage Engines
  • Ch. 12. Caching with MySQL
  • Ch. 13. Backups and Recovery
  • Ch. 14. User Management
  • Ch. 15. Partitioning
  • Ch. 16. Logging and Replication
  • Ch. 17. Measuring Performance
  • pt. IV. Extending Your Skills
  • Ch. 18. Query Analysis and Index Tuning
  • Ch. 19. Monitoring Your Systems
  • Ch. 20. Securing MySQL
  • Ch. 21. The MySQL Data Dictionary
  • Ch. 22. Scaling and High Availability Architectures
  • App. A. MySQL Proxy
  • App. B. Functions and Operators
  • App. C. Resources