MySQL 5.1 Plugin Development电子书

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