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

  • 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 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

Book backreference: 
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software