MySQL 5.1 Plugin Development -- Table of Contents -- MySQL 5.1 Plugin Development -- Credits -- About the Authors -- About the Reviewer -- Preface -- History of the Plugin API -- Idea of this book -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 8. Storage Engine Plugins -- Introducing storage engines -- A read-only storage engine -- ha_text.cc -- Summary -- 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 -- 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 -- A. 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.