MySQL 5.1 Plugin Development Table of Contents

Table of Contents

Preface
Chapter 1: Compiling and Using MySQL Plugins
Chapter 2: User Defined Functions
Chapter 3: Daemon Plugins
Chapter 4: Information Schema Plugins
Chapter 5: Advanced Information Schema Plugins
Chapter 6: Full-text Parser Plugins
Chapter 7: Practical Full-text Parsers
Chapter 8: Storage Engine Plugins
Chapter 9: HTML Storage Engine—Reads and Writes
Chapter 10: TOCAB Storage Engine—Implementing Indexes
Appendix: Beyond MySQL 5.1
Index

• Preface

• Chapter 1: Compiling and Using MySQL Plugins
  • UDF libraries
    • Linux
    • Mac OS X
    • Windows
    • Installing a UDF
  • Plugin libraries
    • Linux
    • Mac OS X
    • Windows
    • Installing a plugin
  • Automatic builds, packaging
    • UDFs and standalone plugins
    • Plugins that are built from the MySQL source tree
      • plug.in
      • Makefile.am
      • CMakeLists.txt
  • Summary

• Chapter 2: User Defined Functions
  • Writing UDFs
    • Why write UDFs
    • Installing and using UDFs
    • Defining UDFs
    • Execution sequence of a UDF
    • UDF error handling
    • UDF security
    • Gotchas with UDFs
  • A constant integer output UDF
  • An integer echoing UDF
  • A simple static text output UDF
  • A summing aggregate UDF
  • Further reading
  • Summary

• Chapter 3: Daemon Plugins
  • A look inside a Daemon plugin
    • Why write a Daemon plugin
    • Installing and using Daemon plugins
    • The role of a version
    • Defining Daemon plugins
      • Status variables
      • System variables
  • A Hello World! Daemon plugin
  • A system and status variables demo plugin
  • A simple monitoring plugin
  • System Status Variables plugin
  • Summary

• Chapter 4: Information Schema Plugins
  • Why write Information Schema plugins
    • Installing and using Information Schema plugins
  • The creation of Information Schema plugins
    • Defining Information Schema plugins
  • A Static Table example
  • A System Information plugin
  • Summary

• Chapter 5: Advanced Information Schema Plugins
  • Accessing MySQL internals
  • Condition pushdown
    • Using condition pushdown
    • A condition pushdown example
  • A User Variables Information Schema plugin
  • A Binary Logs Information Schema plugin
  • Summary

• Chapter 6: Full-text Parser Plugins
  • The full-text parser plugin architecture
    • Three roles of a full-text parser plugin
    • Installing and using a full-text parser plugin
    • Structure of a full-text parser plugin
  • A PHP full-text parser
  • Summary

• Chapter 7: Practical Full-text Parsers
  • Boolean parsers
  • A Boolean full-text parser
  • An Image Metadata processor
    • How to access Exif data
    • Writing the plugin
    • Test run
  • A Soundex full-text parser
    • The Soundex algorithm
    • The plugin
    • Trying it out
  • Summary

• Chapter 8: Storage Engine Plugins
  • Introducing storage engines
  • A read-only storage engine
    • ha_text.cc
  • Summary

• Chapter 9: HTML Storage Engine—Reads and Writes
  • An idea of the HTML engine
  • Flashback
  • Creating, opening, and closing the table
  • Reading data
  • Updating the table
  • Optimizing and analyzing
  • What's left
    • ha_html.h
    • htmlutils.cc
  • Compiling and linking
  • Putting it all together
  • Summary

• Chapter 10: TOCAB Storage Engine—Implementing Indexes
  • B-tree library
  • Storage engine API for indexes
  • Describing the engine
  • Creating, opening, and closing the table
  • Searching in the index
  • Rows and keys
  • Table scan and random access
  • Inserting rows
  • What's left
  • Compiling and linking
  • Putting it all together
  • Possible extensions
  • Summary

• Appendix: Beyond MySQL 5.1
  • Server services
    • my_snprintf
    • thd_alloc
  • Audit plugins
  • Authentication plugins
    • How it works
    • Authentication plugins—server side
    • Authentication plugins—client side
  • SQL extension by Storage Engine plugins
    • Putting it to use
    • Test drive
  • Summary

• Index