Skip to main content
SpringerLink
Log in
Apress
Book cover

Expert MySQL

  • Book
  • © 2012

Overview

Authors:
  1. Charles Bell
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • SQL provides the internals knowledge you need to troubleshoot performance problems, improve query performance, implement high-availability and replication, and to customize My. SQL at both the plug-in and the source-code level.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 64.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 84.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xxviii
    Download chapter PDF

  2. Getting Started with MySQL Development

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. MySQL and The Open Source Revolution

      • Charles Bell
      Pages 3-21

    3. The Anatomy of a Database System

      • Charles Bell
      Pages 23-56

    4. A Tour of the MySQL Source Code

      • Charles Bell
      Pages 57-115

    5. Test-Driven MySQL Development

      • Charles Bell
      Pages 117-149

  3. Extending MySQL

    1. Front Matter

      Pages 151-151
      Download chapter PDF

    2. Debugging

      • Charles Bell
      Pages 153-193

    3. Embedded MySQL

      • Charles Bell
      Pages 195-250

    4. Adding Functions and Commands to MySQL

      • Charles Bell
      Pages 251-280

    5. Extending MySQL High Availability

      • Charles Bell
      Pages 281-338

    6. Developing MySQL Plugins

      • Charles Bell
      Pages 339-368

    7. Building Your Own Storage Engine

      • Charles Bell
      Pages 369-452

  4. Advanced Database Internals

    1. Front Matter

      Pages 453-453
      Download chapter PDF

    2. Database System Internals

      • Charles Bell
      Pages 455-463

    3. Internal Query Representation

      • Charles Bell
      Pages 465-494

    4. Query Optimization

      • Charles Bell
      Pages 495-541

    5. Query Execution

      • Charles Bell
      Pages 543-585

  5. Back Matter

    Pages 587-611
    Download chapter PDF
Back to top

About this book

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

About the author

Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is the team lead for the MySQL Utilities team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker focusing on microcontroller projects and refinement of three-dimensional printers. Dr. Bell maintains a blog on his research projects and many other interests. You can find his blog at http://drcharlesbell.blogspot.com/.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation