MySQL Notes

Reference

• MySQL Internals Manual
• MySQL 5.7 Reference Manual

MySQL Internals

• Data Types
• MySQL Threads
• The MySQL Plugin API
  • Types of Plugins
  • Plugin API Characteristics
  • Plugin API Components
  • Writing Plugins
  • Plugin Data Structures
• MySQL Services for Plugins
• Writing a Custom Storge Engine
  • Creating the handlerton
  • Handling Handler Instantiation
  • Defining Filename Extensions
  • Creating Tables
  • Opening a Table
  • Closing a Table
  • Implementing Basic Table Scanning
  • Adding Support for INSERT
  • Adding Support for UPDATE
  • Adding Support for DELETE
  • Supporting Non-Sequential Reads
  • Supporting Transactions
  • Supporting Indexing
    • Getting Index Information During CREATE TABLE Operations
    • Creating Index Keys
    • Parsing Key Information
    • Providing Index Information to the Optimizer
    • Implementing Index Methods