Print this page Share

MySQL Administrator's Bible

ISBN: 978-0-470-41691-4
888 pages
May 2009
MySQL Administrator


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 MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
See More

Table of Contents


1. Introduction to MySQL.

2. Installing and Upgrading the MySQL Server.

3. Accessing MySQL.

4. How MySQL Extends and Deviates From SQL.

5. MySQL Data Types.

6. MySQL Index Types.

7. Stored Routines, Triggers and Events.

8. MySQL Views.

9. Transactions in MySQL.

10. MySQL Server Tuning.

11. Storage Engines.

12. Caching with MySQL.

13. Backups, Recovery and Disaster Planning.

14. User Management.

15. Partitioning.

16. Logging and Replication.

17. Measuring Performance.

18. Query Analysis and Index Tuning.

19. Monitoring Your Systems.

20. Securing MySQL.

21. MySQL Data Dictionary.

22. Scaling and High Availability Architectures.

Appendix A. MySQL Proxy.

Appendix B. Functions and Operators.

Appendix C. Resources.


See More


Download TitleSizeDownload
Code and Web chapters for entire book
The attachment contains the code and ReadMe file along with other website chapters for the book
498.37 KB Click to Download
This folder contains the Word documents for the code used throughout the book.
451.20 KB Click to Download
Web files
This folder contains web supplements for chapters 2, 3, 18, and 20.
71.78 KB Click to Download
ReadMe 1.67 KB Click to Download
See More

Buy Both and Save 25%!


MySQL Administrator's Bible (US $60.00)

-and- Beginning Microsoft SQL Server 2012 Programming (US $39.99)

Total List Price: US $99.99
Discounted Price: US $74.99 (Save: US $25.00)

Buy Both
Cannot be combined with any other offers. Learn more.

Related Titles

Back to Top