Apress Access

Expert MySQL

2nd Edition

By Charles Bell

  • eBook Price: $41.99
Buy eBook Buy Print Book
Expert MySQL provides the internals knowledge you need to troubleshoot performance problems, improve query performance, implement high-availability and replication, and to customize MySQL at both the plug-in and the source-code level.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-4659-6
  • 640 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: January 6, 2013
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • DevOps, DBAs, and DBaaS
  • Securing SQL Server
  • Salesforce.com Lightning Process Builder and Visual Workflow
  • Relational Database Programming
  • PHP Development Tool Essentials
  • PHP and MySQL Recipes
Full Description

Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code.

Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL.

  • Shows how to customize MySQL and its storage and authentication engines
  • Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting
  • Covers high-end features such as high-availability and replication

What you’ll learn

  • Learn the inner workings of MySQL
  • Diagnose and improve poorly performing queries
  • Implement high-availablity solutions and replication
  • Modify and debug the server code
  • Build your own pluggable storage engines and authentication modules
  • Implement new SQL functions and syntax
  • Build your own query optimizer

Who this book is for

Expert MySQL is written for systems integrators, software developers, and database administrators who are using MySQL and desire a deeper knowledge of MySQL internals in support of high-end work such as performance troubleshooting, customization of the engine and its plugins, query optimizaion, building of high-availability environments, replication of data, and so forth.

Table of Contents

Table of Contents

  1. Part One - Getting Started with MySQL Development: MySQL and the Open Source Revolution
  2. Part One: Getting Started with MySQL Development: The Anatomy of a Database System
  3. Part One: Getting Started with MySQL Development: A Tour of the MySQL Source Code
  4. Part One - Getting Started with MySQL Development: Test-Driven MySQL Development
  5. Part Two - Extending MySQL: Debugging
  6. Part Two - Extending MySQL: Embedded MySQL
  7. Part Two - Extending MySQL: Adding Functions and Commands to MySQL
  8. Part Two - Extending MySQL: Extending MySQL High Availability
  9. Part Two - Extending MySQL: MySQL Pluggable Authentication
  10. Part Two - Extending MySQL: Building Your Own Storage Engine
  11. Part Three - Advanced Database Internals: Database Systems Internals
  12. Part Three - Advanced Database Internals: Internal Query Representation
  13. Part Three - Advanced Database Internals: Query Optimization
  14. Part Three - Advanced Database Internals: Query Execution
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. The Definitive Guide to MongoDB: Third Edition


      View Book

    2. Digital Asset Management


      View Book

    3. Pro Apache Hadoop


      View Book

    4. Beginning CouchDB


      View Book